Powershell, Me and the MCM
If you haven’t heard yet, Microsoft has made some significant changes to the MCM program. The changes make the certification...
2010-12-16
867 reads
SQL RNNR
Powershell, Me and the MCM
If you haven’t heard yet, Microsoft has made some significant changes to the MCM program. The changes make the certification more accessible to the masses. You can read more...
2010-12-16
1 reads
Tis the Season
This month has been quite the month for change in my family. The changes that we are experiencing did not...
2010-12-15
538 reads
Tis the Season
This month has been quite the month for change in my family. The changes that we are experiencing did not end with the birth of our baby girl two...
2010-12-15
1 reads
T-SQL Tuesday #13 – Business Requirements
Business Requirements
We have made it yet another month and to yet another episode in the continuing saga known as TSQL...
2010-12-14
654 reads
T-SQL Tuesday #13 – Business Requirements
I think a common area that is easily overlooked when it comes to requirements and interpretation of requirements is report creation. A common problem is that there are no...
2010-12-14
Wait Stats resources
Today I was out and about looking for past roundups on TSQLTuesday. While doing that, I came across a post...
2010-12-13
704 reads
Wait Stats resources
Today I was out and about looking for past roundups on TSQLTuesday. While doing that, I came across a post from Paul Randal (Blog | Twitter) about wait stats. The...
2010-12-13
2 reads
SSIS Job Execution
While working on a process to refresh the QA environment (data purge, reload data and reapply changes made over time...
2010-12-13
703 reads
SSIS Job Execution
While working on a process to refresh the QA environment (data purge, reload data and reapply changes made over time as parts of release cycles), I ran into self-imposed...
2010-12-13
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