SQLCruise Contest
For those who may not have heard, there is training for SQL Professionals called SQL Cruise. You can find more...
2011-01-05
671 reads
SQL RNNR
SQLCruise Contest
For those who may not have heard, there is training for SQL Professionals called SQL Cruise. You can find more info here. There is a bit of interesting news...
2011-01-05
1 reads
MockingJay – a review
After a long wait, I have finally read the final installment in the “Hunger Games” trilogy. I read the other...
2011-01-04
577 reads
MockingJay – a review
After a long wait, I have finally read the final installment in the “Hunger Games” trilogy. I read the other two books earlier in the year in 2010 and...
2011-01-04
1 reads
2010-12-28
671 reads
2010 Recap
As a part of a recap on the year that was 2010, I should start with a recap of my goals. For that review I had to go back...
2010-12-28
1 reads
SSIS Multiple File Export
Have you ever needed to export different data sets to different flat files? Each of these data sets could be...
2010-12-28
1,465 reads
SSIS Multiple File Export
Have you ever needed to export different data sets to different flat files? Each of these data sets could be customer information for different clients – but they all...
2010-12-28
38 reads
Powershell, Me and the MCM part II
Last week I posted the first part of this series. I thought it would be a good idea to give...
2010-12-20
822 reads
Powershell, Me and the MCM part II
Last week I posted the first part of this series. I thought it would be a good idea to give a little follow-up on how my foray into Powershell...
2010-12-20
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
combining a param value with widcards in a foreach loop files property
Hi, it isnt clear from the web if something like this should work as...
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...
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