David.Poole (12/30/2015)

---

TomThomson (12/30/2015)

---

Steve Jones - SSC Editor (12/12/2015)

---

a fundamental broken concept of information technology is the lack of security practices and architectures being built into our platforms and applications from...

Orlando Colamatteo (12/30/2015)

---

Assuming the identity seeds were both 1, loading with IDENTITY_INSERT ON using the original identity *-1 (what Phil said) is where I would start the conversation. If the...

Grumpy DBA (12/17/2015)

---

Steve Jones - SSC Editor (11/12/2015)

---

Yeah, what Grant noted. If you're not satisfied in your job, the best time to look and change is when you can do...

Brandie Tarvin (12/25/2015)

---

I'm genuinely curious how you manage that when all the hotels demand credit cards...

First, any DBA who tells you the database hasn't been backed up for months; I just wouldn't take their word for it, and they could be wrong. Before proceeding any...

Where are you getting the message from? It looks like a custom programmer defined message. The term "ICD10" relates to healthcare coding not SQL Server.

If the data can't be easily re-sourced, meaning it's accumulating change data history, and the goal is tho retain the data permanently, which I'm guessing would be the reason for...

Alvin Ramard (12/29/2015)

---

Eric, if...

I occasionally rip off some ideas from chef Alton Brown and put it to good use in my kitchen. I don't think the guy would mind.

At a bare minimum, all you need is Notepad, but the free SSDT tool provided by Microsoft provides some nice to have features too.

Plagiarism is more than just copying and pasting a block of code into a blog post; plagiarism is when you present someone elses original work as your own original work.

The...

I'll secound Jeff's emotion that ETL staging tables should be contained in a separate dedicated database. Not only would it compete for resources with the OLTP database, but it would...

Luis Cazares (12/28/2015)

---

Eric M Russell (12/28/2015)

---

TheSQLGuru (12/28/2015)

---

Ooh, another thing I will chime in with. Some of the WORST things I see done on SQL Server have nothing to do with...

Well, since the initial publication of this editorial back in 2005, we know have OS virtualization, which "clouds" the issue of "SQL Server running on Linux". 😉

I'm not aware of a tool that will automate what I've described above, but if you script out INSERT.. SELECT.. scripts for each of the 500 tables using SSDT or...