It's Dangerous to ISNUMERIC, Take This Try_Convert
There's an issue with some characters in T-SQL when validating numeric values out of raw varchar fields, and it can...
2013-12-17 (first published: 2013-12-12)
5,705 reads
Will Assaf
Upcoming Special Events for the Baton Rouge SQL Server User Groups
I'm happy to announce a big slate of upcoming events for Baton Rouge User Groups and especially the SQL Server...
2013-12-03
634 reads
Speaker Idol Competition at the Hammond .NET User Group
Here's the link to download the sample scripts and meme-tastic slidedeck from my presentation "SQL Server Indexes in Your Ill-Begotten...
2013-11-20
532 reads
Potential Backup Software Issues with Read-Only Databases in FULL Recovery
If you decide to park a database in read-only mode for a long period of time, go ahead and alter...
2013-11-13 (first published: 2013-11-05)
2,026 reads
PowerShell: Delete Unneeded Rows/Columns In Excel
I had a project to automate the import of a large number of excel files via SSIS into SQL 2012....
2013-11-08 (first published: 2013-11-01)
6,942 reads
SQL Saturday #255 Dallas 2013 - SQL Server Permissions and Security Principals
500+ IT pros at UT-Arlington this weekend for SQL Saturday #255 Dallas!
Notes from today:
A big shout-out to SQLSat Dallas organizer...
2013-11-03
712 reads
SQL Server Configuration Manager (sqlserverManager11.msc) Hidden after Windows 8.1 Upgrade
You may have noticed, like I did, that after upgrading-in-place from Windows 8 Enterprise to Windows 8.1 Enterprise, my local...
2013-10-22
7,257 reads
"SQL Server: Bolts to Buzzwords" presentation for the Hammond .NET User Group at Southeastern Louisiana University
One of my favorite groups to speak for (aside from the Baton Rouge SQL Server User Group) is the Hammond...
2013-10-17
432 reads
Houston Tech Fest 2013 - SQL Admin Best Practices with DMV's
Here is the downloadable file with all my sample scripts and slidedeck from my SQL Admin Best Practices with DMV's presentation from...
2013-09-28
1,043 reads
Actual Emails: TL;DR: Stop using varchar(max)
Wrote this email recently to a crew of developers who were shooting themselves in the foot with a database rich...
2013-09-05 (first published: 2013-09-03)
3,212 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
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...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
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