Experts Perspective Webcast: Wait Watchers – Gain Performance Increases Fast
Following in the footsteps of such greats community leaders as Brent Ozar and Kevin Kline I have the opportunity, nay...
2014-08-12
621 reads
Richard Douglas
- Interests: Usual stuff: family, SQL Server, shiny things.
PASS DBA VC Session 25th June
It’s always an honour to be able to speak at an event, but events can be expensive to attend and...
2014-06-24
695 reads
Data loss in clustered index occurs when you run online build index in SQL Server 2012
Scared? Don’t worry, there is a workaround and a hotfix. More on that in a moment.
This morning I checked my...
2014-06-12 (first published: 2014-06-10)
2,753 reads
Spring may be long gone but you still need to clean up MSDB
System databases are often neglected, part of this is due to Microsoft’s message of SQL Server will run and look...
2014-06-12
1,111 reads
Two things you probably shouldn’t say in an interview
If you look online you can find thousands of pages of advice on interviews as well as people asking for...
2014-05-22
904 reads
Monthly Reflections – April 2014
April was quite a busy month and so apart from the last reflections post and TSQL Tuesday entry Why So Serious...
2014-05-09
689 reads
T-SQL Tuesday #53 Why So Serious
This month’s T-SQL Tuesday which is now at a staggering number 53, can it really have been going that long?...
2014-04-08
838 reads
Monthly Reflections – March 2014
After a bit of an enforced sabbatical from blogging (short but boring story), I was interested to see how my...
2014-04-04
681 reads
Grant View Server State
There are lots of Dynamic Management Objects (DMO’s, more commonly referred to generically as DMV’s) that require extra permissions. Without...
2014-04-02 (first published: 2014-03-25)
95,870 reads
Last Day in the UK
The driver behind the move
After over two and a half years at my current employers I am afraid to say...
2014-04-01
625 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 Surya Kencana Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Suryakencana No.260 C & D, RT.01/RW.05, Babakan Ps., Kecamatan Bogor Tengah, Kota...
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,...
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