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,669 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,203 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,559 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,478 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,478 reads
2013-05-08
1,362 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
780 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,427 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers