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 the videos here. Enjoy!
Continue reading →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 easy integration with source control. Visual Studio Database Projects have been known by a few different names down the years … Continue reading →
Introduction to Microsoft’s Master Data Services (MDS) Presentation
I will be presenting the session “Introduction to Microsoft’s Master Data Services (MDS)” at the Data Architecture Virtual Chapter on Thursday, Dec 20th, at Noon CST. Below is the abstract. It will be a remote presentation that you can join online. Details … Continue reading →
SQL Server Data Tools (SSDT) – December 2012 update
SQL Server Data Tools (SSDT) has a new update: VS 2010: December version: 10.3.21208.0, November version 10.3.21101.1, September version: 10.3.20905.0, initial version: 10.3.20225.0 VS 2012: December version: 11.1.21208.0, November version: 11.1.21101.1, September version: 11.1.20905.0, version shipped with VS 2012: 11.1.20627, initial version: … Continue reading →
Solution to VSTA editor error in SSIS 2012
The script task in SSIS 2012 is a great tool when you need to use C# or VB code to perform a function that is not possible with the other SSIS built-in tasks. It uses Visual Studio Tools for Applications … Continue reading →
Can I use SSDT for the 2008 BI stack?
SQL Server Data Tools (SSDT) that was released with SQL Server 2012 obviously works with the BI stack (SSIS/SSAS/SSRS) for 2012. But does it also work with the BI stack from SQL Server 2008 R2? Can you use it with … Continue reading →
SQL Server Data Tools (SSDT) – November 2012 update
SQL Server Data Tools (SSDT) has a new update: VS 2010: new version 10.3.21101.1, September version: 10.3.20905.0, initial version: 10.3.20225.0 VS 2012: new version: 11.1.21101.1, September version: 11.1.20905.0, version shipped with VS 2012: 11.1.20627, initial version: 11.1.20225.0 Download it here. Also updated is … Continue reading →
SharePoint dependencies
Microsoft has made a big push the last few years to have all its end-user BI tools integrate with SharePoint, which is great if your company is using SharePoint. Not so great if your company is not using SharePoint or … Continue reading →
Power View for Multidimensional Models – Preview Available
Microsoft introduced an interactive data exploration, visualization and presentation experience called Power View with SQL Server 2012. Power View can only consume data from tabular models. At the PASS Summit (see PASS 2012 Announcements) it was revealed that you would soon be able to … Continue reading →
Reasons not to upgrade to SQL Server 2012
As exciting as SQL Server 2012 is, with its multitude of new features, it’s not always possible to upgrade right away. Here are some reasons that may cause you to delay your upgrade: Training – Your developers and dba’s will … Continue reading →
Billing rates – other side of the fence
The following is a guest post by Tim Morgan from Sullexis in response to a resent blog of mine: Thanks for letting me reply to your last post, “Should a placement firm tell you what they are billing the client?”. This … Continue reading →
Master Data Services Web Services API Error
In Master Data Services (MDS), I received an error when using C# code in the script task in SSIS 2012 to call the MDS web services API: To fix this, I had to edit the web.config in C:\Program Files\Microsoft SQL … Continue reading →
PASS 2012 Announcements
Some announcements and notes from the SQL PASS Summit 2012 last week (If you don’t know what PASS is, check out What is SQL PASS?): PASS Summit 2012 had 3,894 delegates – up 13% from last year’s previous record attendance – and 1,717 pre-conference … Continue reading →
Data Warehouse Architecture Presentation Slides
Thanks to everyone who attended my “Data Warehouse Architecture” presentation to the South Florida PASS chapter. Here is the PowerPoint presentation: Data Warehouse Architecture Data Warehouse Architecture – comparing Kimball and Inmon methodologies You’re a DBA and your boss asks you to … Continue reading →
Dell Quickstart Data Warehouse Appliance 2000
As a follow-up to my blog Dell Quickstart Data Warehouse Appliance for SQL Server 2012, Dell announced the availability of the second appliance in the Quickstart family: the Quickstart Data Warehouse Appliance 2000 (QSDW2000). This is a pre-built appliance for data warehouses … Continue reading →
Data Warehouse Architecture Presentation
I will be presenting the session “Data Warehouse Architecture” to the South Florida PASS chapter on Wednesday, Nov 14th, at 5:30PM CST. Below is the abstract. It will be a remote presentation that you can join online. Details at South … Continue reading →
SSIS: Execute SQL task vs Execute T-SQL Statement task
In SSIS there are two tasks than can be used to execute SQL statements: Execute T-SQL Statement and Execute SQL. What is the difference between the two? The Execute T-SQL Statement task tasks less memory, parse time, and CPU time … Continue reading →
Problem copying large files to a USB flash drive?
I thought I would write a quick blog on a problem I see frequently: You try to copy a large file, such as the iso image of SQL Server, to a USB flash drive, and get the error message “There … Continue reading →
Jumping from SSIS 2008 to SSIS 2012
Being a long-time SSIS 2008 developer, I have been working with SSIS 2012 for the past few months, and I wanted to jot down a quick guide for those of you also making the jump from SSIS 2008 to SSIS … Continue reading →
SQL Server 2012: New Business Intelligence features
SQL Server 2012 has many new Business Intelligence (BI) features and enhancements. Here are my top 12, in order of importance: Power View. A fun, visual, and powerful drag-and-drop ad-hoc reporting tool. It is a web-based end-user BI tool based … Continue reading →