There seems to have been a spike in career oriented editorials and posts over the past year. I know it's been on my mind a lot lately too.

As for...

MMartin1 (2/3/2015)

---

Maybe I missed it somewhere but it seems as though you are reporting from the same system you insert into. You generally want to build a warehouse to store...

sys.sysprocesses is legacy, and there are a handful of DMVs that could do the same job better.

The following will simply return number of connections.

select * from sys.dm_os_performance_counters

where Counter_Name =...

Doctor Who 2 (1/31/2015)

---

I agree with you Steve, but sometimes I wonder. Where I worked we had 18 years worth of data which I've maintained and advocated for years, should...

David.Poole (1/31/2015)

---

I saw an amazing article on how Oracle would save hundreds of thousands of dollars per year because the tooling was so much better that it took Oracle DBAs...

sm_iransoftware (1/31/2015)

---

Hi Again

I want to do some thing on this database.

First Of All , I should start with a small database.

But current DB has many connection from site. And I...

RonKyle (1/29/2015)

---

I don't want to get in a back and forth about what a natural...

RonKyle (1/29/2015)

---

[Emphasis...

ScottPletcher (1/29/2015)

---

TomThomson (1/28/2015)

---

Eric M Russell (1/27/2015)

---

andrew gothard (1/27/2015)

---

Eric M Russell (1/21/2015)

---

ProductID, ProductId, and product_id are all respectable options, so long as it's done consistently.

However, I would take issue with...

Our ETL process ingests data from over a hundred external clients, and what is accepted as "normal" is a constant debate. There is a pre-production load step called AutoCertification that...

They're somehow assigning more weight to the negative rating then the all the others. There's perhaps some value here in doing so, since there might be a legitimate complaint, but...

Iwas Bornready (1/27/2015)

---

For me, over time, it has become increasingly more difficult to work full time and do any sort of serious studying. I don't have a solution. I just...

andrew gothard (1/27/2015)

---

Eric M Russell (1/21/2015)

---

ProductID, ProductId, and product_id are all respectable options, so long as it's done consistently.

However, I would take issue with ID by itself, on every...

Steve Jones - SSC Editor (1/26/2015)

---

Eric M Russell (1/26/2015)

---

So, deploying a new procedure, table, or column days or weeks before the associated application change is deployed? Yes, that happens all...

Charles Kincaid (1/26/2015)

---

Eric M Russell (1/26/2015)

---

Hey, it's 2015; the developer should code the application first, and then with a few clicks of the mouse they can auto-generate all the database...