Moving Databases to a New Server
Got a plan for moving your data to the new server? Try this one! Andy Warren offers step by step instructions on how to move your data without doing a backup/restore or using detach and attach.
Automatically Gathering Server Information Part 8
The eighth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
Book Review: Guru's Guide to T-SQL
This week, Brian Knight reviews the book Gurus Guide to Transact SQL.
Restoring the Master Database
This article shows you in a step-by-step manner how to restore the master database.
Automatically Gathering Server Information Part 7
The seventh part of Steve Jones's series on having SQL Server automatically report information to a DBA.
Invisible Comments
I ran into a dilemma when I was told that I should not allow potential competitors to view my JavaScript comments. If they want to figure the code out; make them work for it.
Automatically Gathering Server Information Part 6
The sixth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
Computer Problem Report Form
This humorous form was originally desgined for Network Admins, but it works for DBAs as well.
Keeping Your Developers Under Control
Everyone needs a stable environment. This article discussed ways to keep your team on the same page.
Automatically Gathering Server Information Part 5
The fifth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
Blogs
Walking Through a Planned Failover: SQL Server Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
Forums
The Vector Data Type
Comments posted to this topic are about the item The Vector Data Type
What Power BI DirectQuery does to your SQL Server (and how to fix it)
Comments posted to this topic are about the item What Power BI DirectQuery does...
The New OS Wars
Comments posted to this topic are about the item The New OS Wars
Question of the Day
The Vector Data Type
What is the vector data type in SQL Server?
See possible answers