Data cleansing in SSIS, DQS, and MDS
Data cleansing can be done via SSIS as well as Data Quality Services (DQS) and Master Data Services (MDS). The...
2013-05-09
2,673 reads
PowerSQL – SQL Inventory Generation – Email – High Level Details
Inventory allows anyone to quickly and easily assess any environment. For few servers, answering Inventory questions might not be so...
2013-05-09
1,205 reads
Bring Offline File Online — Modify SQL Server Metadata
In my last post, I demonstrated how to mount a database with missing NDF files. In the end, we still have issues removing tables created over missing files, the...
2013-05-09
32 reads
Bring Offline File Online — Modify SQL Server Metadata
In my last post, I demonstrated how to mount a database with missing NDF files. In the end, we still...
2013-05-09
1,561 reads
DTA and Hypothetical Indexes
For those of you that don’t know DTA stands for Database Engine Tuning Adviser and is available from the Tools...
2013-05-15 (first published: 2013-05-09)
11,486 reads
Starting with Git for Database Development
One of the tools that Red Gate Software makes is SQL Source Control. It’s a plug in to SSMS that...
2013-05-08
8,479 reads
2013-05-08
1,364 reads
SQLSaturday #209 – Rochester
Welcome to the Roc!
Just a quick note that I’ll be presenting this weekend, Saturday May 11th, at SQLSaturday in Rochester,...
2013-05-08
796 reads
SQL Saturday #200 - Philadelphia
If you read my post from yesterday you will know I will be spending some time on the US east...
2013-05-08
781 reads
Modify a Power View Data Source
I’m currently setting up a demo environment using SQL Server 2012 and SharePoint 2013 (more on that in later blog...
2013-05-14 (first published: 2013-05-08)
4,428 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Designing for Teams
Comments posted to this topic are about the item Designing for Teams
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers