The database recovery model controls how a SQL Server database can be backed up and restored. In this article, Greg Larsen explains the three recovery models and what to think about when choosing a recovery model for a database.
2020-09-21
Robert Sheldon wraps up his series on storage by discussing the latest storage innovation and ideas.
2020-09-14
This month's T-SQL Tuesday had lots of posts that look at automation from the DBA perspective, rather than the software developer.
2020-09-12
168 reads
There are a whole slew of problems that we had to worry about ten years ago, and they just hardly ever come up today.
2020-08-28
No discussion about storage is complete without thinking about security of the data. In this article, Robert Sheldon explains what must be considered to protect data in today's world.
2020-08-10
Brent shows us how to Install Azure Data Studio to Work with SQL Server.
2020-08-05
You’ve heard that shrinking a database is bad because it introduces both external and internal fragmentation, it causes blocking, it causes transaction log growth while it runs, and it’s slow and single-threaded. You understand that if it’s just a matter of 10-20-30% of a database, and the database is only 100-200GB, you might as well just leave the space there, because you’re gonna end up using it anyway.
2020-07-29
Keeping SQL Server instances patched can be a time-consuming task for DBAs. In this article, Alejandro Cobar explains how he created a service in Azure that anyone can use to retrieve the build information for SQL Server.
2020-07-08
In this article in the storage series, Robert Sheldon explains infrastructure options that simplify administration and improve resource utilization. He discusses the differences and benefits of converged, hyperconverged, and composable infrastructures.
2020-06-25
In this article in the series, Robert Sheldon provides a deep dive into HDDs.
2020-03-09
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
Hello, Kindly guide me with the following code in T-SQL. I need to only...
Comments posted to this topic are about the item New Stuff Can Be Scary
Hi everyone, Working with a stored procedure that is used in an application of...
Ask SSC