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,749 reads
Power BI for Office 365 FAQ
As I have been giving demos on Power BI for Office 365, I have received a tremendous amount of positive feedback,...
2013-12-12
1,797 reads
What a DBA wants for Christmas
In the first few years of ITBookworm.com, we made sure to make up holiday lists of the most awesome gadgets...
2013-12-12
668 reads
SQL Server 2012 Reporting Services Blueprints – Review
Recently Packt Publishing released the book SQL Server 2012 Reporting Services Blueprints authored by Marlon Ribunal (blog|twitter) and Mickey Stuewe...
2013-12-12
778 reads
SQL Saturdays: Day 4
Well, we talked about user groups... Let's talk about their big brother; SQL Saturdays. @SQLCenturion runs them here in OKC. They...
2013-12-12
472 reads
A Full Backup Includes Everything (with a caveat)
Full database backups in SQL Server include all of the data, objects, tables, rows, functions, stored procedures, etc. If something...
2013-12-11
833 reads
SQL Server 2014 Backup to URL
I’m absolutely in love with the concept of being able to create a backup directly to a protected, off-site location....
2013-12-11
1,722 reads
First Week As The DBA Whitepaper Published
For those that attended the webcast I did last week for Idera the companion whitepaper is now available for download....
2013-12-11
835 reads
Database Snapshot failed due to disk space issue
Database snapshot is really a useful feature. As we know, Snapshot database file will keep increasing parallel to the DML...
2013-12-11
1,096 reads
DC SQLSat
This past weekend I had the opportunity to go visit Washington DC. It was the first time I got to stay in the Nation’s capitol for more than just...
2013-12-11
10 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
When the Token Meter is Zero
Comments posted to this topic are about the item When the Token Meter is...
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers