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)
4,851 reads
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)
4,851 reads
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,187 reads
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,092 reads
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,092 reads
"Auto update statistics" option is enabled by default on tempdb, if it is disabled, you may get trouble in some...
2013-01-28
2,806 reads
Today I changed a sql server service startup account during testing, then when I tried to connect sql server with...
2013-01-19
12,396 reads
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,165 reads
Sometimes when you insert row on heap, even if the page has enough free space, the new row can not...
2013-01-03
946 reads
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,830 reads
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,731 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
I've tried different credentials, target server versions, etc. hitting our Primavera WSDL. Works great...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers