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 » 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
  • DBDebunk is back!

    After saveral years of silence, Fabian Pascal, has started to work again on its DB Debunkings website! The site has now been moved on blogspot and can be found here http://dbdebunk.blogspot.it/ The website is just a *great* resource for everyone involved in the DB space, and if you never heard of it before, it’s now time to discover it. Fabian ...
    Posted to Davide Mauri (Weblog) by manowar on August 9, 2012
  • PASS BOF Lunch – SQL Server and NoSQL alternatives

    Beside my BI workshop on Friday, this year at PASS Summit I’ll also contribute by participating at the Birth Of Feather Lunch on a very hot topic: “SQL Server and the NoSQL Alternatives” I’ve been watching closely the NoSQL movement right from the beginning (as soon as it started to grow also in Italy, so from January 2010), since I simply love ...
    Posted to Davide Mauri (Weblog) by manowar on October 13, 2010
  • Does NoSQL people really want to drop the relational model?

    In these last days I’ve talked a lot with developers to understand why the “NoSQL” idea fascinates them so much. Or, put in other words, why they think that leaving RDBMS behind will help them. Well, rephrasing again, I can formulate the question in a more direct form: “What you don’t like of RDBMS, that brings you to ask such huge change?” I’d ...
    Posted to Davide Mauri (Weblog) by manowar on October 2, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement