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 32 (316 total posts) < 1 second(s)
  • 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
  • Temporal Tables – Part 1 - Simple Single Table Example

    In my first entry in my series of posts on DB Design Book Topics, I want to start with a pretty interesting topic, Temporal Tables. It is a very cool new feature that takes something that used to be very painful (capturing history of changes to a table, allowing the user to see the data at a point in time), and makes it very easy. So if you have ...
    Posted to Louis Davidson (Weblog) by drsql on June 29, 2015
  • Speaking this week at #sqlsatChattanooga and for the PASS Performance Virtual Chapter

    The topic for both sessions will be: How In-Memory Database Objects Affect Database Design and the following is the abstract: With SQL Server 2014, Microsoft has added a major new feature to help optimize OLTP database implementations by persisting your data primarily in RAM. Of course it isn't that simple, internally everything that uses this ...
    Posted to Louis Davidson (Weblog) by drsql on June 21, 2015
  • re: Time to Start Plotting My 2016 Database Design Book

    Thanks Chris! Awesome feature, totally forgot about it.
    Posted to Louis Davidson (Weblog) by drsql on June 18, 2015
  • Time to Start Plotting My 2016 Database Design Book

    Note: A new version has been talked about for years, but it is not a guarantee. This post is my way of introducing the new features of SQL Server, and follow on posts will be code filled example of how the features will work. I am making no promises at this time, but when I can, I will. With the recent release of a CTP version of what is called ...
    Posted to Louis Davidson (Weblog) by drsql on June 16, 2015
  • ANY and ALL, Two Keywords I Had Never Taken the Time to Understand

    As I am starting to prepare for an upcoming blog series on database designs and associated query patterns (stay tuned!) I was thinking about what query keywords I don't really know well enough. ANY and ALL were two keywords that immediately popped into my mind that I had never really used (and I probably should have.) ANY and ALL are used as ...
    Posted to Louis Davidson (Weblog) by drsql on June 13, 2015
  • re: Creating and using a Time (not Date) Table/Dimension

    Sorry Pedro, I totally missed this when I was in the hospital and haven't blogged much since then as I have been recovering physically and (perhaps more importantly) mentally. Really, whatever works is great, I have just always tended to use the number of time units for the key as it is contiguous. For my date dimension, I do use a smart number ...
    Posted to Louis Davidson (Weblog) by drsql on June 12, 2015
  • Classic Music, Attractions, and Presentations: Presenting on Database Design at SQL Saturday Atlanta 2015

    This next two weeks are going to be awesome. May 11, I get to see the Who for probably the last time ever. Saturday I am speaking on Database Design at SQL Saturday in Atlanta, then heading to Disney World.&nbsp; It rarely gets even close to this good for a two week span, and SQL Saturday is a big part of that. I love going to SQL ...
    Posted to Louis Davidson (Weblog) by drsql on May 8, 2015
  • Off to Richmond for SQL Saturday

    I got the email prodding speakers to blog about our upcoming sessions, so I got myself up and started to write this blog. It has been such a long time since I have done much side SQL work (other than doing quite a bit of tech editing, along with doing some work for PASS leading up to speaker submissions), that my blog didn't even show up in the ...
    Posted to Louis Davidson (Weblog) by drsql on March 13, 2015
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement