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...

I'm assuming the scenario is that you have two clients in separate SQL Server instances, each having overlapping sequential integer identifiers, and so you need to assign new identifiers as...

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 the databases/applications they run -...

In addition to what's already been mentioned above:

On the fly data type conversion and transformations, both explicit and implicit

Distributed queries (ie: joining tables between multiple instances via linked server...

To balance out the concerns regarding taxes and health insurance, consider a long term contract ostensibly means less time sitting on the bench between gigs. For that reason, your rate...

.. One of the primary reference data points in the article is that 34% of US workers engage in freelance work. There's a reference to a study that says 41million...

Well, im still not sure about RegEx in a data warehouse. Parsing text columns suggests things like product descriptions were not identified by category in a way thats useful to...

Phil Parkin (12/26/2015)

---

Solomon Rutzky (12/26/2015)

---

Just out of curiosity,...

The easiest thing to do would be to disable trigger, insert in one shot, and then re-enable trigger.

I cant believe they've got you doing this b.s. on Christmas Eve....

This should work.

- You didn't need the full name of the tblcall table in the WHERE clause, only the alias + column name.

- Also, in the JOIN clause,...