JSSUG Speaker Idol 2012 Review
Last Wednesday at Jacksonville SQL Server User Group (JSSUG) we held our annual Speaker Idol event. Read more about what...
2012-08-21
1,166 reads
Last Wednesday at Jacksonville SQL Server User Group (JSSUG) we held our annual Speaker Idol event. Read more about what...
2012-08-21
1,166 reads
The Jacksonville SQL Server User Group (JSSUG) has always encouraged new talent to be added to the pool of local...
2012-08-15
1,107 reads
Somehow I missed this gem that’s been around for quite a while so I thought I would share it in...
2012-08-08
2,410 reads
OLAP PivotTable Extensions is a really cool free add-in for Excel that’s been around for quite a while now. It...
2012-07-31
1,916 reads
When SQL Server 2008 R2 was released several new Reporting Services expressions were made available that would help join multiple...
2012-07-27
4,391 reads
With the Office 2013 announcements today I was excited to download and get my hands on the tools. Because this is still...
2012-07-18 (first published: 2012-07-17)
3,308 reads
This has been reposted from a guest blog post I wrote on the Microsoft Business Intelligence team blog.
Fulfilling User Needs
Developing a...
2012-07-16
1,216 reads
Next week I will be speaking on designing your first Power View report for SQL Lunch. Be sure to join me...
2012-07-11
1,141 reads
I’m usually pretty hesitant to share scripts I write because inevitably it will get torn to pieces, but in this...
2012-07-08
4,084 reads
Recently while working for a client that was running SQL Server 2008 R2 I was tasked with loading an Excel...
2012-07-05 (first published: 2012-06-29)
6,294 reads
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item Planning for Change
Comments posted to this topic are about the item Importing Excel files into SQL...
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