The cloud is not just someone else’s computer

A year ago, I wrote in a post that cloud computing is just someone else’s data center. I was wrong. Whether...

It’s All in the Name, Index Naming Conventions

Awhile back, if you are on Twitter, you can probably recall my ranting about the 949 indexes I was reviewing....

SCOM: SQL Instance and Databases exclusion

This  post is by Chris Gibson

I recently wanted to exclude some temporary SQL databases from being discovered by our SCOM...

Comparing two SQL instances

Last week I was working on a couple of SQL instances that contained databases which were part of an Always...

Summiting that Technical Challenge

The challenge at hand - conquering that technical problem and getting that high associated with the metaphorical high of summiting a tough task.
Related Posts:

Summiting that Technical Challenge Part II...

Summiting that Technical Challenge

Conquering Challenges

I really like the topic of the TSQLTuesday party today. Today we have been instructed in no uncertain terms...

salt Release 1.1.2562 – With Bug Fix!

Hello!
Very recently a user of salt got in touch with me about a bug when setting the job schedules up...

SQL Server on TLS 1.2: XEvent session to catch TLS in use

How can you tell what version of TLS is currently used for client connections? Unfortunately there isn't a handy queryable column...

SQL Server on TLS 1.2: Checklist to disabling TLS 1.1 and 1.0

A common finding in security audits these days is the failure to conduct all communications via TLS 1.2. (Correspondingly, a...

How to fix the database consistency and integrity issues using DBCC CHECKDB and Third Party Tool

Overview
The database protection and recovery is a vital role of database administrators. While working on SQL Server, sometimes users get...