SQL Server 2012 Developers Training Kit
Microsoft has recently released the SQL Server Developer Training kit for SQL Server 2012. The developers kit includes fantastic resources...
2011-10-24
1,804 reads
PASS Update #66 (All Good Things)
Last week I emailed the Board of Directors my resignation effective December 31st of this year, ending my current term...
2011-10-24
647 reads
ALTER SCHEMA
Use this select statement to create a list of ALTER SCHEMA statements for all stored procedures in a SQL Server...
2011-10-24
1,877 reads
SSIS 2012: Project Reference
One of the less advertised enhancements of SSIS in SQL Server 2012 is the Project Reference type available when using...
2011-10-24
3,251 reads
GiveCamp Tampa 2011
This past weekend I participated at GiveCamp Tampa 2011 (http://www.givecamptampabay.org/) as part as the Worldwide GiveCamp (http://www.givecamp.org) weekend sponsored by...
2011-10-24
1,040 reads
Deploying SSIS Packages with BIxPress
Same functionality but obvious differences
If you’ve worked with SSIS for any amount of time, you may quickly come to find...
2011-10-24
1,458 reads
Gaining SQL Server SysAdmin Access
I’ve seen this come a few times at work and I’m sure most you have experienced something similar.
Someone or an...
2011-10-22
4,269 reads
Giving back–Colorado GiveCamp has started (#CoGiveCamp)
The Colorado GiveCamp is underway with 40 volunteers and 5 charities. Gabe Villa ( blog | twitter ), Kevin Krueger ( blog | twitter ), Jason...
2011-10-22
1,071 reads
SSIS – Can’t Enable/Disable within Data Flow Tab
This is my biggest gripe with SSIS: I have a data flow task, and within that I’m pulling data from...
2011-10-21
3,045 reads
Fun Pix
Various photo uploads from the past year.
Filed under: Blog Tagged: Humor, pictures, syndicated
2011-10-21
966 reads
Blogs
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,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Planning for Change
Comments posted to this topic are about the item Planning for Change
Importing Excel files into SQL Server, Azure Edition
Comments posted to this topic are about the item Importing Excel files into SQL...
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