It’s a Data World
I saw this blog about a report from CITA (wireless industry group) that people tend to use their cell phones...
2010-05-19
673 reads
Blog Posts
June OPASS Meeting Date Change
Andy Warren (@sqlandy) already blogged about the change here, but I there might actually be someone who reads my blog...
2010-05-19
265 reads
oPASS June 2010 Meeting Date Change
Normally we meet on the second Tuesday of the month, but in June we’re going to have to push the...
2010-05-19
567 reads
PowerShell Week at SQL University – Post 2
Cmdlets, Functions and Snapins
So far we’ve learned how to open up PowerShell and add on to it with some modules;...
2010-05-19
1,068 reads
Providing Quality to the Community
This has been on my mind since last week after a conversation with a friend of mine, Bobby Dimmick (twitter)....
2010-05-19
1,189 reads
Reporting on TechEd
Last week I blogged about attending TechEd 2010 on a press pass, and since then I’ve been trying to come...
2010-05-19
560 reads
SQL Server Utility Script From 24 Hours of PASS
I had a good time giving my presentation and demo of SQL Server Utility during the fourth hour of the...
2010-05-19
2,212 reads
TableSpace Update
The last post in the series on finding the sizes of your tables showed us how we could find that...
2010-05-19
1,435 reads
Unofficial Poll on 2010 PASS Summit Keynote Speaker
I’ve blogged on this before, here and here, and ended up chatting about it on Twitter (see, I do use...
2010-05-19
666 reads
Vote for The Keynote by Dr. DeWitt
You can choose from how query optimization works and why it’s so hard, or how relational engines and MapReduce can...
2010-05-19
656 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