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,078 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,197 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,123 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,134 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,917 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,474 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,195 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
957 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,842 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,748 reads
Blogs
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers