THE SQL Server Blog Spot on the Web

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

Search

You searched for the word(s):
Showing page 1 of 38 (378 total posts) < 1 second(s)
  • 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 (https://docs.microsoft.com/en-us/sql/t-sql/data-types/rowversion-transact-sql)&#160; 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;http://rva.pass.org/) 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
1 2 3 4 5 Next > ... Last »
Privacy Statement