Template Variables (Day 7)
Do you have scripts that you need to run frequently, but every time you need to set some different parameters?...
2018-01-18 (first published: 2018-01-07)
1,557 reads
Wayne Sheffield
- Website: http://www.waynesheffield.com
Add color to connections (Day 17)
Have you ever wished for a visual indicator that you are connected to a production instance of SQL Server? Well,...
2018-01-17
384 reads
Add color to connections (Day 17)
Have you ever wished for a visual indicator that you are connected to a production instance of SQL Server? Well,...
2018-01-17
149 reads
Assign a keyboard shortcut to menu items (Day 16)
You may have noticed that there are many menu commands that don’t have a keyboard shortcut. For instance, SQLCMD mode...
2018-01-16
365 reads
Assign a keyboard shortcut to menu items (Day 16)
You may have noticed that there are many menu commands that don’t have a keyboard shortcut. For instance, SQLCMD mode...
2018-01-16
117 reads
Query Shortcuts in SSMS (Day 15)
There are several shortcuts that can be assigned to run a stored procedure. Known as Query Shortcuts, these can be...
2018-01-15
326 reads
Split Screens (Day 2)
Have you ever wanted to see different parts of the same query window at the same time? Well, in SSMS,...
2018-01-15 (first published: 2018-01-02)
2,323 reads
Object Explorer Drag-N-Drop (Day 14)
Did you know that items in the Object Explorer can be dragged and dropped into a query window? This can...
2018-01-14
308 reads
The SSMS Super Clipboard (Day 13)
We’re all used to using the clipboard in Windows programs. You copy something into it with Ctrl+C, and paste it...
2018-01-13
397 reads
Changing Case (Day 12)
In yesterday’s tip, I showed an example of changing a block of text from upper case to lower case. However,...
2018-01-12
283 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