SQLSaturday Madison – April 7-8
The first event I ever spoke at was SQLSaturday in Madison, Wisconsin, back in 2012. I was petrified – would anyone...
2017-03-28
384 reads
The Data Files
An open letter to the PASS community
PASS is our community.
It may sound a little cliche in this time of election propaganda in the US, but it’s...
2016-09-28
709 reads
SQL Sentry Plan Explorer is now free
You’ll probably hear about this from other sources, but an announcement made this morning bears repeating: One of my favorite...
2016-09-16 (first published: 2016-09-09)
2,709 reads
Defending your data
Which of these is more secure?
shilmar / Pixabay
Nicolas Chadeville / 500pxIt’s a trick question – the correct answer is “neither”.
Both castles and vaults...
2016-09-07
429 reads
SQLSaturday Indianapolis Wrap-Up
This weekend, I attended SQLSaturday in Indianapolis for the first time. It’s one of the larger events in the Midwest...
2016-08-15
467 reads
Security VC Webinar: TLS 1.2 and SQL Server
The PASS Security virtual chapter hosted a great webinar on Thursday. Amit Banerjee from Microsoft’s SQL Server Tiger Team (b|t)...
2016-07-02
886 reads
I’m speaking at Summit!
I’m excited to announce that I have been selected to speak at PASS Summit again this year! I’ll be presenting...
2016-06-23
344 reads
SQLSaturday Iowa City is this weekend!
If you’re within driving distance of Iowa City, IA, I’d love to see you at SQLSaturday Iowa City this weekend!...
2016-06-06
433 reads
Save the date: SQLSaturday Iowa City
Q: True or False – Iowa has one of the world’s longest-running SQL Server conferences?
A: True! SQLSaturday #19 was held in the fall of...
2016-01-28
1,007 reads
Speaking at SQLSaturday Chicago
I’m happy to announce that my first public session of 2016 will be at SQLSaturday Chicago on March 5! I...
2016-01-26
430 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Query compile/runtime issue
I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time...
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams n;See possible answers