Business Intelligence (BI) systems can take a lot of computing horsepower, and most organizations try to deploy as much horsepower as possible when they implement a BI solution. Unfortunately, BI is one of those things that makes its users want more. More reports. More dashboards. More data. And all that “more” means you’ll eventually need … Continue reading Three Ways to Scale Your Existing BI Business Intelligence System
Tag Archives: SQL
What SQL Azure Means for the Reluctant DBA
Fun joke heard at a recent conference: “What color is the sky when you have no clouds? Azure.” Cue big laffs at Microsoft’s expense. The reality, though, is that SQL Azure – the version of SQL Server that lives in Microsoft’s Azure cloud computing service – is a pretty important product. Especially for organizations that … Continue reading What SQL Azure Means for the Reluctant DBA
Working with Validation in SSIS
SSIS validates packages to ensure that they will execute properly. SQL Server Validation occurs both as a package is opened in the BIDS design environment (Design-Time Validation) and just before the package executes (Run-Time Validation). Validation is very useful because it can help find errors in a package, usually with its connections, before it gets … Continue reading Working with Validation in SSIS
Working with Multi-Valued Parameters in SSRS
In one of my SQL courses; 6236: Reporting Services, we learn how to create an “All” option in the values dropdown list of a parameter and see how to “wire up” the All option so that, when selected, the report runs for all values. As an example, imagine a Sales Report that shows sales by … Continue reading Working with Multi-Valued Parameters in SSRS
Video: Cloud Intelligence Conference – May 8, 2012
Interface Technical Training is presenting an opportunity for Arizona businesses and organizations to learn how to put their computing in “the cloud.” The Phoenix Cloud Intelligence Conference May 8, 7:30 a.m. – 6 p.m. As one of a small group of Microsoft Managed Partners, Interface Technical Training was invited to participate in Microsoft’s 15-city Cloud … Continue reading Video: Cloud Intelligence Conference – May 8, 2012
Advanced T-SQL Class at Interface with MVP Itzik Ben-Gan, and you can attend online with Remote Live™
I’ve had a lot of requests for an Advanced T-SQL class over the years. I’m proud to announce that Interface is now offering a 5-day Advanced T-SQL Querying, Programming & Tuning class from world-renowned instructor and MVP Itzik Ben-Gan on October 17, 2011. You can also attend this class online with Remote Live™ if you … Continue reading Advanced T-SQL Class at Interface with MVP Itzik Ben-Gan, and you can attend online with Remote Live™
Downloading all Adventureworks databases by Jeff Jones – Interface Technical Training
You can get to all Adventureworks databases by going to the following link on Codeplex.com. This includes, Adventureworks, AdventureworksDW, Adventureworks2008, AdventureworksDW2008 and AdventureworksLT2008. Make sure you download the correct release of the samples based on the release of SQL Server you are using. Adventureworks Sample Databases – http://msftdbprodsamples.codeplex.com/
Links to SQL Server User Group Community in Phoenix, AZ – by Jeff Jones
Here are a couple of links to the Arizona SQL Server User Group community. The first is the Arizona SQL Server User Group. It usually meets each month except during the summer. The second is a link to SQL Saturday. A group of SQL Server users are attempting to organize a SQL Saturday event. Check … Continue reading Links to SQL Server User Group Community in Phoenix, AZ – by Jeff Jones
Extracting SSIS Package information using T-SQL
SQL Server Integration Services can store it packages in either the file system or the MSDB system database. One of the advantages of storing a package in MSDB is that you can use T-SQL to read the package definition and generate reports on your SSIS package library. Here are a couple of example queries to … Continue reading Extracting SSIS Package information using T-SQL
SQL Server SSRS Reporting Services download Links
Below are links to projects in Codeplex.com where you can download the Adventureworks Sample databases and sample codes for reporting services. I have included a link to download a report to link SQL Agent job names created by Reporting Services to Report Names and some other useful queries against the Report Server databases. Also a … Continue reading SQL Server SSRS Reporting Services download Links