“DBA: Transitioning to a BI Role” Presentation
Tomorrow (Wednesday, Feb 13th) at Noon CST I will be presenting the session “DBA: Transitioning to a BI Role” at...
2013-02-12
753 reads
James Serra's Blog
Introduction to Microsoft’s Master Data Services (MDS) Presentation
Tomorrow (Tuesday, Feb 12th) at 11:30am CST, I will be presenting the session “Introduction to Microsoft’s Master Data Services (MDS)” at...
2013-02-11
943 reads
24 Hours of PASS: Business Analytics Edition videos online
On January 30, BA and BI experts took to the virtual stage for the 24 Hours of PASS: Business Analytics Edition to...
2013-02-07
769 reads
Installing Team Foundation Server (TFS) 2012
My experience installing Team Foundation Server (TFS) 2012 to house my business intelligence projects built in Visual Studio 2010:
I am installing...
2013-02-05
6,016 reads
SSIS 2012: Empty toolbox?
This is an annoying problem I have had a few times: I open a SQL Server Integration Services (SSIS) project...
2013-01-29
5,064 reads
Missing Data Quality Service (DQS) buttons in Excel
The Master Data Services add-in for Excel has Data Quality Services functionality to help you match data before publishing it...
2013-01-24
1,369 reads
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
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,238 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,697 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,255 reads
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers