SSIS Fuzzy Lookup Error
A Fuzzy Lookup Task in SSIS that I was working on was bombing out, and I had a heck of...
2011-06-13
1,693 reads
Blog Posts
Time for a Little PD
No, PD doesn’t stand for PowerShell Development. It stands for Professional Development. Sharks either swim or die (and yes, I...
2011-06-13
742 reads
What is the best value for Fill Factor in SQL Server?
Introduction
When an index is created or rebuilt, the fill-factor value determines the percentage of space on each leaf-level page to...
2011-06-13
7,500 reads
What’s a Disaster?
In working on my Preparation for Disaster presentation and doing research, one of the questions that came up early for...
2011-06-13
1,499 reads
Database Owner - Error Message
Sometimes, a simple task that as a DBA you do day in and day out,
can throw wierd errors.
You...
2011-06-12
420 reads
Don't touch that Maintenance Plan Job
Good ol Maintenance plans. With 2005 and beyond we received the glorious SSIS backed Maintenance plans. I love SSIS so...
2011-06-12
1,941 reads
SQLcruise review
The most amazing journey that I have done in the past years was definitely SQLcruise
(see http://www.sqlcruise.com) – a SQL Server
event organized...
2011-06-12
585 reads
I am back
I am back again!!!. It has been ages since I posted.An important event in my life kept me away from...
2011-06-11
346 reads
Some Good SQL-Related YouTube Videos
A brief discussion and links to a series of YouTube videos from Stéphane Faroult.
I’ll continue the discussion of the table...
2011-06-11
1,223 reads
Tampa SharePoint Saturday 2011
I presented a 75 minute session at Tampa SharePoint Saturday on PowerShell Basics.
The presentation and demo scripts can be found...
2011-06-11
437 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat BCA KCP Surya Kencana Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Suryakencana No.260 C & D, RT.01/RW.05, Babakan Ps., Kecamatan Bogor Tengah, Kota...
Alamat BCA KCP Ketapang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Blok A/3-4, Ketapang Indah, Jl. KH Zainal Arifin, RT.5/RW.7, Krukut, Kec. Taman Sari,...
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers