How to extend the range of SQL code analysis, during database development, to include dynamic analysis of the database metadata. This will allow regular checks for problems with the design of your tables and indexes ("table smells") that can affect database performance and data integrity.
2021-05-10
In this article, Edward Pollack explains the benefits of a SQL Server data dictionary and how to build one.
2021-04-29
Security roles can simplify permissions in SQL Server. In this article, Greg Larsen explains fixed server and database roles.
2021-04-22
How to create a batch file that executes any number of database migration tasks across a range of servers and databases, using Flyway.
2021-04-21
Out-of-control tempdb growth must be managed to keep the server running. Monica Rathbun gives her strategy to handle unexpected tempdb growth.
2021-04-12
RAID has been around since the 90s to ensure performance and reliability of storage. Robert Sheldon explains the history and theory behind RAID.
2021-03-11
This article shows how we were able to migrate a TB size database to new storage with minimal downtime.
2024-01-01 (first published: 2021-02-24)
7,515 reads
SQL Server triggers are another tool in your DBA or Dev toolbox. Edward Pollack explains what can go wrong with triggers and how to correct those issues.
2021-02-18
The SQL Server error log is helpful for troubleshooting issues. Greg Larsen demonstrates several ways to search SQL Server error log files.
2021-02-11
Comparing current performance to baselines helps DBAs know when there’s a problem. In this article, Pamela Mooney describes how to measure the physical resources drive space, latency, memory, and CPU.
2021-01-06
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers