Pliant Technology, Enterprise Flash Drives For Your SQL Server: Part 1
Pliant Technology, New Kid On The Block
If you have been reading my storage series, and in particular my section on...
2011-05-23
3,213 reads
Blog Posts
Show correct totals when using SSAS role security
When using role security in SSAS, one point of confusion is when a person sees the grand total for a...
2011-05-23
881 reads
SQL Azure Query Tuning
SQL Azure is still SQL Server at the end of the day. This means it is entirely possible to write...
2011-05-23
1,396 reads
SQL University Troubleshooting Week Syllabus
Welcome to SQL University Troubleshooting Week. For anyone unfamiliar with SQL University, it is a project created by Jorge Segarra...
2011-05-23
731 reads
SQL University Troubleshooting Week: Syllabus
Welcome to SQL University Troubleshooting Week. For anyone unfamiliar with SQL University, it is a project created by Jorge Segarra...
2011-05-23
896 reads
SQL Joins and Subqueries
A discussion about SQL joins and subqueries with information about how to format join statements properly.
In any non-trivial task, developers...
2011-05-22
1,127 reads
Find your Enabled SQL Server Network Protocols Using PowerShell
Another quick check I like to do when in 'discovery mode' on a client system is to see what network...
2011-05-21
2,169 reads
Forum Fun: Running Calculation SQL
A discussion about a forum post for handling a running subtraction in a SQL query.
For my first forum fun post,...
2011-05-21
682 reads
SQL Rally 2011 Recap
As I write this, I’m somewhere in the air over Florida, headed back home to Dallas from participating in the...
2011-05-21
1,122 reads
Busy is as Busy Does
I am, as they say, one busy little bee.
I just got back from SQLRally last week (here are my SQLRally...
2011-05-20
566 reads
Blogs
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
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