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,661 reads
SQL Tact
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
631 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
528 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,018 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
710 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,810 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,249 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
430 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,042 reads
Replicated Stored Procedure Execution
One feature that many of my clients are unaware of is that the batched execution of a stored procedure can be...
2013-09-04
2,094 reads
Blogs
Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
The Book of Redgate: Don’t be an a**hole
By Steve Jones
This was one of the original values: The facing page has this text: No...
Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
I Love Editorials
Comments posted to this topic are about the item I Love Editorials
Line number in error message doesn't match up with line number in code
Hi everyone I have a 1000 plus line query and I am getting an...
Question of the Day
A Common Split
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers