Easy way to diagnose SQL Server “sp_Who2” TIP #84
Why the SQL Server is running slow ?
What are the processes running currently on SQL SERVER instance ?
Many other like...
2015-02-19
443 reads
Blog Posts
Powershell Quick Parameters for Scripts
I was working on a script recently to manage a particular process and wanted to make it generic by allowing...
2015-02-19
1,199 reads
Source control isnt just a backup
In the second part of this series on getting more agile and bringing our Sql Server development practices up to...
2015-02-19
54 reads
Source control isnt just a backup
In the second part of this series on getting more agile and bringing our Sql Server development practices up to...
2015-02-19
47 reads
Source control isnt just a backup
In the second part of this series on getting more agile and bringing our Sql Server development practices up to date I am going to talk about why you...
2015-02-19
10 reads
Source control isn't just a backup
In the second part of this series on getting more agile and bringing our Sql Server development practices up to...
2015-02-19
452 reads
Speaking at SQLSaturday Pordenone
Next week, on Saturday 28, make sure you don’t miss SQLSaturday Pordenone!
Pordenone is the place where the Italian adventure with SQLSaturday...
2015-02-19
651 reads
SQL Cruise Caribbean 2015 Wrap Up
I just returned home from this year’s SQL Cruise in the Caribbean. WOW!
This trip was our first SQL Cruise, but it...
2015-02-19
811 reads
T-SQL Tuesday #63 – Security
It’s T-SQL Tuesday time again and this month we look at security. Kenneth Fisher has chosen this as his topic...
2015-02-19 (first published: 2015-02-10)
7,005 reads
TSQL Tuesday #63: – DBA Myths: You can’t deny something to a member of db_owner database role
So I’m hosting T-SQL Tuesday this month and decided that since security is something everyone has to deal with it...
2015-02-19 (first published: 2015-02-10)
7,237 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