Optimize Large SQL Server Insert, Update and Delete Processes by Using Batches
In this tip we look at the impact of running SQL Server processes in smaller batches instead of one large operation.
2022-09-23
tSQLt
INSERT EXEC statement cannot be nested, the Simple Solution
Step-by-step guide to solve the "INSERT EXEC cannot be nested" problem by using a CLR when unit testing stored procedures using the tSQLt framework.
2022-08-19
4,841 reads
Using tsqlt Tests to Practice Queries
In this short article, see how a unit test can be easily written in tsqlt, and how this can help us refactor or build better code.
2022-05-30 (first published: 2019-09-24)
14,295 reads
2019-08-13
2,429 reads
Redgate Takes over the SQLCop Project
I am happy to announce the Redgate Software and I are supporting and taking over stewardship of the SQL Cop project at this point. With permission from its founder, George Mastros, we will host the main repository for the project at https://www.github.com/red-gate/sqlcop. This should be considered the official repository for the code from this point […]
2019-08-13
3,574 reads
2021-01-01 (first published: 2017-08-17)
3,506 reads
Adding PK Exceptions to SQLCop Tests
In this piece, Steve Jones shows how you can enforce a requirement of a Primary Key (PK) with a unit test, but also allow exceptions where needed.
2016-05-12
1,210 reads
Download tSQLt Today and Start Unit Testing
The latest version of tSQLt is now available with some SQL Prompt snippets to help you get started.
2015-07-30
1,737 reads
Checking Table Metadata with tSQLt
In this article on tSQLt, learn how you can use the AssertResultSetsHaveSameMetaData method from the framework to enforce your API.
2015-06-11
5,125 reads
Testing Simple Calculations and UDFs with tSQLt
This article will give you a basic look at how you can test your user defined functions with the tSQLt framework.
2015-05-18
5,094 reads
Blogs
How to Calculate Compound Rate in Power BI
Recently I had an interesting use case where I had to a compound calculation...
Daily Coping 28 Sep 2022
By Steve Jones
Today’s coping tip is let go of other people’s expectations of you. I think...
SQL Server In Place Upgrades
By gbargsley
Good morning dear blog reader. Today’s episode is fresh from a great weekend with...
Forums
Forms Authentication Setup for SSRS in 2019
As I was looking the authentication set up which come as default when we...
SQL inplace upgrade from sqlexpress to standard edition in VM Google cloud
Hello Team, planning to do SQL in place upgrade from sql2016express to sql2016 standard...
SQL Master Data Services 2019 - Website keeps prompting for login
I have two SQL 2019 servers running Master Data Services which are continually prompting...
Ask SSC