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,108 reads
Unit test stored procedures in Visual Studio using an existing database or new SQL scripts
2020-01-03 (first published: 2017-05-01)
19,108 reads
Explore using Compress/Decompress with varying types of data and examine size/storage usage
2018-10-01
3,594 reads
2018-09-21
796 reads
A quick guide on changing the linked server properties and settings.
2018-09-03 (first published: 2016-07-07)
33,020 reads
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,415 reads
2016-08-26
1,378 reads
2016-08-15
1,259 reads
A brief overview of how to reclaim storage space after altering the data type of a column.
2016-08-09
4,979 reads
2016-08-02
1,353 reads
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,681 reads
I’ve covered how to create Elastic Jobs in the portal (this one is important...
By Steve Jones
redesis – n. a feeling of queasiness while offering someone advice, knowing they might...
By Steve Jones
The Solutions Engineers at Redgate recently released an Introduction to Redgate Flyway Autopilot course...
Comments posted to this topic are about the item No End to Programmers
Hi there to all SQL gurus So, here is the scenario. I have a...
Guys, I am facing problems when running a backup routine JOB in SQL Server,...
What is the result of this query in SQL Server 2022+?
select bit_count('7')See possible answers