Find Unused or Backup Tables
If you rename old or backup tables, learn how to find easily find and drop them.
If you rename old or backup tables, learn how to find easily find and drop them.
There is new legislation in Australia that is supposed to allow employees to ignore messages outside of working hours. Steve has a few thoughts on how he balances his workload.
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.
Tech conference season is in full swing, and it’s only the middle of March. Between Grant, Steve, and I, we’ve attended or presented at about 10 events so far. And within my community of developers and database folks, I’ve seen pictures and posts of many more. As I’ve said a few times in previous editorials, […]
We all need to grow our skills at work. It can be challenging, but we can find ways, as well as advocate to management that resources are needed.
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 […]
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.
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
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...
Hi All, I have couple questions related to Ola Hallengren's maintenance script. If anyone...
I've been exploring various methods to monitor and alert for long-running queries in SQL...
Hi everyone I need to find the last business of the week. In most...
How can I run SQL Agent with SQL Server Express 2022?
See possible answers