SQL Server Unit Testing in Visual Studio
Unit test stored procedures in Visual Studio using an existing database or new SQL scripts
2020-01-03 (first published: 2017-05-01)
19,568 reads
David Fundakowski
Compress and Decompress in SQL Server 2016
Explore using Compress/Decompress with varying types of data and examine size/storage usage
2018-10-01
3,822 reads
2018-09-21
805 reads
Changing Linked Server Properties
A quick guide on changing the linked server properties and settings.
2018-09-03 (first published: 2016-07-07)
34,841 reads
Additional Data Files and Proportional Fill
Additional files can be added to to a database to increase the storage. When more data is added to the files, Extended Events shows how SQL Server spreads data across multiple files.
2017-11-03 (first published: 2016-07-25)
4,680 reads
2016-08-26
1,387 reads
2016-08-15
1,268 reads
Reclaiming Space After Column Data Type Change
A brief overview of how to reclaim storage space after altering the data type of a column.
2016-08-09
5,049 reads
2016-08-02
1,370 reads
Diagnosing parallelism-related latching
Diagnosing and resolving parallelism-related latching and blocking in SQL Server using DMV’s, the activity monitor, procedure execution plans, and index tuning.
2016-05-26
2,746 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers