Building a Visual Studio project from an existing SSAS database
Imagine you join a company, and there is an existing SSAS database that contains a few cubes that are working nicely. You...
2011-09-19
839 reads
Blog Posts
Column Level Permissions
Did you know that you can grant permissions down to the column level in SQL Server? Well, if you didn’t...
2011-09-19
1,698 reads
Column Level Permissions
Did you know that you can grant permissions down to the column level in SQL Server? Well, if you didn’t know that – you do now. It is...
2011-09-19
50 reads
Database Snapshot as a Reporting Solution – Some Realtime Issues and Answers
One of Our production database is used by lots of Reporting users. Mirroring is enabled on this database. But no one is...
2011-09-19
6,849 reads
Father of SQL Server?
“I love SQL Server. SQL Server has given me good career, salaray and life”
“Be loyal and dedicated with SQL Server....
2011-09-19
2,901 reads
Getting Excited: SQLBits is Coming!
Other than changing planes once at Heathrow Airport, I've never been to England, so I'm getting really excited about traveling...
2011-09-19
899 reads
Have end users who need an introduction to SQL Server book?
At the beginning of this year, my introductory text to SQL Server, appropriately titled Introduction to SQL Server, became available for sale....
2011-09-19
1,342 reads
No Drama
Someone I worked with recently on the server side of the business had that to say about SQL Server compared...
2011-09-19
616 reads
Performance Tuning – Over the Top Biz Logic
This month, Robert Pearl is helping to host a Performance Story contest. The contest is being sponsored by Safe Peak,...
2011-09-19
1,788 reads
Performance Tuning – Over the Top Biz Logic
This month, Robert Pearl is helping to host a Performance Story contest. The contest is being sponsored by Safe Peak, and you can see more about it – here....
2011-09-19
30 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
Alamat Telp BCA KCP Poris Indah (+62) 838-4945-0961
Wa:083849450961 Ruko Poris Indah, Komp, Jl. Poris Indah Blok K No. 2-3, RT.003/RW.003, Cipondoh...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Planning for Change
Comments posted to this topic are about the item Planning for Change
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