Speaker of the Month: November 2014
I have been very remiss in my blogging of late. Apologies.
One thing I haven’t blogged about is Speaker of...
2014-12-05
512 reads
Blog Posts
SSIS Parent-Child Architecture in Catalog Deployment Mode
This is the third in a series of posts about SSIS parent-child architecture. You can find the index page here.
In...
2014-12-05 (first published: 2014-12-01)
7,349 reads
Azure SQL Server Database
SQL Server in Azure
You can create and leverage cloud based SQL Server instances using Microsoft Azure. However, if you have...
2014-12-04 (first published: 2014-12-01)
6,789 reads
Book Review – Query Tuning & Optimization
Via Twitter in October Benjamin Nevarez@BenjaminNevarez solicited help for book reviewers for his new book “Microsoft SQL Server 2014 Query Tuning...
2014-12-04
758 reads
Book Review – Query Tuning & Optimization
Via Twitter in October Benjamin Nevarez @BenjaminNevarez solicited help for book reviewers for his new book “Microsoft SQL Server 2014 Query Tuning & Optimization” I jumped at this opportunity as...
2014-12-04
39 reads
Deciding On a Presentation Topic for 2015
I’m spending some time this week and the next few weeks thinking about what I want to talk about next...
2014-12-04
658 reads
Exam Prep 70-463: Columnstore Indexes and Partitioning
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2014-12-04
1,309 reads
First Blog Post
Well, this is my first blog post…I’ve said I was going to do this for a long time and it’s finally here. Via Twitter a in October Benjamin Nevarez @BenjaminNevarez solicited...
2014-12-04
40 reads
First Blog Post
Well, this is my first blog post…I’ve said I was going to do this for a long time and it’s...
2014-12-04
277 reads
How to Handle Dynamic Rowsets
Sometimes you have a stored procedure that returns a rowset, and you need to insert the rowset into a temporary...
2014-12-04
1,591 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...
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
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