Exam Prep 70-463: SSIS Transactions and Checkpoints
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-03-24 (first published: 2015-03-05)
7,576 reads
Data compression
This post examines the compression of a database named Bankware (BW) at a client site. The database size was about...
2015-03-04
760 reads
Data compression
This post examines the compression of a database named Bankware (BW) at a client site. The database size was 300+ GB. The tests for BW were done on the sk-bankware server...
2015-03-04
46 reads
Data compression
This post examines the compression of a database named Bankware (BW) at a client site. The database size was 300+ GB. The tests for BW were done on the sk-bankware server...
2015-03-04
27 reads
Presenting with Tegile at Lincoln SQL Server Users Group Thursday
This Thursday I will be joining an open discussion with Tegile Systems and the Lincoln SQL Server Users Group on...
2015-03-04
484 reads
Data compression
This post examines the compression of a database named Bankware (BW) at a client site. The database size was 300+...
2015-03-04
305 reads
SQL Code Guard v2.7 and SQL Server 2008R2: bad news and good news
Hi all!
Bad news: SQL Code Guard v2.7 is not working with SSMS from SQL Server 2008R2 (and below).
Good news: I...
2015-03-04
666 reads
Data Size – LEN() vs DATALENGTH() - WaterOx Consulting
Reading Time: 3 minutes No. It isn’t just the way you use your data that...
The post Data Size – LEN() vs...
2015-03-13 (first published: 2015-03-04)
7,127 reads
I want to blog but …
I don’t know how to get started.
Pretty simple. There are a number of free blogging sites out there. Personally I...
2015-03-04
676 reads
Latches, Spinlocks & Lock-Free Data Structures – my SQLRally Nordic session
Whew, this was an intensive session about Latches, Spinlocks & Lock-Free Data Structures at the SQLRally Nordic conference in Copenhagen. I...
2015-03-04
595 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
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
Planning for Change
Comments posted to this topic are about the item Planning for Change
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