Use Snippets in SSMS to insert blocks of code (Day 19)
Snippets allow you to store and easily reuse TSQL code snippets. To use a snippet, just right-click in the query...
2018-01-19
369 reads
A Discussion of SQL Server-Related Topics
Use Snippets in SSMS to insert blocks of code (Day 19)
Snippets allow you to store and easily reuse TSQL code snippets. To use a snippet, just right-click in the query...
2018-01-19
214 reads
Template Explorer (Day 18)
You may have noticed that in many places in SSMS, you can create a new item and SSMS opens up...
2018-01-18
279 reads
Template Explorer (Day 18)
You may have noticed that in many places in SSMS, you can create a new item and SSMS opens up...
2018-01-18
77 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
381 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
144 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
362 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
101 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
311 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
297 reads
Blogs
Build a Snapshot Backup Catalog in Pure Storage - The SQL Server 2022 Edition
In my previous post, I showed you how to build a snapshot backup catalog...
Advice I Like: Training Employees
By Steve Jones
Train employees well enough that they could get another job but treat them well...
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Why Data Modelling Still Matters - More Than Ever
Comments posted to this topic are about the item Why Data Modelling Still Matters...
hops from sql server to mysql to s4 hana - possible?
Hi when i think of server hops , i think of how kerberos assists...
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers