SQL Server 2014: AlwaysOn
AlwaysOn was introduced in SQL Server 2012, and there are some enhancements in SQL Server 2014:
Now support up to 8 secondary...
2013-08-15
2,153 reads
AlwaysOn was introduced in SQL Server 2012, and there are some enhancements in SQL Server 2014:
Now support up to 8 secondary...
2013-08-15
2,153 reads
I literally get 10-15 calls and emails a week from recruiters asking if I can help them to find a...
2013-08-13
1,113 reads
If your company is planning to build a data warehouse or BI solution (see Why you need Business Intelligence), you need...
2013-08-08
1,533 reads
Thanks to everyone who attended my session “Best Practices to Deliver BI Solutions” for Pragmatic Works. The abstract for my session...
2013-08-07
674 reads
What are the advantages of using SSAS Cubes over a regular data warehouse for reporting? Note I’m not asking why...
2013-08-06
1,690 reads
I will be presenting a brand new session entitled “Best Practices to Deliver BI Solutions” tomorrow, August 6th, at 11am...
2013-08-05
838 reads
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” for 24 hours of PASS, PASS Summit Preview. The abstract...
2013-08-02
752 reads
In PerformancePoint, when using a analytic grid or chart or a scorecard, if you are not able to use the...
2013-08-01
975 reads
In SQL Server 2012, a new feature was added called Columnstore Indexes that resulted in huge query performance improvements. In SQL...
2013-07-30
3,104 reads
I will be presenting the session “Building an Effective Data Warehouse Architecture” this Wednesday, July 31st, at 10pm EST for...
2013-07-29
1,171 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