PASS 2011 Pre-Conference Seminars and Spotlight Sessions Released
I have wanted to go to PASS Summit for the last several years, but have yet to get an opportunity...
2011-06-02
683 reads
Do You Ever Physically Defragment Your SQL Server MDF & LDF Files?
Every since the first file was written to a floppy disk drive using DOS, physical file fragmentation has been a...
2011-06-01
2,001 reads
DQ & MDM Book Available to Download
If you’re looking for a resource on the Data Quality and Master Data Management features in SQL Server 2008 R2,...
2011-06-01
1,233 reads
PerformancePoint wish list – change a datasource
One item on my PerformancePoint wish list is the ability to change a datasource for an Analytic Chart/Grid. There is...
2011-06-01
827 reads
PASS Announces Pre-conference and Spotlight Sessions for PASS 2011 Summit
Today, PASS announced the Pre-conference and Spotlight Sessions for the PASS Summit 2011 in Seattle, which will run from October...
2011-06-01
1,112 reads
SQL Saturday Pensacola
I know it has been almost a month since I posted last and this is not really a “real” post,...
2011-06-01
439 reads
Re-Focusing the Blog a Bit
In recent weeks I've strayed pretty much all over the map with respect to topics. I have another blog, the...
2011-06-01
755 reads
June Question: How Do You Monitor Your SQL Servers?
As DBAs, one of our biggest responsibilities is to monitor our SQL Servers to ensure they are performing as expected....
2011-06-01
1,257 reads
SQL Exercise During Candidate Interview Process
A discussion of how BPS uses a SQL exercise for candidates and why it is helpful.
At the Boston Public Schools,...
2011-06-01
2,715 reads
Start All Your Meetings in Pole Position
Let’s face it, a lot of us don’t enjoy attending meetings and can often find them to be a bit...
2011-05-31
1,837 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...
Alamat BCA KCP Ketapang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Blok A/3-4, Ketapang Indah, Jl. KH Zainal Arifin, RT.5/RW.7, Krukut, Kec. Taman Sari,...
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...
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