THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |


You searched for the word(s):
Showing page 1 of 38 (373 total posts) < 1 second(s)
  • This is my most difficult SQLBlog post ever…and almost certainly, my last

    The pain of parting is nothing to the joy of meeting again - Charles Dickens It amazes me, but I have blogged here for over 11 years. My first post was about some new functionality in SQL Server 2005, Service pack 2. It was cross posted to, where my original blog was hosted. No introduction post, just right into things. Back ...
    Posted to Louis Davidson (Weblog) by drsql on January 8, 2018
  • SQL Saturday Nashville: I'm Speaking

    Going home y'all. On January 13th, I will be speaking at the Nashville SQL Saturday. I moved from Nashville less than 1 year ago, and I always look forward to making a trip up (and not just for hot chicken at Big Shakes, though it does figure into it.) Tamera Clark and team&nbsp;always do a great job, and the list of speakers that I get to hear ...
    Posted to Louis Davidson (Weblog) by drsql on January 3, 2018
  • Post-PASS Summit Resolutions 2017

    Another PASS Summit has passed, and I have had a bit of time to consider what I want to do with the time of the week that &quot;normal&quot; people call &quot;free time.&quot; While during November and December, I do my best to actually take some of that, I kind of find the whole thing kind of weird. Watching TV, going to movies, decorating the ...
    Posted to Louis Davidson (Weblog) by drsql on November 17, 2017
  • PASS Summit 2017 Followup

    Ah, back home in my comfy work chair, feet up surrounded by the warm glow of computer monitors with the football game on (and at the right time, not 3 hours too early!) It was quite a week, and I learned more stuff this year than normal, and have a few nuggets I really should have known before, that I know now. I will say that there was an ...
    Posted to Louis Davidson (Weblog) by drsql on November 5, 2017
  • PASS 2016 Resolutions Followup

    Wow, it's been over a year now since I made my second round of foolish promises and plans. Now I take a quick pass at saying how I did at these promises before the major annual gathering of SQL Server loving needs called the PASS Summit. Like all resolutions, you win some, you lose some. But I have stayed busy, so busy that I didn't finish this ...
    Posted to Louis Davidson (Weblog) by drsql on October 31, 2017
  • Preparing for my Freecon Session

    Deep breath. There is two weeks and two day before the PASS Summit. And like the past few years, I didn't submit any sessions, so those three days will be nonstop learning and chilling with all of the SQL family who makes it to Seattle. But two weeks and one days from now is the &quot;Seattle SQL Pro Workshop 2017&quot;, AKA the Seattle Freecon ...
    Posted to Louis Davidson (Weblog) by drsql on October 16, 2017
  • How the rowversion datatype works when adding and deleting columns

    For years, I had thought (and was probably taught in SQL.AlongTimeAgoInAPlaceFarFarAway) that the timestamp column (well before rowversion was a thing,) was not guaranteed to be an ever increasing value. But this is not the case. In BOL (; it ...
    Posted to Louis Davidson (Weblog) by drsql on September 26, 2017
  • re: Geek City: Changing How To Change Your Database Properties — ALTER DATABASE

    Excellent! &nbsp;I learned something the easy way today, by reading your blog! &nbsp;I find there are so many features I don't see because I am too busy with other ones. I just blogged about AT TIME ZONE, and I only recently learned of the READCOMMITTEDLOCK hint. Keeps life exciting, I reckon.
    Posted to Kalen Delaney (Weblog) by drsql on September 23, 2017
  • Doing a book signing at the DataCore booth at Microsoft Ignite!

    If you are in the intersection of these two groups: Doesn't currently have a copy of my current database design book, or wants to give one to a friend who architects poor databases Will be attending the Microsoft Ignite Conference Then I have a great deal for you. The middle four days of the Microsoft's Ignite conference in Orlando, I ...
    Posted to Louis Davidson (Weblog) by drsql on September 19, 2017
  • Temporal Tables - Part 6 - Start and End Times in UTC Time Zone

    In my first 5 blogs on Temporal, I failed to note something pretty important about their usage. The start and end times for the row (and it follows, the historical rows) are likely not in your local time zone. They are stored in UTC time zone. This is obviously good because of that pesky daylight saving time issue where 1:30 AM occurs twice each ...
    Posted to Louis Davidson (Weblog) by drsql on September 17, 2017
1 2 3 4 5 Next > ... Last »
Privacy Statement