Set DAC port with a specific number
Usually named instance can uses dynamic port, if firewall setup on the server, you can use SQL Server Configuration Manager...
2013-04-18 (first published: 2013-04-10)
5,075 reads
Use delegated session configuration in Powershell 3.0
Powershell 3.0 has many new feature, and they are useful in some circumstance.
let's say User A log in server A,...
2013-04-05
1,196 reads
Compression Backup with BUFFERCOUNT parameter
If you want to make you backup faster, you can try BUFFERCOUNT parameter with compression backup.
From Book Online description:
BUFFERCOUNT = { buffercount | @buffercount_variable...
2013-04-03
3,122 reads
Get Perfmon data with Powershell
Sometimes you just want to have a look at the system performance, or you feel tired with log on the server, open...
2013-02-21
2,133 reads
"Auto update statistics" option on tempdb
"Auto update statistics" option is enabled by default on tempdb, if it is disabled, you may get trouble in some...
2013-01-28
2,916 reads
Got "Cannot generate SSPI context" error message after changing sql service account
Today I changed a sql server service startup account during testing, then when I tried to connect sql server with...
2013-01-19
12,472 reads
Row of nonclustered index page
Below is the formula of calculating the row size of non-clustered index page
so unique non-clustered index created on unique clustered index use smallest...
2013-01-04
1,194 reads
Heap might take more space than clustered Index when inserting row
Sometimes when you insert row on heap, even if the page has enough free space, the new row can not...
2013-01-03
953 reads
Test Hadoop cluster on vmware
SQL Server MVP Jeremiah Peschka posted 2 articles about Hadoop, which makes me be interested on the nosql skill.
I don't have much knowledge...
2012-12-29
2,841 reads
Explore file physical structure - Delete
1. Create sample db
use master
go
CREATE DATABASE [test] ON PRIMARY
( NAME = N'test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test.mdf' , SIZE = 2048KB , FILEGROWTH = 1024KB...
2012-11-27 (first published: 2012-11-21)
1,744 reads
Blogs
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
SQL Server 2025 CU1 Fixes the Docker Desktop AVX Issue on macOS
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
Forums
25 Years of SQL Server Central
Comments posted to this topic are about the item 25 Years of SQL Server...
The Decoded Value
Comments posted to this topic are about the item The Decoded Value
Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers