PASS First Timers Guide
Hi there ho there everybody! I am now a Big SisterFearless Leader of a group of PASS Summit first timers!...
2011-09-17
630 reads
SQL Awesomesauce
PASS First Timers Guide and Schedule
Hi there ho there everybody! I am now a Big SisterFearless Leader of a group of PASS Summit first timers!...
2011-09-17
773 reads
PowerShell for the Easily Frustrated N00b, or, “A Simple and Useful Command”
The stupid, stupid Windows search (Start Menu > Search) doesn’t work on one of my computers (running WinXP Pro). Yes, I made...
2011-09-15
484 reads
Great Tools for Formatting T-SQL
I have a big rant I add to….well, to every single SQL session I give. That rant is on formatting...
2011-09-12
1,186 reads
Little Workaround in Report Manager
I had an issue this week in Report Manager. I was generating a report (we’ll call it General Widgets Report),...
2011-09-09
863 reads
I need #sqlhelp! BIDS shuts down unexpectedly
I have MS Visual Studio 2008 (BIDS) x86 with SP1. Recently it’s started shutting down without warning whenever I hit...
2011-09-08
587 reads
I need #sqlhelp! BIDS shuts down unexpectedly – SOLVED
Edit: See end of blog for solution.
I have MS Visual Studio 2008 (BIDS) x86 with SP1. Recently it’s started shutting...
2011-09-08
685 reads
SQL Education
They always used to tell us that education is important.
Education is (They said) key, in fact. We as a technical...
2011-09-05
468 reads
Applied SQL: Server Side Traces
It’s time to get your server side trace on, with a little practical application!
I introduce this whole concept in Applied...
2011-08-29
765 reads
Applied SQL: sys.sql_modules
I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page.
Prerequisites: basic...
2011-08-18
1,383 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