Subscribe: Louis Davidson
Added By: Feedage Forager Feedage Grade B rated
Language: English
chattanooga  nashville  pass summit  pass  read pass  read  scenic city  speaking  sql server  sql  start end  summit  time zone  time 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: Louis Davidson

Louis Davidson


This is my most difficult SQLBlog post ever…and almost certainly, my last

Mon, 08 Jan 2018 23:24:00 GMT

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,...(read more)(image)

SQL Saturday Nashville: I'm Speaking

Thu, 04 Jan 2018 05:03:00 GMT

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.)...(read more)(image)

Post-PASS Summit Resolutions 2017

Fri, 17 Nov 2017 21:37:28 GMT

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 "normal" people call "free time." While during November and December, I do my best to actually take some of that,...(read more)(image)

PASS Summit 2017 Followup

Mon, 06 Nov 2017 03:53:00 GMT

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...(read more)(image)

PASS 2016 Resolutions Followup

Tue, 31 Oct 2017 07:13:09 GMT

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,...(read more)(image)

Preparing for my Freecon Session

Tue, 17 Oct 2017 02:04:33 GMT

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...(read more)(image)

How the rowversion datatype works when adding and deleting columns

Wed, 27 Sep 2017 02:49:59 GMT

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 ( more)(image)

Doing a book signing at the DataCore booth at Microsoft Ignite!

Wed, 20 Sep 2017 04:13:57 GMT

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...(read more)(image)

Temporal Tables - Part 6 - Start and End Times in UTC Time Zone

Mon, 18 Sep 2017 02:56:50 GMT

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...(read more)(image)

Using AT TIME ZONE to manipulate and convert time zones

Sat, 02 Sep 2017 02:48:51 GMT

I have a series of blogs about temporal tables in SQL Server 2016, which you can see here . However, one thing I never had mentioned was that the Temporal Row Start and End Times are always stored in UTC times (which is generally inconvenient to work...(read more)(image)

Row Level Security and Indexed Views

Mon, 14 Aug 2017 01:12:58 GMT

I was giving my Row Level Security session last weekend for the Richmond User Group ( @RichmondSQL and a question came up (ok, so I technically asked the question). How does the feature work with indexed views? Generally speaking,...(read more)(image)

Scenic City Summit is this Friday

Tue, 25 Jul 2017 00:33:27 GMT

Scenic City Summit is a one day conference in Chattanooga, the Scenic City Summit is a new experience for me, although in a familiar, Devlink-esqe setting of the Chattanooga Convention Center in Chattanooga, TN. I am looking forward to attending, and...(read more)(image)

50ths… SQL Saturday and Life

Wed, 12 Jul 2017 01:30:00 GMT

This week I will experience a couple of events associated to the number 50. SQL Saturday Atlanta The second will be my 50th SQL Saturday Event! (49th speaking, 1 attended in casual mode… 50th speaking Saturday will be in August at SQL Saturday Louisville)....(read more)(image)

SQL Saturday Chattanooga is THIS WEEK!

Thu, 22 Jun 2017 00:11:00 GMT

My goodness how time does fly. It seems like just a few months ago I was going to my hometown SQL Saturday in Nashville, and now here I go again to my NEW hometown SQL Saturday in Chattanooga, TN. Much like the Nashville event, I didn't really do anything...(read more)(image)

Father, Son, Daughter, and SQL

Sun, 18 Jun 2017 22:33:21 GMT

I don't love Father's Day. Mostly because I spoke to my father for the last time on Father's day back in 1996. He wasn't feeling well, we exchanged a few pleasantries, and the words I remember were: "I don't feel well, let me give you to your mother."...(read more)(image)