A month of SSMS tips and tricks
Wayne’s Tips and Tricks for SSMS
SQL Server Management Studio (SSMS ) is a program that many just launch daily (or only...
2018-01-01
382 reads
Wayne Sheffield
- Website: http://www.waynesheffield.com
The case of the missing database backup file
Exploring the wonderful case of a missing database backup.
I was working on a client’s site today, setting up database backup...
2017-12-27
567 reads
New Features in SSMS 17.3
SSMS 17.3
SSMS 17.3 was just released (download link), and it has a couple of new features worthy of mention:
Import Flat...
2017-10-20 (first published: 2017-10-11)
4,109 reads
Stop waiting for SQL Server Service Pack 1 before upgrading!
It’s not stable until Service Pack 1…
Are you at a company that doesn’t install a new version of SQL Server...
2017-09-29
768 reads
Seattle Freecon 2017
Announcing Seattle Freecon 2017
Are you going to the PASS Summit this year? (and if not… why not?)
Are you coming in...
2017-09-28
615 reads
Working with the registry in SQL Server – adding trace flags to startup parameters
In a recent post, I introduced you to how to work with the registry directly from within SQL Server. Continuing...
2017-09-04
764 reads
Working with the registry from within SQL Server
There is a lot of information within the Windows registry. Sometimes, it would sure be nice to work with the...
2017-08-30 (first published: 2017-08-16)
3,692 reads
SQL Server 2016 helps with Best Practices
In order for your SQL Server instance to run optimally, there are many SQL Server best practices that you need...
2017-08-03 (first published: 2017-07-19)
4,768 reads
Combating SQL Injection
Target. Home Depot. NASA. U.S. Army. Anthem. Wall Street Journal. MarketWired. Ashley Madison. What do they all have in common?...
2017-06-21
800 reads
Weaning yourself off of SQL Profiler (Part 2)
In a prior post, I shared a script that will take a running trace and show you the XE events...
2017-05-17
571 reads
Blogs
KDA: Echoes of Deception - Case 7
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
Do This Before You Contact Your SQL Server Consultant
Say you need outside help. You’ve exhausted all the things that you could do...
Microsoft MVP 2026: Ten Years on the Data Platform
I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...
Forums
Implicit Conversions Cripple SQL Server
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
BIT_COUNT() III
Comments posted to this topic are about the item BIT_COUNT() III
The Mythical Bus Accident
Comments posted to this topic are about the item The Mythical Bus Accident
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers