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 33 (324 total posts) < 1 second(s)
  • Thank *you* for my SQL Server MVP Award…

    Today, I was awarded (at least) one more time with the Microsoft MVP Award. This makes 12 years, and with this, my 11th renewal, I have yet to feel like it is something I can take for granted (you dont want to be around me the last week of September!). It has been a great time so far, and I have no idea how many years I will be back (admittedly, ...
    Posted to Louis Davidson (Weblog) by drsql on October 1, 2015
  • Heading to Orlando for SQL Saturday again this year

    Last year, I attended SQL Saturday Orlando again after missing a few years (I did my first database design precon there a few years back). I love the way they run their event, and as speakers, we did some fun stuff like being the ones that served lunch to the attendees. This year, I wasnt sure if I had a chance to go, because I had scheduled a ...
    Posted to Louis Davidson (Weblog) by drsql on September 26, 2015
  • Snapshot Isolation Level and Concurrent Modification Collisions - On Disk and In Memory OLTP

    This is part 1 of my In Memory OLTP blogs for my upcoming book project. In this blog I want to take a (reasonably) quick look at how concurrent modifications are handled using SNAPSHOT isolation level. There are two different flavors of SNAPSHOT Isolation level you can deal with, and while they are similar, there are some very big differences ...
    Posted to Louis Davidson (Weblog) by drsql on August 13, 2015
  • Utility to reset a sequence next value based on a table/sequence relationship

    So I was building a database the other day, and I used sequence objects for all of the defaults because it was FAR easier to load data into the table not needing to set identity_insert on and off over and over and over. Worked great. Went through all of my tests, everything was great. Got out Redgate Data Generator to load up a few hundred ...
    Posted to Louis Davidson (Weblog) by drsql on July 22, 2015
  • Upcoming Speaking Engagements in Indianapolis and Louisville

    Mercy, July is flying past at breakneck pace isn't it? The best part of July passing into the history books is that August has me speaking at two SQL Saturday's, one of them being a first time for me. On August 8 I will travel up to Indianapolis for SQL Saturday #402, a city I have been to a few times previously but not for a SQL Saturday. My ...
    Posted to Louis Davidson (Weblog) by drsql on July 18, 2015
  • re: Temporal Tables – Part 2 – Changing history

    @Kevin Yeah, I haven't even started to consider that task just yet. Hopefully we get a better story eventually, but if not, I expect tools like Red Gate SQL Compare will take care of the heavy lifting of changing the temporal table (and setting up the saving of the history data as well.)
    Posted to Louis Davidson (Weblog) by drsql on July 8, 2015
  • re: Time to Start Plotting My 2016 Database Design Book

    @Ekrem Good points. Definitely stuff that I need to at least mention if not actually include sample code.
    Posted to Louis Davidson (Weblog) by drsql on July 8, 2015
  • re: Temporal Tables – Part 2 – Changing history

    @Marcel Thanks! @Dan good point, and I have just added to the blog to cover this. If you do the ALTER in a transaction, you will e able to safely change the structure without any worry with other connections being able to change the data (or even view the data for that matter!)
    Posted to Louis Davidson (Weblog) by drsql on July 1, 2015
  • Temporal Tables – Part 2 – Changing history

    After my post yesterday, I had planned to take a break for Independence Day holiday, but a commenter asked a question that piqued my interest. How might you edit history? Well, the answer is simple, but the process isnt exactly simple. Basically, you have to turn off system versioning, update history, and reapply system versioning. Not difficult, ...
    Posted to Louis Davidson (Weblog) by drsql on June 30, 2015
  • re: Temporal Tables – Part 1 - Simple Single Table Example

    Marcel: Not totally sure what you mean about error rows (constraint/trigger/rollbacks? they would go away... Which I will show in a later test I am sure), or do you mean rows at a time? At any given slice of time, all constraints and such that were in effect should show up as in effect. Faking up some data I am not 100% sure. You can specify your ...
    Posted to Louis Davidson (Weblog) by drsql on June 30, 2015
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement