I recently had the challenge of migrating an installation of Microsoft Team Foundation Server 2010 from a shared SQL Server...
2014-02-27 (first published: 2014-02-24)
2,911 reads
I am honored to be the very first presenter of the new PASS chapter in Lafayette, Louisiana this Tuesday, presenting...
2014-02-23
622 reads
I will be speaking and whiteboarding for Data Architecture Virtual Chapter meeting on February 27, 2014 on the fitting topic...
2014-02-23
479 reads
Wrote this email exchange with some developer colleagues about to embark on performance tuning.
Subject: bag o' tricks from DMV talk
From: A. Developer
Hey...
2014-02-12 (first published: 2014-02-05)
2,091 reads
After the restore of a database, or perhaps a bare-metal restore of a Windows server running SQL Server, unique IDs...
2014-01-30
1,158 reads
If you've already configured your local machine's PowerShell environment to interact with your Azure subscription (see here: http://www.windowsazure.com/en-us/documentation/articles/install-configure-powershell/), then you can...
2014-01-30 (first published: 2014-01-27)
1,750 reads
I often use these scripts to check on the backups of all databases in an unfamiliar SQL Server instance, regardless...
2014-01-22
569 reads
I was recently approached by a client who was running SQL Server 2008 with some databases in SQL 2000 compatibility...
2014-01-15
1,170 reads
I know this might seem like an odd topic on a SQL Server blog, but it's a common and critical...
2014-01-07
1,191 reads
Assuming you're in a case-insensitive ("CI" in the collation name) column, this UPDATE statement:
UPDATE tablefoo
set foo = 'Z'
where foo = 'z'
will just...
2013-12-20 (first published: 2013-12-16)
1,822 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...
WhatsApp:0817819444 Jl. Suryakencana No.260 C & D, RT.01/RW.05, Babakan Ps., Kecamatan Bogor Tengah, Kota...
WhatsApp:0817819444 Blok A/3-4, Ketapang Indah, Jl. KH Zainal Arifin, RT.5/RW.7, Krukut, Kec. Taman Sari,...
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