dBase, Foxpro, and MS Access were nice little self-contained development platforms that got the job done in an era when options for multi-user enterprise development on the PC platform where...

Eric M Russell (3/26/2014)

---

Steve Jones - SSC Editor (3/26/2014)

---

Gary Varga (3/25/2014)

---

I use the connection colour option in SSMS. See 'Use custom color' and set up registered servers using the desired...

andrew gothard (7/15/2014)

---

Phil Factor (7/15/2014)

---

@patrickmcginnis59

Yes, it is certainly possible to have a NoSQL database that handles ACID properly. It just surprises me that some don't. As I understand the...

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