SQL Server 2014: In-memory OLTP Engine, code-name: Hekaton

What looks to be the biggest and best new feature in SQL Server 2014 is called the “In-memory OLTP Engine”,...

A Vacation and Traveling to Sacramento

I’ve got a couple days off, starting today after my webinar on Preparing for When Disaster Strikes. I’ve got some...

I Learned Something From You

I learned something from you – that was something someone said to me at the end of a recent consulting engagement....

SQL Server Webcast: The Day After Tomorrow; Why YOU need to Baseline

Every day I consider myself extremely fortunate to be in a profession that I really enjoy, as there’s always something...

SQL Server Quickie #7 – TempDb Latch Contention

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Today I have...

Using Change Data Capture and CLR to Transfer Data to the Cloud

We were three: A DBA, a developer and a tester.
Our mission: To develop an ongoing process that will transfer one...

Are You the Primary Replica?

UPDATED -- Jul 3, 2015 -- To verify database exists, per comments by Konstantinos Katsoridis. Thanks for finding the bug!

In my recent adventures...

Query to Find "Update" Dependencies on a Table or View (SQL Server 2012)

The built-in dependency finder in SQL Server Management Studio does not provide the ability to distinguish between dependencies that are...

Security Questions: Granting Access with Jobs

As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...

Last Weeks Top “Reading” Links #42

Number 42 of this weekly previous week round-up.  If you follow me on twitter (@StrateSQL), you’ll know that throughout the day...