Redgate’s Arneh Eskandari and Microsoft SQL Server MVP, Steve Jones, will show you how Redgate’s DLM (Database Lifecycle Management) solution works to improve your database development and deployment processes. Today 12noon EDT
The individual's dexterity can impact how we use software. Perhaps we need ways to undo mistakes in various systems.
To be able to make full use of the system catalog to find out more about a database, you need to be familiar with the metadata functions. They save a great deal of time and typing when querying the metadata. Once you get the hang of these functions, the system catalog suddenly seems simple to use, as Robert Sheldon demonstrates in this article.
Today Steve Jones talks about the issues with the sa account, and how you might protect this on all your instances.
In this article, I’ll attempt to “convince” you that every SQL Server you put into production should be a SQL Server Failover Cluster Instance (FCI).
When your SQL Server database is set to have its statistics automatically updated, you will probably conclude that, whenever the distribution statistics are out-of-date, they will be updated before the next query is executed against that index or table. Curiously, this isn't always the case. What actually happens is that the statistics only gets updated if needed by the query optimiser to determine an effective query plan.
One way to make code run faster is to have less of it. Or ensure the code you have does less work.
This article shows you how to resolve SQL Server maintenance plan execution failure error
Oracle offers a number of security-related settings, but one could definitely create more harm than good. David Fitzjarrell looks at which parameter that is, and why.
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item SQL Server Still Wins
Comments posted to this topic are about the item DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers