2012-05-14
2,270 reads
Administration
Snapshot Isolation Level in SQL Server - What, Why and How - Part 1
Snapshot isolation levels improve performance but there are some things to take into consideration when using this feature. Arshad Ali discusses what snapshot isolation levels are, their variants, and why and when we should use them.
2012-05-14
4,253 reads
2012-04-20
2,711 reads
2012-04-12
2,195 reads
The Best Database Administrators Automate Everything
Do you understand the value of your time? I mean really understand it. Time is your absolute number one most valuable asset. Once it's gone, that's it, gone forever.
2014-08-22 (first published: 2012-04-06)
18,754 reads
SQL Server Instant File Initialization (PQW)
In this article we’re going to look at instant file initialization. What it is, why it’s cool and how you can use it in your environments.
2012-04-02
5,246 reads
2012-02-24
2,297 reads
View Active Session SQL
This script can be used to view current SQL statements being executed for all or any one SPID.
2014-01-06 (first published: 2012-01-26)
4,341 reads
2012-01-25
2,242 reads
2012-01-23
2,668 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