PASS Business Analytics Conference Presentation
I am fortunate enough to have been selected to give a presentation at the PASS Business Analytics Conference in Chicago...
2013-01-23
1,391 reads
James Serra's Blog
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,239 reads
SSAS: One giant cube or many small ones?
When using SQL Server Analysis Services (SSAS) to build a cube, you may start out with one fact table, but...
2013-01-15
7,698 reads
MDS Error SYSERR207 after SQL Server 2012 SP1 Upgrade
After upgrading to SQL Server 2012 SP1, I ran into a bug in Master Data Services (MDS) that applies only...
2013-01-10
1,256 reads
Master Data Management (MDM) Hub Architecture
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,794 reads
MDS: The Microsoft SQL Server license has expired
When installing Master Data Services (MDS) in SQL Server 2012 or installing SQL Server 2012 sp1 (and possibly a CU),...
2013-01-03
2,548 reads
PASS Summit 2012 session videos online
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,983 reads
Introduction to Microsoft’s Master Data Services (MDS) Presentation Slides
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,176 reads
PASS SQLRally Nordic 2012 videos online
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
892 reads
Managing Schemas And Source Control For Databases
Visual Studio has a project type called “Database Project” that is used to manage a database schema and allows for...
2012-12-18
4,949 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers