The Next Phase of My Career
For anyone who hasn't seen an update somewhere else in the social media universe, I recently started a new job...
2013-11-18
619 reads
Nebraska SQL from @DBA_ANDY
Hung SQL Server Restores from Tivoli Storage Manager/Tivoli Data Protection
I ran into this with a client last night when trying to restore their SQL Server data warehouse database from...
2013-07-10
2,488 reads
New Page - "How to Get Involved With the SQL Server Community"
I recently composed an email (on the side) for a client DBA looking for info on getting involved with the...
2013-06-19
512 reads
SQLPerformance.com
I have had the opportunity to go through the first three SQLSkills Immersion Events, and one of the side benefits...
2013-05-28
612 reads
T-SQL Tuesday #42 - The Long and Winding Road
It's T-SQL Tuesday again (Thanks go to Adam Machanic (B/T)) and this month the host is Wendy Pastrick (B/T). Wendy's...
2013-05-14
662 reads
Announcing SQL Saturday 197 Omaha Pre-Cons!
Here is a flyer produced by someone on the team - he says it all very well:
--
Friday, April 5, 2013
Get Warmed...
2013-02-07
803 reads
The Value of Certifications
A former co-worker recently sent me an email asking about Microsoft certifications, and if I pursued them, and what I...
2013-02-05
1,093 reads
Why is My New Server Under CPU Pressure?
Signal waits frequently translate to the amount of time that SQLOS is under pressure for CPU resources, as outlined in...
2013-01-28 (first published: 2013-01-24)
2,924 reads
Everybody Needs to Know About Recovery
My friend and SQL Server professional Tim Radney (blog/@tradney) has written a new entry in the Joes2Pros series:
You can get...
2012-11-01
756 reads
A Minor Problem of Access
A colleague sent this - they received a trouble ticket where a user who had "all access" to the database couldn't...
2012-10-19
631 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