In the Clouds
The July meeting for the Southern New England SQL Server Users Group is tonight. Andrew Novick will be talking about...
2010-07-14
803 reads
The Scary DBA
Red Gate SQL Source Control
You just have to love Red Gate tools. They find the small area that they want to cover and then...
2010-07-14
1,866 reads
Delivering the Bad News
It’s a Friday, the day governments & companies traditionally deliver bad news. I recived the bad news earlier in the week,...
2010-07-09
719 reads
Small PowerShell Script
I’m still trying to learn PowerShell better. The opportunity to answer simple questions and problems with the tool is hard...
2010-07-06
1,193 reads
One of these things is not like the other
I’m working with PowerShell, and digging it. I decided that I wanted to create a new script (blog post later,...
2010-06-30
2,082 reads
Powershell Fundamentals
I’ve had the opportunity this week to take class with Don Jones (blog | twitter), PowerShell guru and author of PowerShell...
2010-06-25
2,107 reads
Learning Powershell
I’ve been attending a Powershell fundamentals class with Don Jones (blog|twitter). If you read my blog you might be aware...
2010-06-23
1,707 reads
Sarasota SQL Server Users Group
Tonight I’m presenting for the Sarasota SQL Server Users Group. If you’re interested in attending, you can join in using...
2010-06-15
711 reads
Virtualizing Servers in Production
The company where I work has been using virtualization in development, QA, testing, etc., for many years now. We have...
2010-06-15
864 reads
Maps in Reports!
I’ve been playing with SQL Server 2008 R2 for quite a while in the CTP’s and what not. But, I hadn’t made...
2010-06-14
1,226 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