I always cringe when someone talks about "dumping" terrabytes of "stuff" in SQL Server..., so a few analysts and contractors can chew on it for while..., just to see if...

At least for as long as I can recall, and probably dating back to Sybase, SQL Server has given the developer some flexibility over isolation level. Starting with SQL Server...

NoSQL databases are a solution to a wide range of niche applications that for the most part didn't exist a decade ago. However, Bitcoin is a revolutionary new business model...

One solution is to sum on a conditional expression like so:

select employeeid, historyid,

sum(case when activitytype = 'OPEN' then 1 else 0 end) Opens,

sum(case when activitytype = 'CLICK' then 1 else...

There is no secret sauce when it comes to database administration or development; I don't know why anyone wouldn't openly share their everyday techniques for getting the job done.

That same day, I was talking with another DBA about if he might be interested in creating a presentation for an upcoming SQL Saturday, and his response was (paraphrased) "Why...

In addition to diagraming table relationships, if you want quick insight into what other objects a table depends on (foreign key relationships) or what other objects (like stored procedures) depend...

Master_Files returns one row for each database file, and dm_os_volume_stats is a table valued function that returns information about a volume. Remember to get maximum value for each volume (not...

Gary Varga (7/7/2014)

---

Eric M Russell (7/7/2014)

---

I believe that Microsoft has introduced a cloud database product for the same reason that Coca Cola introduced a line of bottled water products. It's...

I believe that Microsoft has introduced a cloud database product for the same reason that Coca Cola introduced a line of bottled water products. It's not intended to be a...

Comparing SQL Server to SQL Azure is like comparing traditional C++/C# forms to ASP.NET. There are some applications where moving to SQL Azure is an evolutionary leap, but there still...

In this day, most every family has a teenage or twenty-something IT geek who hasn't landed their first real full time job but still...

Gary Varga (6/26/2014)

---

Eric M Russell (6/24/2014)

---

Greg A Goss (6/24/2014)

---

/raises hand

I second that "AAAAAARRRGH". I'm responsible for maintaining...

below86 (6/25/2014)

---

Eric M Russell (6/25/2014)

---

below86 (6/25/2014)

---

Eric M Russell (6/25/2014)

---

Fortunately the construction of the execution plan (for example which table is used as the outer or inner input on a nested...

below86 (6/25/2014)

---

Eric M Russell (6/25/2014)

---

Fortunately the construction of the execution plan (for example which table is used as the outer or inner input on a nested loop or hash join)...