Am I a bad employee if I don't blog?
No.
Blogging is not for everyone and you don't want to give the impression you are something you are not doing...
2009-06-22
1,603 reads
Blog Posts
Big Thinker
My friend Robert Cain was kind enough to include me on his list of big thinkers along with my business...
2009-06-22
804 reads
Emergency Procedures
In a followup to Aaron Bertrand's recent blog post on Disaster Recovery, I'd like to mention something I always mention...
2009-06-22
367 reads
Migrating A SQL Server 2005 Reporting Services Named Instance, The Missing Manual
Microsoft has always been pretty good at one thing, ease on install.
One of the things I always says is...
2009-06-22
3,364 reads
Tips on Getting Hired – Part 4
Getting a job is hard. If you’ve been lucky enough not to struggle for a job, don’t make the mistake...
2009-06-22
1,226 reads
Tips on Getting Hired – Part 5
I think the hardest part about the job search is interviewing and not being selected. You keep saying “why” with...
2009-06-22
609 reads
When the next object-persistence boat comes in.
I was reading a MCP training manual for SQL Server the other day. It was good. The whole of TSQL...
2009-06-22
1,746 reads
Adventures in Powershell SSIS Administration Programming
In January 2009, I released version 1.4 of SQL Server Powershell Extensions which included a Library of functions for working with...
2009-06-19
1,538 reads
Best Thing I Learned at PASS Summit
If you haven't heard, PASS is running a contest where you could win conference registration to this year's PASS Community...
2009-06-19
1,268 reads
Moron's Guide to SSIS : Episode 2 - Introduction to the Dataflow
Today Pragmatic Works release it’s second comedic training video featuring Dustin Ryan as “Dustin” and Brian Knight as “Gary” Dustin’s...
2009-06-19
690 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers