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
Database Administration
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
350 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
How to Use SQL Audit and Azure Log Analytics to Comply with Audit Rules
You can use SQL Audit to record changes to security, access to tables, and more to help you meet compliance requirements. In this article, Joshua Feierman explains how to set up the audit and collect the data in Azure Log Analytics when running SQL Server in an Azure VM.
2019-09-26
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Spending Time in the Office
Comments posted to this topic are about the item Spending Time in the Office
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers