Data Education Experts Blog

  • shadowSQL Server Denali
    image
    shadow

    Denali: Reports from the Blogosphere

    As promised in our recent and wildly popular exposé on the naming scheme behind Denali, the latest version of SQL Server, we present to you a brief, rather random, but high-quality list of some of the best SQL Server bloggers out there writing some of …

    Read More

  • shadowSQL Server Code Name Denali
    image
    shadow

    A Denali By Any Other Name

    Chances are excellent that you already know quite a bit about the latest SQL Server release, nattily code-named “Denali” (CTP3, to be exact). According to Microsoft, and some of the SQL bloggers out there, Denali has a decent amount of improvements going for it. Let’s …

    Read More

  • shadowManaging Bitemporal Data
    image
    shadow

    Managing Bitemporal Data

    In this post, Data Education founder and trainer Adam Machanic discusses how to manage bitemporal data. Here, he explains that because data isn’t always straightforward, it’s important to update it very carefully. A central truth that we need to embrace to be successful as database …

    Read More

  • shadowTime Intervals in SQL Server: Part 2
    image
    shadow

    Time Intervals in SQL Server: Part 2

    In Part 1 of this post, Machanic discussed modeling and querying continuous intervals. In this second part, he discusses independent intervals. He explains that both gaps and overlaps can be represented. As mentioned previously, modeling intervals as a start time/end time combination may make more …

    Read More

  • shadowTime Intervals in SQL Server: Part 1
    image
    shadow

    Time Intervals in SQL Server: Part 1

    Given the commonality of the requirement in virtually every possible application to store temporal data, it’s surprising how involved a discussion of techniques for dealing with the data can become. Depending on the business requirements, systems may need to be able to deal with users …

    Read More

  • shadowDate-Time Calculations: Part 2
    image
    shadow

    Date/Time Calculations: Part 2

    In Part 1 of this topic, we considered how input dates can be manipulated to dynamically generate whatever ranges a query needs. As promised, it’s time to look at more intriguing combinations. So, to start: A common requirement in many applications is to do calculations …

    Read More

  • shadowDate-Time Calculations: Part 1
    image
    shadow

    Date/Time Calculations: Part 1

    Knowing how to format dates for input and output is a good first step, but the real goal of any database system is to allow the user to query the data to answer business questions. Expecting all date range queries to have hard-coded values for …

    Read More

  • shadowOutput Date Formatting
    image
    shadow

    Output Date Formatting

    In this post, Data Education founder and trainer Adam Machanic continues his discussion on the CONVERT function. Here, he explains that the only difference is that the function is converting an instance from a date/time to a string rather than the other way around. The …

    Read More

  • shadowInput Date Formats
    image
    shadow

    Input Date Formats

    In this post, Data Education founder and trainer Adam Machanic discusses international standard date and time formats. Here, he explains the importance of not using ambiguous date formats. There is really only one rule to remember when working with SQL Server’s date/time types from a …

    Read More

  • shadowWorking with Temporal Data: Representing More Than Just Time
    image
    shadow

    Working with Temporal Data: Representing More Than Just Time

    It’s probably fair to assert that time is a central component of every possible database of any interest to anyone. Imagining a database that lacks a time component is tantamount to imagining life without time passing; it simply doesn’t make sense. Without a time axis, …

    Read More

Page 4 of 5«12345»