Linear Gauge Control: A Practical Use
SQL Server Reporting Services 2008 introduced several new features. One key feature was the inclusion of the Gauge Controls. I...
2009-12-01
7,773 reads
Blog Posts
MDX Utility Belt of Calculations Part 1
Developing MDX calculations is one of the most confusing and time consuming pieces of building an Analysis Services cube. That...
2009-12-01
2,696 reads
MDX Utility Belt of Calculations Part 2
This post is a part of a series of blog posts I am writing to give you a Batman-like Utility...
2009-12-01
1,771 reads
Upgrading to Windows 7
I’ve been using Win 7 on my dev machine for a few months now, and finally decided over the Thanksgiving...
2009-12-01
496 reads
Using Resource Monitor In Windows Server 2008 to Look at I/O Performance for SQL Server 2008
One quick and dirty tool that I like to use to monitor I/O performance at the file level is Resource...
2009-12-01
2,299 reads
Using Social Media to become more social
I saw this report that a good percentage of online social media users (27%) find that their offline relationships benefit...
2009-12-01
1,348 reads
Are You a Giver or a Taker?
I have been involved in the SQL Server community since 2000, and during the past nine years I have seen...
2009-11-30
1,451 reads
Columbia Code Camp!
The Midlands of South Carolina will be hosting a Code Camp on January 30, 2009. You can register as an...
2009-11-30
1,698 reads
Linear Gauge Control: A Practical Use
SQL Server Reporting Services 2008 introduced several new features.One key feature was the inclusion of the Gauge Controls.I was recently...
2009-11-30
1,731 reads
Maintaining Security and Performance Using Stored Procedures Part II – Signing
Well, it has been a couple of weeks since my last blog post and over a month since Maintaining Security...
2009-11-30
1,648 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