Snapshots Part 1 Published on SSC
Snapshots Part 1 covers the basics of doing a snapshot regardless of what type of replication is being used. In...
2008-02-26
1,249 reads
Blog Posts
The Launch
The launch event is tomorrow in LA and I'm not going, and find myself a little disappointed. There will be...
2008-02-26
1,392 reads
Using TripIt for Travel Plans
Not a SQL related topic today.
I first noticed Tripit on Joels Blog and so far it solves a problem I've...
2008-02-26
1,288 reads
Perks at Work - A Good Thing?
Free oil changes, extra week of vacation when you get married, etc, etc, all things mentioned in this article someone...
2008-02-25
1,417 reads
Lessons Learned from SQLSaturday #2 - Tampa 2008
I posted earlier about the event being a great success with more than 200 attendees, in this post I want...
2008-02-24
1,477 reads
The Advantages of Telecommutting
It isn't often that I see what the real advantages are, and I've been doing it so long that I...
2008-02-22
1,346 reads
Call for Speakers for PASS Summit is Open Through March 28, 2008
The Summit is being held in Seattle, WA, Nov 18-21, 2008. Call for speakers is open through March 28. It's...
2008-02-21
1,427 reads
LINQ Again!
I recently attended SQLSaturday#2 in Tampa and had the brief chance to chat with David Hayden about LINQ (I suspect I...
2008-02-21
1,811 reads
Changing the Command Prompt
I spend a lot of time at the command prompt and to be perfectly honest, I'm tired of looking at:
...
2008-02-20
1,751 reads
New Book from Celko - Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL
I've been meaning to post this, Joe's latest book Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in...
2008-02-20
1,529 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
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:...
Removing TDE
Comments posted to this topic are about the item Removing TDE
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