Review: SSD Tweaker
Ran across this while doing some other reading, SSD Tweaker lets you change a few settings that are supposed to...
2010-05-05
574 reads
Blog Posts
SQL 2005 TableSpace
In the first post of this series I highlighted and described two stored procedures that are shipped from Microsoft. These...
2010-05-05
4,694 reads
SQL Server Integrity Checks – DBCC CHECKDB
I like to run integrity checks against my databases very regularly, sometimes daily if I can get away with it....
2010-05-05
2,180 reads
Using CPU-Z to Discover Hardware Information
I think it is very important to be able to discover exactly what type of hardware is in an existing...
2010-05-05
1,004 reads
Winner of the April SQL Aloha Contest
This month’s question had 28 responses, and as usual, I found it difficult to select a winner because all of...
2010-05-05
495 reads
A Glimpse of the Future
I’m not sure what happened here. I walked up to my desktop, wiggled the mouse, and nothing happened. In the...
2010-05-04
535 reads
CLR Stability
Recently I was at a UK user group meeting and Simon Sabin of SQL Skills presented a short “SQL Nugget”...
2010-05-04
646 reads
How Can I Tell if SQL Agent is Running via SQL?
Introduction
Today’s post is a continuation in my on-going effort to document all of the scripts I use to manage my...
2010-05-04
413 reads
May Question: What is your favorite DBA joke?
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-05-04
823 reads
Nominations for the 2010 Exceptional DBA Award are Now Open
SQLServerCentral.com, along with Red Gate Software, are glad to announce that nominations for the 2010 Exceptional DBA Awards are now...
2010-05-04
1,554 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