Quick Tip: SSIS and SAP BW
Frustration.
If you have ever had to work with Integration Services and data sources other than the Microsoft variety you know how frustrating...
2012-11-15
3,854 reads
Blog Posts
Recent Presentation Session Files
Recent Presentation Session Files
Session Files – A Little Behind
I’ve been a little tardy about getting my session files posted, and I’m...
2012-11-15
884 reads
Rules of Holes #3: A Better Shovel is NOT the Answer!
You stopped digging. You looked around and saw that you were still in the Hole. You needed to get out. AHA! Problem solved, you thought. You'll just get a...
2012-11-15
5 reads
Rules of Holes #3: A Better Shovel is NOT the Answer!
You stopped digging. You looked around and saw that you were still in the Hole. You needed to get out. AHA! Problem solved, you thought. You'll just get a...
2012-11-15
6 reads
SQL Server Express with complete SSMS
Developers will love this latest improvement, specially those that have SQL Server Express installed on their laptops or workstations but...
2012-11-15
1,292 reads
SQL Server Version Upgrade
SQL Server Version Upgrade - You have SQL Server running nicely with no issues or problems. The trouble is its SQL...
2012-11-15
1,179 reads
Claim Based Authentication || Part 3
Hey Friends,
Back with the topic: Claim Based Authentication. For this topic blogs becomes too large and still feel learning is...
2012-11-14
1,687 reads
How to save deadlock graph events as .xdl file in SQL Server ?
How to save deadlock graph events as .xdl file ?
On the File menu, click New Trace, and then connect to...
2012-11-14 (first published: 2012-11-07)
3,601 reads
Migrating to SQL Server 2012
I had the opportunity to deliver my Migrating to SQL Server 2012 presentation at the PASS 2012 Summit last Friday...
2012-11-14
1,340 reads
problem solving: sometimes you need to walk away from a problem to solve it
If anyone is a believer in solving challenges through sheer force of will, it's me. I'm a stubborn man and...
2012-11-14
717 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
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