Presenting “Tangled Code” at Charleston UG Tuesday 9/20
On Tuesday, September 20 at 5p CST (6pm Charleston time), I will present “Unraveling Tangled Code” via LiveMeeting at the...
2011-09-19
609 reads
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
SQL University: Architecture for Small Businesses
Welcome back to SQL University! This week we’re going to be discussing architecture. In previous weeks we’ve discussed architecture at...
2011-09-19
839 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
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
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
Presenting Banish RBAR! to Hampton Roads UG
On Wednesday, Sept 21, 2011 at 6:30pm EST, I’ll be presenting Banish RBAR! to the Hampton Roads SQL Server User...
2011-09-19
646 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
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
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
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
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
Importing Excel files into SQL Server, Azure Edition
Comments posted to this topic are about the item Importing Excel files into SQL...
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