Stats blob corruptions
There have been a couple odd types of corruption that I’ve been seeing on the forums. I want to take...
2009-08-24
352 reads
Blog Posts
The Need for a College Degree
I'm reading through Brad McGehee'sHow to Be an Exceptional DBAand in chapter 4 he talks about having the right skill...
2009-08-24
2,419 reads
Types Matter!
Louis Davidson (@DrSql) had an excellent series on his blog on the Pillars of Database Design and the one of...
2009-08-24
432 reads
A New Identity
Well, perhaps not a whole new identity, just a consolidation of multiple facets of my online persona. For several years...
2009-08-23
532 reads
Active August –> Week 3 Recap
Well, I had a pretty good week this week. I made an effort and met all my goals:
Eat smaller portions...
2009-08-23
352 reads
Beware the REPLACE function when doing heavy string parsing
I found something interesting the other day. I was attempting to optimize a very heavy string parsing routine using T-SQL...
2009-08-23
8,651 reads
PASS Update #13
It’s been a busy few weeks since update #12. We announced guidelines for submitting content to sqlpass.org, an effort that...
2009-08-23
735 reads
SOX in the City - Preparations for Audit
As I was going through some of my documentation at past clients, I found my summary of the general SOX...
2009-08-23
2,458 reads
The Netbook: 40 Days In
I wrote last month about purchasing a new Toshiba netbook to supplement my mobile computing arsenal. Forty days later, I’m...
2009-08-22
608 reads
Welcome Home !!
I realize I have been relatively quiet for a while, but summer is actually a fairly busy time for us...
2009-08-22
1,208 reads
Blogs
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Forums
Extract sql data in psh
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
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...
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