SSRS Export En Masse
Have you ever found yourself in need of exporting all of the reports from a Report Server? I have found myself in need of extracting all RDLs from a...
2011-08-08
51 reads
Blog Posts
Tools to make creating MDX much easier
For those of you who use MDX, I’m sure you share my opinion that MDX is a lot harder to...
2011-08-08
801 reads
What SQL Server Books Do You Recommend?
Reprinted and amended from my editorial at Database Weekly.
For nearly 11 years now, one of the most common questions people...
2011-08-08
1,064 reads
Chennai SQL Server User Group and me
My one week long search to identify active SQL Server community in Chennai ended last Sunday.
Chennai SQL Server User Group...
2011-08-07
2,029 reads
Delete backup files older than days
For almost all sql backup jobs, we want to have a step to delete old backup files older than a...
2011-08-06
4,580 reads
Audit SQL Logins
Written by David Postlethwaite There are several ways that you can audit who has logged in to your SQL Server. The...
2011-08-05
4,806 reads
Celebrating Mistakes-Part 2
I’ve been thinking about this a lot. It’s easy to say we want to take risks, much harder to set...
2011-08-05
1,011 reads
Come One Come All S3OLV August 2011
Hey Yo!! We are primed and ready for this month down in Las Vegas. We have a return presenter and...
2011-08-05
576 reads
Come One Come All S3OLV August 2011
Hey Yo!! We are primed and ready for this month down in Las Vegas. We have a return presenter and we are looking to get some speed freak on...
2011-08-05
16 reads
I Am Going to Be a Big Brother #sqlpass #firsttimers
Well at the PASS Summit at least. The Summit is trying to make sure that all of our first timers...
2011-08-05
1,138 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