SQL Saturday #162 - Cambridge, UK
Come to Cambridge in the UK for a free day of training on SQL Server. Steve won't be there, but plenty of other Red Gate'ers will be.
Rogue Algorithms
As computers get more complex and automated, the chance for rogue algorithms grows. Steve Jones reminds us that we should be careful in how we code and that a little forethought from managers can help.
Stairway to T-SQL DML Level 9: Adding Records to a table using INSERT Statement
Not all applications are limited to only retrieving data from a database. Your application might need to insert, update or delete data as well. In this article, I will be discussing various ways to insert data into a table using an INSERT statement.
Upgrading SSIS Custom Components for SQL Server 2012
Having finally got around to upgrading my custom components to SQL Server 2012, I thought I’d share some notes on the process. One of the goals was minimal duplication, so the same code files are used to build the 2008 and 2012 components, I just have a separate project file.
Combining AlwaysOn Groups With Failover Cluster Instances
This article discusses failover cluster instances and AlwaysOn groups
Ridiculous
Bad behavior at conferences hasn't been a problem at SQL Server events, but it has been elsewhere. Steve Jones thinks this is unacceptable.
SQL Saturday #170 - Munich, Germany
Free SQL Server training comes to Germany. Join fellow SQL Server pros in Munich on Sept 15, 2012.
SQL Server Data Type Precedence
I am executing a simple query/stored procedure from my application against a large table and it's taking a long time to execute. The column I'm using in my WHERE clause is indexed and it's very selective. The search column is not wrapped in a function so that's not the issue. What could be going wrong?
The Ego, the Id and the DBA
In most organizations, the DBA team is seriously outnumbered by headstrong developers and clock driven managers, and "great" DBAs will often be outnumbered by...well...the not so great. In order to be heard in this environment, a DBA will not only need to be very skilled, but will also need a healthy dose of ego.
Blogs
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
Forums
Why End-User Testing Is Even More Important with AI
Comments posted to this topic are about the item Why End-User Testing Is Even...
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers