SQL Server 2008 Service Pack 2 Released
Some of my clients and I have been waiting on this for a little while – SQL Server 2008 Service Pack...
2010-09-30
1,687 reads
StrateSQL
PASS Summit Schedule
Earlier this week, PASS opened up the Schedule Builder for the those that are registered for the PASS Summit. You...
2010-09-30
1,553 reads
To Be There Or Not To Be There
Are you ready for Seattle? Have you registered for the PASS Summit? Hopefully with some good reasons you will be...
2010-09-28
675 reads
Index Black Ops Part 4 – Index Overhead and Maintenance
In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in...
2010-09-27
1,121 reads
Is It that Time Again?
Yes, it is. As I mentioned a few months back, it is important to pay attention to when Microsoft releases...
2010-09-23
497 reads
Index Black Ops Part 3 – Index Usage
Last week, I mentioned in my TSQL2sDay index summary post, that I’d be writing a few posts on the information...
2010-09-22
1,443 reads
September PASSMN Meeting Tonight
As I’ve mentioned a couple times already our PASSMN meeting tonight will be in a new location. This is a ...
2010-09-21
429 reads
SQL Saturday 50 (#sqlsat50) – A Tale
This past weekend I went to SQL Saturday 50 – this is a day long SQL training event that is put...
2010-09-21
817 reads
Share Your Experiences at #SQLSAT58
Ever thought about sharing your experiences with SQL Server to more than just your immediate peers and colleagues? Up here...
2010-09-20
627 reads
September PASSMN Meeting This Week
Enjoying the fall here in Minnesota? The leafs are changing a bit and temp has been dropping. Has that left...
2010-09-20
502 reads
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