ALTER AUTHORIZATION sql to change owner of a database
ALTER AUTHORIZATION changes the ownership of entities . Server level entity ownership can be changed to server- level principals. Database level...
2011-09-27
101,446 reads
- Interests: Performance Tuning Database Servers, Running and Coffee
Performance Monitor Counters for SQL Server performance testing
I posted “Window Perfmon scripting, SQL Server perfmon and how to perfmon” which refers to a performance monitor counters.
The perfmon counters...
2011-09-23
3,430 reads
SSIS version in SQL Server
Integration Services is the management interface for SSIS packages. SQL Server uses the “MsDtsSrvr.exe” for executing packages
To highlight the point,...
2011-09-22
1,067 reads
Migrating to SQL Server from another Database platform
Migrating to SQL Server from another Database platform has a number of considerations
1) Create an inventory of existing applications. Separate into...
2011-09-20
1,159 reads
Import Data from AS400 to SQL Server
The process to import data from AS400 uses a SQL Server Linked server. The Linked Server points to an ODBC...
2011-09-16
17,092 reads
Powershell , Excel charts and data presentation
The topic for T-SQL Tuesday is Data Presentation. Powershell to Excel is a a good way to presenting data, and...
2011-09-13
3,287 reads
SQL Server Quiz – the last time a stored procedure was executed
A developer rushes up to you and asks "can you tell me the last time this stored procedure was executed?"....
2011-09-13
1,148 reads
TPC-H generate test data , test queries and sql database benchmark
This is a followup on my earlier post ofSQL Server test data generation testing tools.
I had some requests for my...
2011-09-08
5,650 reads
Database Cost Savings
I watched a video recently by Forester Research , discussing Database Cost Savings. The video was intended for IT decision makers,...
2011-09-05
887 reads
Server sudden shutdown unavailable
It’s not always straightforward to diagnose a server problem. You look through the SQL Server Logs and Event Viewer for...
2011-09-03
1,045 reads
Blogs
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Forums
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Upgrading Admin Queries
Comments posted to this topic are about the item Upgrading Admin Queries
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers