Backup Master Database
The story came from a question someone asked me.
Does Master database support full recovery mode?
As I remembered, by default,...
2012-07-07
6,102 reads
New in SQL 2012 (1)
Learning new is a interesting thing. Today I read several posts regarding the SQL Server 2012 new feature:
1. Indirect Checkpoint
Prior to...
2012-07-01
2,143 reads
Several useful T-SQL Function
1. Using the OVER clause with aggregate functions
The following sample is from BOL:
-------------------------------------
USE AdventureWorks2008R2;
GO
SELECT SalesOrderID, ProductID, OrderQty
,SUM(OrderQty) OVER(PARTITION BY...
2012-06-30
2,618 reads
Rebuild index with "Alter Index Rebuild" or "DBCC DBREINDEX"
You can rebuild all index for a table with "Alter Index Rebuild" and "DBCC DBREINDEX" .
First, in BOL, for "DBCC...
2012-06-27 (first published: 2012-06-23)
17,946 reads
Shrink transaction log file
Sometimes the shrink transaction log file doesn't work.
Before we troubleshoot it, we need to know how the log file works:
Transaction...
2012-06-17
3,061 reads
Max Server Memory
Sakthivel Chidambaram recently created a calculator which can find out the max server memory value based on the input.
http://blogs.msdn.com/b/sqlsakthi/archive/2012/05/19/cool-now-we-have-a-calculator-for-finding-out-a-max-server-memory-value.aspx
you can...
2012-06-02
5,166 reads
Setup windows firewall for SQL Server
On Windows 2008 R2, the windows firewall will turn on by default which causes connection issure for the remote client, here...
2012-06-01
5,404 reads
Backup duration statistics
Here is a simple query which can list backup duration statistics for all database, including the max, min, avg of...
2012-05-25
2,777 reads
Use Powershell script to verify backup files
Before restoring backup, we always verify the backup file first, and run the 3 command below:
1. RESTORE HEADERONLY
Returns a result...
2012-05-17 (first published: 2012-05-12)
8,999 reads
Ad hoc query optimization in SQL Server
When ad hoc queries are executed in sql server, if it is executed without parameters, and it is simple, SQL...
2012-05-15
4,903 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