Maybe local user SQL Server groups should organize van pools for out-of-town SQL Saturday events. Not only would it help mitigate the expense of travel, but it would event even...

2016 can potentially be several orders of magnitude faster than 2008, if you also want to invest in re-architecting your database to leverage things like Clustered ColumnStore, In-Memory OLTP, or...

Rod at work (8/1/2016)

---

Steve, I don't have an answer to your question. However, your article has opened my eyes to the fact that what I've experienced over the last couple...

If the wifi isn't secured with encryption, then it doesn't matter whether authentication is via password, fob, or biometrics. Hackers can steal the credentials or token in mid-flight.

If we're talking about narrowing down the Object Explorer to only those objects I want to work with, then I typcially use Filter Settings for that, because the objects and...

The SQL Saturday event I attend yearly here in Atlanta is close enough to my home I could theoretically ride my bike. There are about three or four other events...

You can setup an SQL Audit trace on DDL events.

Also you can have a job scheduled to periodically monitor query for modified objects and fire off an email alert in...

Back in '90s I developed and maintained FoxPro applications, which was then using the same client / file server model perpetuated by MS Access today. Things like network bandwidth, concurrency,...

Good topic, and you have also written in a style that's accessible and relevent not just for data professionals but also for non-technical team members and stake holders. Lack of...

GilaMonster (7/27/2016)

---

Eric M Russell (7/26/2016)

---

Rod at work (7/26/2016)

---

If, "The market is too starved for talent to be at a job you kinda like or don't like at all.", I don't...

Auto formatted code can look a bit dry. If you think it's worth spending a little money on genuine hand crafted SQL formatting (with all the little ticks and imperfections...

Rod at work (7/26/2016)

---

If, "The market is too starved for talent to be at a job you kinda like or don't like at all.", I don't see any evidence of...

A CXPACKET (packet exchange) wait state means that one or more operations in your execution plan is running parallel and execution has paused to wait for one of the threads...

David.Poole (7/26/2016)

---

I get the point about 10x data loads but that is stress testing rather than unit testing.

Stress testing is incredibly important. The reason for separating out unit, integration,...

I wouldn't blame a botched deployment at a national financial services corporation on one single person. When it comes to enterprise scope deployments, you definately want more than just one...