Audit Configuration Changes
Do you know the last time a Server Property was changed on your instances of SQL Server? Are you wondering when the setting for max degree of parallelism was...
2013-01-24
18 reads
Do you know the last time a Server Property was changed on your instances of SQL Server? Are you wondering when the setting for max degree of parallelism was...
2013-01-24
18 reads
Back in November 2012, I shared a story about checking the last known good checkdb in the boot page of...
2013-01-17
1,249 reads
Back in November 2012, I shared a story about checking the last known good checkdb in the boot page of a database. You can read that story here. This...
2013-01-17
17 reads
This is the wrap up for TSQL Tuesday #38. We had a good turnout this month with some new faces...
2013-01-15
1,004 reads
This is the wrap up for TSQL Tuesday #38. We had a good turnout this month with some new faces and with some regulars. In total, we had 22...
2013-01-15
14 reads
I hope you are ready for some free SQL learning. Coming up on Thursday January 10th at 6:30 PM Pacific...
2013-01-09
849 reads
I hope you are ready for some free SQL learning. Coming up on Thursday January 10th at 6:30 PM Pacific (GMT – 8 ) we will have a stellar...
2013-01-09
13 reads
Last week I sent out an invite for the monthly TSQL Tuesday party.
The theme for the party is a take...
2013-01-08
1,159 reads
Last week I sent out an invite for the monthly TSQL Tuesday party. The theme for the party is a take on the words resolve or resolution. I was...
2013-01-08
17 reads
We are barely under way with the New Year and it is shaping up to be a busier year already....
2013-01-08
1,002 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