Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Discuss Share Learn

Top Forum Users

The top ranked users for the past 30 days:

Google Ads

3

T-SQL Tuesday #59: My Hero

This month’s T-SQL Tuesday is hosted by Tracy McKibben (blog | twitter) and is all about heroes (not the TV show). Ada Lovelace has been an inspiration to many. In keeping with my blog theme, let’s call her a hero. We all have our heroes, those people who we admire, who inspire us, who we […]

Read More...
4

Beware the defaults! (in windowing functions)

Some time ago I was writing some windowing functions on a set of data. Basically I was looking for the last date an event had occurred for each type of event. Let’s illustrate with an example: CREATE TABLE dbo.TestOver (ID INT IDENTITY(1,1) PRIMARY KEY NOT NULL ,[Group] CHAR(1) NOT NULL ,Value INT NOT NULL); INSERT […]

Read More...
0

SQL Server Days 2014 – Slide deck

SQL Server Days 2014 is over, but it has been one great event. A very big thanks to the organizers! My session went pretty well, somewhere around 60 attendees I would guess and they didn’t seem too bored. I saw some other great sessions as well, such as Buck Woody (twitter) on Big Data (and […]

Read More...
0

Book Review: Fundamentals of SQL Server 2012 Replication

I’ve been working with transactional replication in SQL Server a lot this year. A lot. I understood the basics of how it worked, but I wanted to know more – particularly about security, how log readers work, monitoring, and troubleshooting. So, I downloaded a free e-book from Simple Talk, Fundamentals of SQL Server 2012 Replication […]

Read More...
0

October Presentations

This year is flying by! September has been an excellent month. My 24 Hours of PASS Summit preview session went well, speaking for user groups is always encouraging, and IT/Dev Connections was a blast! Now, on to October! First up, I’m presenting at my user group, FoxPASS, in Appleton, WI on Wednesday, October 1. I’ll […]

Read More...
0

PASS elections are here, and this is who I’m supporting

It’s time for the annual PASS Board of Directors elections! If you work with SQL Server and aren’t familiar with the PASS organization, please take a few minutes to check it out. (Also note that if you aren’t a member yet, you won’t be able to vote this year.) PASS offers data professionals networking and […]

Read More...
0

Who I am voting for – PASS Board

All this negative junk flying around makes for a waste of a lot of time. Negative is good but there is always a positive. Although, I’m thinking…how about the real reason of me telling you I am voting for my friend, Grant Fritchey? Honestly, look at him Such a cuddly little teddy bear. How can […]

Read More...
9

The Magic Alt Button

Lately I have been using more and more the awesomeness of the Alt-button in SQL Server Management Studio (SSMS). What do I mean with this? While holding the Alt-button on your keyboard, you can select a block of text instead of lines of text. Note that this is not an exclusive feature, you can do […]

Read More...
0

Setup IaaS in Azure for SQL Server

Prior to full support for availability group listeners in Azure, we were forced to use availability groups without a key feature that makes them truly valuable – listener entry points.  A listener is the same concept as a cluster name in the FCI days.  Essentially, we look at a listener as the single point of […]

Read More...
4

Split a Query Window in SSMS

SQL Server Management Studio (SSMS) has a lot of cool little tips and tricks. Last night, while presenting for 24 Hours of PASS, I used the Window Split function and noticed a few “oohs” and “aaahs” on Twitter. Here’s how you do it. Open a query in SSMS. In this case, I was looking at […]

Read More...
Next Page »