Forum Replies Created

Viewing 15 posts - 1,366 through 1,380 (of 6,026 total)

  • RE: Frustrating Programming Policies

    What's interesting is how these misguided policies actually encourage bad SQL programming practices.

    "A SELECT statement can not have more than two tables joined together..."


    Hey, boss-man, when...

  • RE: Learning Data Modeling

    Typical programming books like "Database Programming with C#" may cover data modeling to come extent, but it's more of an afterthought and rather sparse.

    Ralph Kimball has some excellent...

  • RE: Learning Data Modeling

    Perhaps the best way to proliferate a process is to make tools for the process ubiquitous. There is a rudimentary Database Diagram tool in SSMS, but it hasn't changed in...

  • RE: Are the posted questions getting worse?

    Grant Fritchey - Thursday, July 6, 2017 7:45 AM

    Eric M Russell - Thursday, July 6, 2017 7:30...

  • RE: The March of AI

    I do believe that predictive analytics (non domain specific) can be leveraged to improve the optimization of databases and data storage systems, and do some extent that's been around for...

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson - Thursday, July 6, 2017 6:56 AM

    GilaMonster - Thursday, July 6, 2017 6:37 AM

    July 6, 2017 at 7:30 am

    #1949707

  • RE: A Database Design Test

    Jeff Moden - Wednesday, July 5, 2017 6:51 AM

    For most interviews I've conducted, we never get to design questions because they don't...

  • RE: The 43rd Birthday for SQL

    JavaScript and LINQ are just window dressing for SQL, just like in the construction industry stucco is dressing for (not a replacement for) solid brick.

  • RE: A Database Design Test

    The expected answer would be similar to the following, although any equivalent and simple set based solution would suffice.


    SELECT CustomerID
      , COUNT(*) AS ContactCount

  • RE: A Database Design Test

    The following is not really a database design question, but more of a baseline SQL query question. It's simple enough that a core SQL developer could easily rattle off the...

  • RE: SQL Server is Lagging a Bit

    Hell, even today there is no broad consensus on when exactly we should start dancing in the streets to celebrate the arrival of the Age Of Aquarius. Some New Age...

  • RE: SQL Server is Lagging a Bit

    Steve Jones - SSC Editor - Wednesday, June 28, 2017 8:41 AM

    chrisn-585491 - Wednesday, June 28, 2017...

  • RE: Handling Data Corruption

    So, how to establish a timeline for when data corruption first occurred?

    Off the top of my head, the first place I'd look would be error logs, both...

  • RE: Classifying Sensitive Data

    Profiling individuals based on big data and analytics has potential, but it is limited. Obviously, you can use Google Maps or cell tower telemetry to predict they will probably...
  • RE: SQL Server is Lagging a Bit

    Rod at work - Wednesday, June 28, 2017 8:00 AM

    This is interesting. And I'm most interested in the inclusion and expansion of...

Viewing 15 posts - 1,366 through 1,380 (of 6,026 total)