Somewhat related to SQL Server, when writing remote queries or ETL packages against Oracle, try to remember that an empty string in PL/SQL is equivalent to NULL. At least understand...

If you're using a MERGE statement to perform something like a Type 2 Slowly Chaning Dimension operation, then it helps if you can apply a range condition like: WHERE SaleDate...

joeshu26 (12/31/2015)

---

I would like to SELECT only dates from my dimDate table that are less than or equal to the latest date in my factTable. Any syntax for this...

Maybe it's just me, but it seems this past year (and 2014 as well) there were a lot of existential discussions here on SQLServerCentral regarding our careers and the industry...

MMartin1 (12/30/2015)

---

Eric M Russell (12/30/2015)

---

Orlando Colamatteo (12/30/2015)

---

Eric, agree it's not a ton more but Phil expressed it in more detail. This is basically my thoughts on it and where my...

Orlando Colamatteo (12/30/2015)

---

Eric, agree it's not a ton more but Phil expressed it in more detail. This is basically my thoughts on it and where my comment about requiring less...

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.