Automation is a Key Skill for the Modern DBA
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
341 reads
Database Administration
SQL Server Problems We Don’t Have Anymore
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
Storage 101: Data Security and Privacy
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
How to Install Azure Data Studio to Work with SQL Server
Brent shows us how to Install Azure Data Studio to Work with SQL Server.
2020-08-05
What If You Really DO Need to Shrink a Database?
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
Using a Public Web Service to Consume SQL Server Build Numbers
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
Storage 101: Convergence and Composability
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
Storage 101: Understanding the Hard-Disk Drive
In this article in the series, Robert Sheldon provides a deep dive into HDDs.
2020-03-09
Two Important ‘ONLINE’ Column-Level Operations in SQL Server
Today Kendra talks about two of the online options used when working with indexes.
2020-01-14
347 reads
How Does Accelerated Database Recovery Work?
Accelerated Database Recovery is new with SQL Server 2019 and Azure SQL Database and used to decrease the time for rolling back large operations and database recovery. In this article, Forrest McDaniel explains how it works.
2019-12-12
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
How Accounting Assignment Help Improved My Academic Performance
I recently used accounting assignment help, and it made a huge difference in my...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers