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

Multi-Server Queries (Day 9)

Have you ever had to run a query on multiple servers? You could connect to each server one by one...

T-SQL Tuesday #098–Technical Challenges

It’s the first T-SQL Tuesday of 2018, being brought to you by Arun Sirpal. His invitation this month asks for...

T-SQL Tuesday #98 – Take Small Bites!

https://media.makeameme.org/created/mega-bytes-well.jpgIt's T-SQL Tuesday time again - the monthly blog party was started by Adam Machanic (blog/@AdamMachanic) and each month someone different...

DBA’s need resolutions, too!

It’s that time of year again: time to make resolutions, then try to stick to them. Sure, we could start...

SQL Operations Studio As Monitoring Dashboard

Microsoft as a company has entered a new phase of innovation under the leadership of their CEO Satya Nadella. In...