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 (375 total posts) < 1 second(s)
  • 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
  • Using AT TIME ZONE to manipulate and convert time zones

    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 with unless you are from the Great Britain area).&#160; However, when you are looking at your data ...
    Posted to Louis Davidson (Weblog) by drsql on September 1, 2017
  • Row Level Security and Indexed Views

    I was giving my Row Level Security session last weekend for the Richmond User Group (@RichmondSQL&#160; and a question came up (ok, so I technically asked the question). How does the feature work with indexed views? Generally speaking, the answer turned out to be obvious. You can apply a RLS Security Policy to a view that has ...
    Posted to Louis Davidson (Weblog) by drsql on August 13, 2017
  • Scenic City Summit is this Friday

    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 seeing a couple of fellow Microsoft MVP's do keynotes: Cory House and David Neal. I have never ...
    Posted to Louis Davidson (Weblog) by drsql on July 24, 2017
  • 50ths… SQL Saturday and Life

    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).&nbsp; This weekend is SQL Saturday Atlanta. It is one of my favorite events, not just for ...
    Posted to Louis Davidson (Weblog) by drsql on July 11, 2017
  • re: Creating FOREIGN KEY constraints as enabled, trusted, non-trusted, and/or disabled

    @Brenda Sorry I didn't see your comment earlier. I hope you see the latest post in the series. It really works pretty well. @John. You wouldn't really want them that way. But if you have a really large table, you may not be able to re-trust them all in some cases. It definitely will cause there to be less information about the columns for the ...
    Posted to Louis Davidson (Weblog) by drsql on July 11, 2017
1 2 3 4 5 Next > ... Last »
Privacy Statement