Mitigating Consulting Risks
In my last post on consulting, Isn’t Consulting Risky?, I contended that in many respects, when done with sufficient forethought...
2010-03-02
1,200 reads
Blog Posts
My First SQL Lunch
SQL Lunch has been a great resource for a while now, delivering lunchtime presentations. I was recently asked to be...
2010-03-02
342 reads
Personal "Failure" Is Just a Result
I'm reading a book by two teens called Do Hard Things. It's a book which represents a rejection of the...
2010-03-02
975 reads
SQL Server - MVP Deep Dives
I got my copy of MVP deep dives earlier this month and have been making good progress in reading some...
2010-03-02
857 reads
Using Database Transactions across multiple SSIS Tasks
If you experiment at all with transactions that are built into SSIS you will discover that they are highly flawed. ...
2010-03-02
2,580 reads
Using Excel 2007 in SSIS 2005
Many companies are not in a rush to upgrade their SQL Servers because of the enormous cost to upgrade. This...
2010-03-02
1,035 reads
Volunteering Commitments
When you volunteer, you greatly enrich your life. I saw a post recently from Jason Brimhall talking about the volunteering...
2010-03-02
980 reads
Winner of the February SQL Aloha Contest
In February, I started a monthly contest at www.bradmcgehee.com to help spur some sharing of best practices among DBAs. The...
2010-03-02
370 reads
How Do You Drive Your DBA Mad?
I’ve written about a few ‘worst practices’ over the years to call attention to some things that are bad (or...
2010-03-01
1,580 reads
March Question: What is the biggest mistake/problem you have ever found on a SQL Server instance, and how did you fix it?
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-03-01
1,003 reads
Blogs
SQL Server is Slow, part 3 of 4
By Kevin3NF
In parts 1 and 2 of this series, we’ve gathered info and done the...
AI Model Size, Parameters and Download
By Steve Jones
At SQL Saturday Boston 2025, I gave a presentation on local LLMs and there...
Expanding Your DBA Horizons: Installing PostgreSQL in a Home Lab
By gbargsley
Are you diversifying your DBA skillset? My recent job search made one thing clear:...
Forums
caught off guard by some greek lettering in a warehouse feed
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Vector Datatype
Comments posted to this topic are about the item Vector Datatype
Question of the Day
Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers