Identifying Blocking via Extended Events
There are a number of ways that you can identify blocking that is occurring in your SQL instance. You can...
2015-03-05 (first published: 2015-02-24)
10,514 reads
Blog Posts
Preparing a Technical Session Part 3: Writing an Abstract
So you’ve come up with a great idea for a session and now you have to translate that idea into...
2015-03-05 (first published: 2015-02-24)
5,538 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
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
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
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
Small presenter tip: changing display mode automatically after presenter view
This morning Adam Machanic (blog | twitter) asked the following question on Twitter:
Anyone know if it's possible to configure PowerPoint 2013...
2015-03-04
693 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