Kathi/Brian, I was once hired as a SQL Developer by a company that turned out to be held hostage by an Oracle DBA/SQL Developer.  He would not share any information...

I am now in my third job (4 years, then 3 years, now five years) in a row where I am the first DBA in the history of the company....

Here's a blog post that came out today from Erik Darling the shows when this is the best approach for TOP(1) and when using a windowing function can be...

• This reply was modified 2 years, 9 months ago by  m60freeman.

There are probably a lot of databases out there with CHAR(1) Gender columns with a check constraint ensuring that only M, F, and (maybe) "X" can be stored. Most of...

Steve,

Using Azure Data Factory as a replacement for SQL Agent can be a good idea. Although SQL Agent is free if you need a full SQL instance anyway, if you...

Having worked on a lot of "take this crappy code and make it scale" projects, given what I've heard about the SQLSaturday code and having been an admin for a...

Mt thinking is that SQL Saturdays has a nice alliterative ring to it. However, while these events welcomed sessions on other data-related topics, they are bound to feel like second...

I have the same issue on an inherited 2016 installation, and as of Nov. 7, 2017, there are still no other relevant Google hits for this. I don't know if...

When I execute the SQL posted by Grasshopper that starts with:

in a Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) instance, I get:

Msg...