Beginning Powershell Companion PDF
Howdy all…as is so often the case, I’m studying something – Powershell – and I’m in need of a reference to help...
2011-01-06
3,404 reads
Blogs
January Question: As a DBA, how do you manage your disk space?
Managing disk space is an important resposibility of the DBA, and there are many ways to perform this task. In...
2011-01-05
2,088 reads
31 Days of SSIS – Raw Files Are Awesome (1/31)
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. Let’s start off this series with a...
2011-01-05
3,133 reads
Can You Dig It? – StmtCursor and StmtReceive Elements
She can dig it!
D Sharon PruittA few posts ago in the plan cache series I discussed the children for the...
2011-01-04
1,211 reads
SQL Server Workload Types and Hardware Selection
There are two primary relational workload types that SQL Server commonly has to deal with, the first being Online Transaction...
2011-01-03
2,280 reads
Getting a Dedicated Admin Connection
Did you know you can easily get a Dedicated Admin Connection (DAC) in SSMS? I didn’t assuming that I’d need...
2010-12-31
1,433 reads
PBM and PowerShell
The best new management feature added to SQL Server 2008 is Policy Based Management or PBM. PBM allows DBAs to...
2010-12-30
1,727 reads
SQL Server Storage Internals Part 5 - Properties of Clustered and Non Clustered Index pages
In this article, I thought of explaining different types and levels of index pages. but while start preparing for that, I realise...
2010-12-29
5,713 reads
The Twelve Days of (SQL) Christmas
Once upon a time a group of twelve bloggers agreed to each pick a post (or posts) they found interesting...
2010-12-28
1,371 reads
SQL Server Storage Internals Part 2 - Partitions and Allocation Units
Before moving on to see anatomy of different types of pages, lets spend some time to understand
The relationship among sys.objects,...
2010-12-27
4,468 reads
Blogs
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...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
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