SQL Server 2012 SP1 Causes MsiInstaller Application Log Entries
After installing SP1 to SQL Server 2012 (11.0.3000) on one of our servers, I noticed higher than normal CPU loads due to...
2013-01-17
1,245 reads
After installing SP1 to SQL Server 2012 (11.0.3000) on one of our servers, I noticed higher than normal CPU loads due to...
2013-01-17
1,245 reads
When using SQL Server Analysis Services (SSAS) to build a cube, you may start out with one fact table, but...
2013-01-15
7,725 reads
After upgrading to SQL Server 2012 SP1, I ran into a bug in Master Data Services (MDS) that applies only...
2013-01-10
1,274 reads
The Master Data Management (MDM) hub is a database with the software to manage the master data that is stored in...
2013-01-08
8,856 reads
When installing Master Data Services (MDS) in SQL Server 2012 or installing SQL Server 2012 sp1 (and possibly a CU),...
2013-01-03
2,566 reads
If you are interested in viewing the recorded sessions for the PASS Summit 2012, you can order them on a USB flash...
2012-12-27
1,994 reads
Thanks to everyone who attended my “Introduction to Microsoft’s Master Data Services (MDS)” for the Data Architecture Virtual Chapter. The recording...
2012-12-21
1,184 reads
All the videos for the sessions at PASS SQLRally Nordic 2012 are available for free. Lot’s of great BI info. Check...
2012-12-20
901 reads
Visual Studio has a project type called “Database Project” that is used to manage a database schema and allows for...
2012-12-18
4,972 reads
I will be presenting the session “Introduction to Microsoft’s Master Data Services (MDS)” at the Data Architecture Virtual Chapter on Thursday, Dec...
2012-12-17
790 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....
Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor, Jawa Barat...
Jl. Yos Sudarso No.155, Taba Jemekeh, Kec. Lubuk Linggau Tim. I, Kota Lubuklinggau, Sumatera...
Wa:083849450961 Jl. Sulawesi No.34, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan 90174
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