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 6 (51 total posts) < 1 second(s)
  • PASS SQL Saturday #356 Slovenia – Details for my Countrymen

    For a change, I am posting a blog in Slovenian language. I am posting the details about PASS SQL Saturday #356 Slovenia. Of course, everybody is invited to attend the conference, submit proposals, or even join us as a sponsor. The vast majority of presentations will be in English language anyway. So here are the details for my ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on September 17, 2014
  • PASS SQL Saturday #356 Slovenia

    And we are alive! I am proud to announce the PASS SQL Saturday #356 Slovenia event. The date is December 13th. In December, Ljubljana is even more beautiful than usually, and it is definitely a party city. Therefore, together with great sessions, a lot of reasons to come. Welcome!
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on July 30, 2014
  • SQLBits XII

    Back home from SQLBits XII, back to normal life. However, I am already missing the conference. I have spoken with quite a few other speakers, and our conclusion is, as my friend Niko Neugebauer said: this conference is simply second to none. Great content, and very interesting split into three days: seminars if you wish to get more personal touch ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on July 21, 2014
  • Conferences – 2nd Semester 2014 - Update

    I have to correct the post from a month ago, I had to make some changes in my plans. 1. SQLBits 2014, July 17th-19th: high time to register, pre-conf seminars start in two days. I have an interesting pre-con seminar there Advanced Data Modeling Topics. In addition, I have a session as well. This is now over. 2. Kulendayz 2014, September 5th ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on July 15, 2014
  • re: Data Modeling Resources

    Koen, that's what comments are for:-) Thanks, Dejan
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on June 11, 2014
  • 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

    Mark, as I said, by the syntax, it is DDL. But you missed the main point: physical operation is not what defines the Relational Model, it is the logical action. So if there would exist only composable DML syntax and MS would not explain the physical action, this would be a DML for you?
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on April 6, 2014

    My previous blog post Truncate Table DDL or DML Statement? got quite a few comments. Now I am continuing with a similar discussion: is the ALTER TABLE SWITCH [PARTITION] DDL (Data Definition Language) or DML (Data Manipulation Language) statement? At least it is clear that this is not a Data Control Language (DCL) statement. Again, I can find ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on April 6, 2014
  • re: Truncate Table – DDL or DML Statement?

    Brian, this is my point - it is a DML because logically, it does a DML operation. However, yes, because of many things it can be treated as a DDL statement as well. My preference is DML, because this is the main idea of the Relational Model &nbsp;- to work on the logical level and don't care what the underlying system is doing on the physical ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on March 31, 2014
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement