Back Home after PASS 2009
I got home Friday evening after spending several days in Seattle at PASS 2009. This was my seventh PASS Summit...
2009-11-08
439 reads
Give SQL Server 2008 R2 CTP a Quick Try for Free
You have probably heard that the SQL Server 2008 R2 CTP is available, but you may not have given it...
2009-11-08
416 reads
SSIS – Avoid OLE DB Command
I decided to do a little performance testing on some common SSIS “Tricks” that increase speed and effectiveness of SSIS...
2009-11-07
2,781 reads
SSIS - Fast Parse
I had another chance last week to answer an email follow up question from the session Brian and I gave...
2009-11-07
854 reads
Basic SSIS Interview Questions
I have decided to make a short series of blogs about possible interview questions to help you prepare for an...
2009-11-07
1,953 reads
Answers to Basic SSIS Interview Questions
This is just a starting point for you to prepare for your interview so make sure not to limit yourself...
2009-11-07
2,324 reads
Answers to Advanced SSIS Interview Question
Last week I wrote a set of Advanced SSIS Interview Questions. Here are the answers I came up for these. ...
2009-11-07
2,011 reads
Better Know A SSIS Transform – The Pivot Transform
This is part 1 of my 29 part series called Better Know A SSIS Transform. Hopefully you will find the...
2009-11-07
741 reads
Better Know A SSIS Transform - The Sort Transform
This is part 2 of my 29 part series called Better Know A SSIS Transform. Hopefully you will find the...
2009-11-07
1,512 reads
Tampa Code Camp 2009
I presented a 1 hr session at Tampa Code Camp 2009: PowerShell for Developers In this sesssion we will look...
2009-11-07
654 reads
Blogs
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...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
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