SQL Server Migration Assistant v5.0
I bloog about mysql to sql server migration lastly here Today found very good migration tool Free Downloads: 1. SSMA...
2011-05-25
683 reads
The Ties that Bind Us....Community, People, Exceptional DBAs...
Hi, All. Just some thoughts on a passing scene. Didn't expect to blog today. Many projects in the queue, but...
2011-05-25
1,317 reads
Monitor your SQL Server Agent Proxies Using PowerShell
Over time it's easy to lose track of the things you set up to get work done. As a consultant,...
2011-05-25
1,267 reads
Efficiency of Subqueries and OR conditions in SQL
A discussion of how joins significantly outperform subqueries and how this is more evident when OR conditions are involved.
SQL queries...
2011-05-25
971 reads
My advanced SQL Server Performance Troubleshooting workshop goes to the international level!
I’m working my whole professional work life (around 11 years) with SQL Server, and
have see so many pitfalls in configuration...
2011-05-24
1,634 reads
Fun with Light Bulbs
I needed an image of a “great idea”, and decided to use a light bulb. I started looking through Flickr...
2011-05-24
931 reads
Pray For Me…I’m Writing the Bible!
Prayer Cat Prays
Well not THE Bible, but rather the SQL Server Bible! I’m incredibly excited and proud to say I’ll...
2011-05-24
572 reads
SQL University Troubleshooting Week: Communication
It should come as no surprise that the first topic I am covering this week is communication because the first...
2011-05-24
1,455 reads
Data Mining in Excel Presentation
Wednesday I will be presenting for the PASS BI/DW group a session on Data Mining in Excel. This is a...
2011-05-24
1,202 reads
EVENT: NYC SQL Server User Group Presents SSRS with Edwin Sarmiento.
Another great event coming to NYC this Thursday, May 26, 2011 @ 6PM! The NYC SQL Server User Group presents a...
2011-05-24
1,255 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