DBCC HELP
I was going through some online courses and came across Erin Stellato’s Course on DBCC commands.http://www.sqlskills.com/blogs/paul/new-course-understanding-and-using-dbcc-commands/ I learnt something new!...
2016-09-09
563 reads
Arun Sirpal
CHECKDB is slow!
Running the usual consistency checks on a database (with a new release code applied from an ISV) I noticed slower...
2016-09-01
413 reads
Talking of checkpoint
I was having a conversation with someone over a disgusting vanilla latte and we talked about shutting down a machine...
2016-08-25
197 reads
Do YOU Checksum?
I am going to show you why you should be using checksum options on your backups (and restores). I AM...
2016-08-11
211 reads
2016-08-05
199 reads
Undocumented Commands
There isn’t really a need to do what I am doing in this blog post but I guess one reason...
2016-08-03
211 reads
Migrating SQL Server to Azure
There are many ways to migrate an “earthed” SQL Server database to Azure, for this article I want to show...
2016-08-02
237 reads
Why I like SQL Sentry Plan Explorer
Why I like SQL Sentry Plan Explorer. I am going to be honest here, before attending SQLSKILLS Immersion training I...
2016-07-29
649 reads
Playing with TDE
UPDATE November 2016 – With SQL Server 2016 SP1, Microsoft will include key enterprise-class features in every edition of SQL Server...
2016-07-27
539 reads
SQLskills Training
Well I finally accomplished a goal of mine– that being to complete the training for SQL Server Performance Tuning and...
2016-07-12
198 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