Controlling what appears in the status bar and query tabs (Day 32)
When you run a query in SSMS, you are probably aware that the status bar contains many pieces of information...
2018-02-01
526 reads
A Discussion of SQL Server-Related Topics
SSMS Activity Monitor (Day 31)
SSMS provides an Activity Monitor, a process that displays various information about what all is going on with the instance....
2018-01-31
785 reads
Reports in SSMS (Day 30)
SSMS has a lot of reports available for you to use. Most of the reports in SSMS are off of...
2018-01-30
533 reads
Presenting with SSMS (Day 29)
If you are presenting with SSMS, then there are some extra steps that you need to take. These steps are...
2018-01-29
832 reads
Saving SSMS Settings (Day 28)
Over the last several weeks, we have been making several changes to various settings in SSMS. Now that you have...
2018-01-28
387 reads
Comparing Query Plans (Day 27)
When you are performance tuning code, you will frequently examine the execution plans to see what is happening. As you...
2018-01-27
446 reads
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-26
692 reads
Working with Comments (Day 26)
We all know that we should liberally document our code with comments, so that others (and even yourself) will know...
2018-01-26
375 reads
Using the SSMS Web Browser (Day 25)
One of the things that I do with my code is to include reference links to what I was doing...
2018-01-25
334 reads
Using the SSMS Web Browser (Day 25)
One of the things that I do with my code is to include reference links to what I was doing...
2018-01-25
306 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