Regular Expressions (Day 10)

Have you ever downloaded a script from an internet site, only to find that there are extra blank lines between...

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