Article Of the Week
I really enjoy reading technical articles. They often enlighten me on new technologies or provide me with a new way...
2009-08-24
944 reads
SQLDownSouth
SQL Profiler – Wild Card Filter on TextData
WARNING: This may be very obvious to most of you. However, several people that I have encountered did not realize...
2009-08-21
37,268 reads
August SQL Server User Group – Near Real-time Data Warehouse
Well we had a really good meeting this week at our User Group. There were about 17 physical attendees and...
2009-08-19
853 reads
Replication – Accommodating Application Inserts
Recently I have been involved in lots of projects involving replication. I have done some things to make replication work...
2009-08-17
1,270 reads
Upgrading To Windows 7
Well I spent most of this past Saturday upgrading my Laptop to Windows 7 Ultimate, which I have to say...
2009-08-13
750 reads
Database is in Transition
One of my clients called saying they were receiving the following error when trying to access a database: "Error 952...
2009-08-12
7,034 reads
LIVE MEETING REMINDER - Baton Rouge SQL Server User Group
Reminder: The Baton Rouge Area SQL Server User Group will be broadcasting its user group via live meeting. If you...
2009-08-12
452 reads
Adding Multiple Columns to a Table With a Single T-SQL Statement
You know, I believe the old saying, “If you don’t use it you will lose it”. Well, I write a...
2009-08-10
81,549 reads
Baton Rouge SQL Saturday – Evaluation Summary
Well I just finished reviewing the evaluations for my presentation, Introduction to SQL Profiler, which I gave at the Baton...
2009-08-07
481 reads
Use SQL Compare by Red Gate to Find a Missing Index
A couple of weeks ago one of our developers sent me an email saying, “I have a query that returns...
2009-08-07
4,352 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers