patrickmcginnis59 10839 (7/21/2014)

---

Eric M Russell (7/21/2014)

---

It's interesting that developers on the various "NoSQL" platforms are now focussing their efforts on implementing SQL language interfaces. Apparently when it came time to...

It's interesting that developers on the various "NoSQL" platforms are now focussing their efforts on implementing SQL language interfaces. Apparently when it came time to start capitalizing on their inventions...

podmate (7/17/2014)

---

I am one of the people who do not like access.

I have had too many experiences with poorly built access (and FileMaker Pro) 'applications' that I never want to...

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