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 … Continue Reading
Using parameters with multiple values in SQL Server Reporting Services
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 … Continue Reading
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 … Continue Reading
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 … Continue Reading
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 … Continue Reading
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. … Continue Reading
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 … Continue Reading
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 … Continue Reading
LINQ and Lambdas and Sprocs….Oh My! – by Dan Wahlin
There's a lot of great stuff in .NET 3.5 and several different ways to work with LINQ technologies such as LINQ to SQL. I'm currently putting together some demonstration code for a talk I'll be giving at DevConnections in Orlando … Continue Reading
FN_Split() Table Valued Function by SQL Instructor Jeff Jones
Fn_Split() The link above is to a file with a table-valued function called fn_split(). This function allows you to pass a string of values to an IN clause of a SQL query. It breaks them down into a set of rows … Continue Reading
Moving DTS packages to a SQL Server 2005 Server by Jeff Jones
I have a bunch of DTS packages sitting in the MSDB database on my SQL Server 2000 system. I want to move the packages to my SQL Server 2005 server to continue executing them while I begin the migration. It … Continue Reading
Using SQL Server 2005 CLR Features to Create Aggregates
I played around with SQL Server 2005 a bit this past week to explore (more in-depth) some of the different CLR features that are available. I'll be posting a few of the things I've experimented with over the next few days. One … Continue Reading
SQL Server 2005 Displaying Object Owners
I got a question in class to as to how to figure out the owner of a stored procedure or a view. After looking at the sys.all_objects system view, saw that the principal_id column had a NULL in each row. … Continue Reading
