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,603 reads
Kindle for the Blackberry
Saw the announcement by accident while doing some browsing on Amazon. Thought I’d try it out just to see. Download...
2010-03-02
233 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
375 reads
Tsunami in Paradise
Not a tsunami, but high surf on the Kohala Coast, near where we live.
We received the first phone call at...
2010-03-01
740 reads
Speaking at Charlotte, NC - SQL Saturday #33
If you are near Charlotte, NC, I will be speaking at their SQL Saturday on March 6th, 2010. My session, SQL Server...
2010-03-01
503 reads
SSRS – KPIs without Analysis Services
During a recent project I was asked if it was possible to simulate Key Performance Indicator (KPI) images in SQL...
2010-03-01
2,412 reads
PowerShell for Batch Operations
I’m right in the middle of moving one of our databases from Oracle to SQL Server (and I just love...
2010-03-01
1,690 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,010 reads
Speaker Evaluations for SQLSaturday #32 – Tampa
I recently received my Speaker Evaluations for my session, Why I Use Stored Procedures, from Pam Shaw (@pamshaw) and as...
2010-03-01
441 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,586 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
Alamat BCA KCP Iskandar Muda Telp/Wa:0821-8200-233
Hub CS 08218200233 Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec....
BCA KCP Panglima Polim Raya Tlp:0821-8200-203
Telp/Wa 628218200203 Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby....
Alamat BCA KCP Kota Kasablanka Tlp/Wa:0821-8200-174
Hub CS 08218200174 1st Floor – Unit B EightyEight@kasablanka, Jl. Raya Casablanca No.Kav. 88,...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers