SQL PASS Summit 2014 Diary – Days 3-5
The last two days have been an absolute blur. As I first posted this week, I had planned to blog...
2014-11-07
820 reads
Blog Posts
Summit 2014 – Next Impressions
As Summit 2014 begins to wind down, it is time for some more impressions from the week. The week has...
2014-11-07
630 reads
Summit 2014 – Next Impressions
As Summit 2014 begins to wind down, it is time for some more impressions from the week. The week has been good so far. It has been very busy...
2014-11-07
13 reads
Thoughts on the 2014 PASS Summit From A Non-Attendee
I missed the Summit this year, but tried to follow along remotely via Twitter, PASSTV, and the blog posts I...
2014-11-07
950 reads
Versioning In Your SQL Database
Reading Time: 4 minutes
What Is The Point of Versioning?
How do you know change occurs in your database?
Now, I’m not talking...
2014-11-07
654 reads
Another great reason to enable remote admin connections
I recently came cross another great reason to enable the remote admin connections server configuration on SQL server.
If you don’t...
2014-11-06
1,260 reads
Configuring a Complete Memory Dump
Imagine this scenario: One of your servers just crashed, and you open a ticket with Microsoft for them to perform...
2014-11-06
1,991 reads
Drop and Recreate all Synonyms
Had a quick job the other day restoring a pair of databases under different names which is all straight forward...
2014-11-06 (first published: 2014-10-27)
18,895 reads
PASS Summit 2014 Day 2 Keynote Live Blog
We are back in the keynote room with Adam Jorgensen talking to us about the financial state and health of...
2014-11-06
417 reads
PASS Summit 2014: WIT Luncheon
Since I’m starting on the board in January, I’ve stopped taking part in the bloggers table during keynotes. First time...
2014-11-06
630 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