THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Data modeling » relational model   (RSS)
  • Data Modeling Resources

    You can find many different data modeling resources. It is impossible to list all of them. I selected only the most valuable ones for me, and, of course, the ones I contributed to. Books Chris J. Date: An Introduction to Database Systems – IMO a “must” to understand the relational model correctly. Terry Halpin, Tony Morgan: ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on June 10, 2014
  • Working with Temporal Data in SQL Server

    My third Pluralsight course, Working with Temporal Data in SQL Server, is published. I am really proud on the second part of the course, where I discuss optimization of temporal queries. This was a nearly impossible task for decades. First solutions appeared only lately. I present all together six solutions (and one more that is not a solution), ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on May 29, 2014
  • Truncate Table – DDL or DML Statement?

    Many times, categories of concepts and things overlap. It can be hard to categorize some items in a single category. The SQL TRUNCATE TABLE statement is an example of an item that is not so easy to categorize. Is it a DDL (Data Definition Language) or DML (Data Manipulation Language) statement? There is an ongoing discussion about this topic. ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on March 28, 2014
  • Central Europe Trip with a Reason

    Why wouldn’t you make a nice trip in Central Europe? Besides spending some nice days in beautiful cities, you have also a business-type excuse for the trip. You can join the two SQL Saturday events. The first one is going to take place in Budapest, March 1st, and the second one in Vienna, March 6th. I am very happy to meet the SQL community ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on February 22, 2014
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement