The End of the Mentoring Experiment
Back in April 2011 Steve Jones and I launched The Mentoring Experiment. We had some ideas and some goals, but...
2014-05-29
1,281 reads
Blog Posts
We’re Giving Away SQLSaturday Orlando Vans!
We’re in full marketing mode here in Orlando, looking for ways to grow attendance for our next SQLSaturday coming up...
2014-05-29
1,423 reads
Auditing and Event SubClasses
A recent discussion got me to thinking about Auditing. To be honest, it got started with a complaint about some documentation that seemed overly light about the various fields...
2014-05-28
5 reads
Avoiding a split brain in database mirroring
You’re utilizing the database mirroring high-availability feature, configured to be in the High Safety mode with automatic failover, which means...
2014-05-28 (first published: 2014-05-22)
6,154 reads
Building The SQLSaturday Orlando Marketing Plan-Part 14
Quick notes today:
Event team likes first flyer (retro) better than the second one (doesn’t have enough why, doesn’t use space...
2014-05-28
437 reads
Complexity. How it is calculated.
What are the magic pink numbers you can see in Code Outline window?The answer is very simple - these are Code Complexity...
2014-05-28 (first published: 2014-05-23)
687 reads
How Does Disabling an Index Affect the Index Usage DMV Counters
A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the...
2014-05-28
373 reads
How Does Disabling an Index Affect the Index Usage DMV Counters
A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the SQL Server Dynamic Management Views(DMVs)? Great question! Not one...
2014-05-28
17 reads
Microsoft Dynamics AX 2012 – Multiple Rows In Demand Forecast Table [FORECASTSALES] for each item
Why are there multiple rows for each item in the Demand Forecast Table in Microsoft Dynamics AX 2012? This is...
2014-05-28
733 reads
PASS 2014 NomCom Candidates Announced
Eleven candidates for the nomcom this year, details at http://www.sqlpass.org/Elections.aspx. The NomCom campaign will open on June 2 and close...
2014-05-28
627 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