Documentation: Are You Ready?
Would your coworkers know how to handle your job if you weren’t there?
This question was top-of-mind for me last week...
2015-04-07
1,094 reads
Blog Posts
Error: Unknown Property ismemoryoptimized
If you’re starting the process of moving your databases in Azure SQL Databast to v12, you need to do one...
2015-04-07
2,063 reads
Exam Prep 70-463: Deploying projects in SSIS 2012
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-04-07 (first published: 2015-03-12)
7,228 reads
Excel Tip #24: Removing “Buttons” from Excel Charts
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-04-07
873 reads
Get Started and Build Your Own SQL World
“Sir, thank you for taking this meeting. We have this new thing to show you. It will allow you to...
2015-04-07
898 reads
How to Add Users to Roles in SSAS, a.k.a., Where the Heck are the Buttons?
I’ve been responsible for administering Analysis Services (SSAS) on a regular basis for the past 7-8 years via SQL Server...
2015-04-07
799 reads
My Favorite FREE Reports in SSMS
Microsoft has given us DBAs/Developers/etc. a wealth of free reports integrated into SQL Server Management Studio (SSMS) in order to...
2015-04-07
796 reads
PowerShelling SQL Saturday Sessions to the Guidebook app
Following on from my previous post about parsing XML where I used the information from Steve Jones blog post to...
2015-04-07
784 reads
SQL New Blogger Challenge: Week 1
WOW!
The response to the SQL New Blogger Challenge I issued a couple of weeks ago has been absolutely incredible. At...
2015-04-07
503 reads
SQL Server Quickie #23 – Plan Cache Pollution
Today I have uploaded the 23th SQL Server Quickie to YouTube. This time I’m talking about Plan Cache Pollution in...
2015-04-07
903 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