Analysis Services Dynamic Security
Imagine you have a requirement to capture the user accounts that log into your cube and based on their username...
2014-09-03
3,058 reads
Analysis Services Dynamic Security
Imagine you have a requirement to capture the user accounts that log into your cube and based on their username...
2014-09-03
792 reads
PASS Summit 2014 Announcements
In case you do not receive the PASS connector, here are some announcements for this year’s summit on Nov 3rd...
2014-09-03
821 reads
Restoring Toggle Results Window as Ctrl+R in SSMS
Recent versions of SQL Server Management Studio have unmapped Control+R as the toggle for the Results window in a typical...
2014-09-03
1,881 reads
4 Things I Wish I Knew Sooner
I was recently called out by Tim Costello on a blog series started by Mike Walsh. http://www.interworks.com/blogs/tcostello/2014/08/27/4-things-i-wish-i-knew-sooner-bi-consultant
The series calls for...
2014-09-02
1,337 reads
SQLSaturday Orlando Marketing Plan-Part 40
Last week we were at 332, this morning at about the same time we’re at 356. Not bad for a...
2014-09-02
554 reads
Upcoming Events
My summer event hiatus is coming to a close, and we’re now back into the conference and event season! I’ve...
2014-09-02
742 reads
Crosstabs over Pivots
I wrote about a basic PIVOT query recently. It’s an interesting way to write a query and turn row data...
2014-09-02
2,067 reads
Two simple commands that can be a big help in performance tuning.
The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are...
2014-09-02
2,612 reads
SQL Server column encryption
We use databases to store a lot of information. This can also include sensitive information we don’t want to give...
2014-09-02
4,368 reads
Blogs
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,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
PT Trinity Karunia Baja Telp : (+62 823-7497-5740)
Pergudangan, Kw. Pergudangan Dan Industri Tunas Bitung, Jalan Kp Crewed Blok E5, Sukadamai, Kec....
BCA KCU BOGOR Telp/Wa 085111887254
Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor, Jawa Barat...
BCA KCU LUBUK LINGGAU Telp/Wa 082371291690
Jl. Yos Sudarso No.155, Taba Jemekeh, Kec. Lubuk Linggau Tim. I, Kota Lubuklinggau, Sumatera...
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