SQL Rally: Performance Tuning Abstract
I get the call, you get the call, everyone gets the call. “Hey, my app/procedure/query/report is running slow.” Now what...
2010-10-28
718 reads
I get the call, you get the call, everyone gets the call. “Hey, my app/procedure/query/report is running slow.” Now what...
2010-10-28
718 reads
Are you looking for opportunities to show off your elite writing skills and consumate SQL Server knowledge? Want a chance...
2010-10-28
634 reads
The SQLRally, a new PASS initiative taking place in the spring, is going to be a community driven event. This...
2010-10-28
1,512 reads
I’ll be presenting a practice run at one of my PASS Summit presentations, Identifying Common Performance Problems using Execution Plans,...
2010-10-27
672 reads
Benjamin Nevarez (blog) has been working really hard on a book on the Query Optimizer. It just got finished in...
2010-10-26
604 reads
The SQLRally, a new PASS initiative taking place in the spring, is going to be a community driven event. This...
2010-10-26
1,077 reads
I can’t believe I missed this one in all the posts and recommendations I’ve been making about great sessions coming...
2010-10-25
454 reads
I received word over the weekend that my precon application had made it past committee and was now subject to...
2010-10-25
615 reads
Less than two weeks to go until the PASS Summit. I’m excited. I’ve managed to cram a ton of activities...
2010-10-25
682 reads
This book shows how to use of mixture of home-grown scripts, native SQL Server tools,
and tools from the Red Gate SQL Toolbelt, to successfully develop database applications in a team environment,
and make database development as similar as possible to "normal" development.
2010-10-21
4,862 reads
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Comments posted to this topic are about the item Pay for Performance, which is...
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
Comments posted to this topic are about the item 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