Find Dependencies
Here's a script from my toolbox I use to find dependencies between SQL objects. The where clause has a number...
2012-02-21
1,045 reads
Blog Posts
First Impressions
I was chatting with a friend recently who had been in turn chatting with a colleague about first impressions. The...
2012-02-21
974 reads
How to Upgrade SQL Server 2000 Instance to SQL Server 2005
Introduction
The purpose of this tutorial is to lay out the general guidelines for planning a SQL Server 2005 upgrade. As...
2012-02-21
1,940 reads
I see no SQL Server 2008 Counters in Perfmon?
This problem is a real pain and I’m yet to determine why this issue occurs because my understanding is SQL...
2012-02-21
4,638 reads
PASS Virtual Chapter: SSIS Enhanced Threading Framework
I'll be giving a presentation tomorrow, Tuesday 2/21/2012 at 12PM EST on my Enhanced Threading Framework design. Here is the...
2012-02-21
416 reads
Please vote for my SQLRally session
I’m hoping to do a presentation at SQLRally in Dallas on May 10-11, but I need your help!
There is a...
2012-02-21
735 reads
Shameless Plug: Vote For My Sessions!
Have you voted yet for my sessions your favorite sessions for SQL Rally? If not, this is a friendly reminder...
2012-02-21
621 reads
Show Us Your Coolest SSRS Reports
I’ll show you mine if you show me yours. Over the past nine years or so, I have showcased many...
2012-02-21
918 reads
SSIS Script Component Source -- Proc/Select Stmt
I've been asked on several occassions to provide an example of the custom sources I use in my "SSIS Tips&Tricks" presentations. I had to build one moments ago and...
2012-02-21
10 reads
SSIS Script Component Source -- Proc/Select Stmt
I've been asked on several occassions to provide an example of the custom sources I use in my "SSIS Tips&Tricks"...
2012-02-21
1,347 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers