THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » t-sql » Database design   (RSS)
Showing page 1 of 2 (12 total posts)
  • 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 isn’t 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
  • 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
  • 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
  • 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
  • Relational Database Design Pre-Con at PASS

    Well, here we go again.  I am making my final preparations again for my ''How to Design a Relational Database'' pre-conference seminar coming up at PASS. If you want to know what the ''official'' abstract is, you can find it here and if you are already convinced and have credit card in hand, click here and register before the price ...
    Posted to Louis Davidson (Weblog) by drsql on September 9, 2013
  • Busy months ahead

    Almost two months have passed since my last blog post. And while it’s true that I’ve had (much) longer breaks, I do have a good reason now. All the time that I would normally at least in part spend on preparing new blog posts is now reserved for preparing presentations for a few upcoming events. I’ll give you an overview – who knows, maybe you’ll ...
  • Security – how to assign rights to database objects

    A few days ago my team mate asked me to check out why one of the logins doesn’t have right to execute to a few stored procedures. Allegedly it had the right before. After a few minutes of digging in the source control it turned out that these procedures were scripted with explicit EXECUTE rights to them. However, some later updates to the code did ...
    Posted to Piotr Rodak (Weblog) by on April 10, 2011
  • BNF – how to read syntax?

    A few days ago I read post of Jen McCown (blog) about her idea of blogging about random articles from Books Online. I think this is a great idea, even if Jen says that it’s not exciting or sexy. I noticed that many of the questions that appear on forums and other media arise from pure fact that people asking questions didn’t bother to read and ...
    Posted to Piotr Rodak (Weblog) by on December 7, 2010
  • Setting reporting database–what happens behind the scenes

    When you install reporting server, you have in general two options available – either you install the reporting server and configure its database at the same time, or install just reporting service and point it to an existing database later. We had recently opportunity to configure server to point to existing reporting database. We encountered a ...
    Posted to Piotr Rodak (Weblog) by on November 28, 2010
  • DEFAULT constraints and sp_bindefault

    When you deal with old databases, with origins somewhere around second half of nineteen nineties, you can expect all kinds of oddities, like funny naming conventions, (lack of) referential integrity, absence of clustered indexes and things like rules and defaults created separately from tables DDL. I just happen to work with such database. I see ...
    Posted to Piotr Rodak (Weblog) by on September 20, 2010
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement