Find Unused or Backup Tables
If you rename old or backup tables, learn how to find easily find and drop them.
2024-03-18
1,975 reads
If you rename old or backup tables, learn how to find easily find and drop them.
2024-03-18
1,975 reads
Learn how to address SQL Server transactional replication issues with these easy-to-follow steps using T-SQL and SSMS to troubleshoot and fix issues.
2024-03-18
This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]
2024-03-15 (first published: 2022-09-01)
2,454 reads
Here you will learn about the key differences between the binary and SQL/Windows collations. You will see that even with all sensitivity flags enabled, SQL/Windows collation cannot behave the same way as the binary collations.
2024-03-15
918 reads
I was talking with a good friend that has an environment with terabytes of information and to create a homolog or dev environment to him is a pain. He comes to me with a solution : A PowerShell script that gets only the first 1000 lines of each table, creates the inserts and schema files
2024-03-15
In this tip, I will demonstrate how to migrate an existing database schema from SQL Server to PostgreSQL.
2024-03-13
Power BI doesn't always detect relationships, and this article explains a bit about the problem.
2024-03-11 (first published: 2024-03-08)
943 reads
An experienced DBA asks an AI to perform some common tasks. Read to see how it fairs and if an AI will impact DBA jobs.
2024-03-11
6,176 reads
As discussed in Part 1, by segregating our focus on developing code that behaves as expected from the focus on developing code that will be well structured, we have achieved the ability to eliminate wasteful and error prone manual chores.
2024-03-11
This article includes all of the steps you need to take to install and configure SQL Server Reporting Services 2022.
2024-03-08
By Steve Jones
At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM),...
By Rayis Imayev
(2024-Mar-16) I have been a big fan of using the Excel application for various tasks...
You might know the feeling: you’re writing code in a Notebook in Microsoft Fabric...
Please share a situation when enabling and taking further advantage of DBCC TRACEON -...
All, Need a linked server guru. Trying the following in a stored procedure: SET...
How can I run SQL Agent with SQL Server Express 2022?
See possible answers