October speaking schedule: Two Saturdays and a Summit
October is going to be a very busy month for me! Three conferences and a pre-con are on the agenda.
This...
2015-10-01
362 reads
The Data Files
Speaking at SQLSaturday Omaha
In just one week, I’ll be traveling west to Omaha to speak at SQLSaturday there. It’s been a while since...
2015-08-07
401 reads
Speaking at 24 Hours of PASS
I’m thrilled to announce that I’ve been selected to present as part of the next 24 Hours of PASS! The...
2015-05-14
471 reads
Monitoring Your Backups [T-SQL Tuesday #66]
Cathrine Wilhelmsen (b|t) is hosting this month’s T-SQL Tuesday, and the topic she chose is monitoring. All of us, whether...
2015-05-12
1,064 reads
SQL Server 2016 announced… and it’s gonna rock
In what spare time I’ve had this week, I’ve been watching the news coming out of Microsoft Ignite (formerly Tech...
2015-05-06
4,739 reads
Speaking at Iowa Code Camp on May 9
If you’re in the Iowa City area, come to Iowa Code Camp this weekend! They have a great lineup of speakers, covering...
2015-05-05
412 reads
Creating a Self-Contained Multi-Subnet Test Environment, Part II – Adding a Domain Controller
This is the second in a series of articles about creating a simulated environment for testing systems that cross subnets.
Part...
2015-04-29
2,124 reads
Creating a Self-Contained Multi-Subnet Test Environment, Part I – Networking
For a recent presentation on using availability groups for disaster recovery, I needed a test environment that contained multiple separate...
2015-04-21
725 reads
Teach Something New: PowerShell Providers [T-SQL Tuesday #065]
Mike Donnelly (b|t) invited the SQL New Blogger Challenge participants to join in this month’s T-SQL Tuesday, and I’m happy...
2015-04-14
539 reads
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,096 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
setting an ssis param dynamicaly when the sql agent job runs
hi i was hoping for a more elegant way of setting a pkg level...
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...
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