Essentialism: The Disciplined Pursuit of Less by Greg McKeown
While on my trip to PASS Summit 2014, I have selected one more book to read on the long flights...
2014-11-17
447 reads
Blog Posts
How To Use the Unpivot Transform in SSIS
Moving data from columns to rows can be a tricky task and accomplished in a variety of ways. That may be...
2014-11-17 (first published: 2014-11-11)
7,982 reads
Interview Questions on SQL Server Database Mirroring
1) What is default port of Database Mirroring Endpoint?
Ans : 5022
2) Database Mirroring comes with which edition?
Ans: SQL Server 2005 SP1....
2014-11-17
20,511 reads
Interview Questions on SQL Server Database Mirroring
1) What is default port of Database Mirroring Endpoint? Ans : 5022 2) Database Mirroring comes with which edition? Ans: SQL Server 2005 SP1. Or SQL Server 2005 RTM...
2014-11-17
4 reads
Last Weeks Top “Reading” Links #109
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-11-17
677 reads
Quickly Add Telnet
Have you found yourself on a server or workstation that doesn't have telnet (typical in new builds and new Azure...
2014-11-17
1,304 reads
Thoughts on Speakers and Topics for PASS Chapters
After wrapping up my part of SQLSaturday Orlando this year I’ve been thinking on what if anything we might do...
2014-11-17
752 reads
PASS Summit 2014 Recap
Every autumn one can observe the pilgrimage of almost all Microsoft Data Platform specialists (SQL Server, Excel, Azure Platform) for...
2014-11-16
306 reads
T-SQL Tuesday #60 Roundup – Step Right Up
We had a great turnout for this months T-SQL Tuesday Block Party. Coming into this month and knowing that I...
2014-11-16
615 reads
How to fix: Visual Studio 2012 startup problem: The 'HDIProjectPackage' package did not load correctly.
After installing Community Edition of VS2013 with some additional packages i've noticed that my VS2012 starts failing to start with...
2014-11-15
3,800 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers