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

70-457 Reviewer #05, Configuring SQL Server 2012 Components

The lessons covered for this review is Configure Analysis Services Configure and Deploy Reporting Services Configure and Deploy Sharepoint Integration...

Upscale Bowling

I don’t bowl often, maybe once a year at best. It’s a fun way to spend a couple hours – I...

SQL Server – Get values as DATETIME from sysjobhistory

This is a follow-up post on SQL Server – Check SQL Agent Job History using T-SQL.
SQL Server Agent stores SQL jobs...

Creating a Rolling Date Range Named set in MDX

One Client I was working with wanted a named set that would give them the last 5 years. Of course...