Tab Groups (Day 3)
Have you ever wanted to have two different queries open up at the same time where you could see them,...
2018-01-03
316 reads
A Discussion of SQL Server-Related Topics
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,304 reads
SSMS Solutions (Day 1)
Since SSMS is built upon Visual Studio, many of the features available to Visual Studio are also available to SSMS....
2018-01-08 (first published: 2018-01-01)
3,229 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-01
377 reads
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
558 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,097 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
764 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
607 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
754 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,498 reads
Blogs
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Keeping MS Docs Up to Date
By Steve Jones
One of the things that I like about the SQL Server docs (MS Learn...
Patch Tuesday – Where to get more information
By Brian Kelley
For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday...
Forums
is there a no code way to limit an ssis extract from excel to the 1st 21 rows?
is there a no code way to limit an ssis extract from excel to...
Pivot but preserve all rows on Aggregate column
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
any reason to avoid asking ssis to extract files from ftp
hi we have to replace talend which generally was used to move files. talend's...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers