SSWUG.ORG Articles

SQL Server 911 Workshop - July 21 (7/9/2009)

SQL Server 911 Workshop - July 21 Register now to attend Chris Shaw's workshop - all you need to know about SQL Server backup, restore, recovery and options. You can download the workshop outline here at the site. Be sure to get registered right away - we'll even send out certificates...(more)

Webcast Today, SQL Server 911 Workshop Date, More (7/8/2009)

Last day for early bird discount for the July 22-24 refresher virtual conference ... ... is TODAY. [Click here to get registered] Don't Forget the Basics when Troubleshooting So many times in talking with people using SQL Server they realize that the solution to ...(more)

Webcast Tomorrow: How to Hire a DBA Part 1 of 3 (7/7/2009)

Webcast Tomorrow: How to Hire a DBA Part 1 of 3 Are you looking to hire a DBA? This 3 part series will help you in what you should look for. In Part one of this series we will talk about defining the role. Presented by: Chris Shaw > Register Now > 7/8/2009 at 12:00pm Noon Pacific ...(more)

Virtual Conference Registration - Last 2 Days of Early Bird (7/6/2009)

Virtual Conference Registration - Last 2 Days of Early Bird You don't want to spend your time running all over the country to keep skills updated. You also want to stay on top of techniques, best practices and such. On top of all this, if your budgets are like everyone else's, your tr...(more)

Webcast: How to Hire a DBA Part 1 of 3 (7/2/2009)

vConference Early Bird About to Expire Shhh... don't tell my boss. The Early Bird rates to save on registration for the vConference on July 22 is still in effect. It'll be going away early next week - so register right away to save! We'll be featuring the most amazing content on...(more)

Webcast: Tools for SQL Server Backup Heroes (6/10/2009 @ 11:00)

Recent trends in the database industry have lead to a number of challenges for managing SQL Server. Most databases grow in size over time. Regulatory requirements mandate maintaining certain amounts of data online. Users also want to see more of their data. And the number of users for database applications grows over time as users discover where relevant data is located. To address these challenges, DBAs and other IT professionals must look to new technology to continue to perform their jobs effectively and in the same amount of time. In this session, we�ll explore the challenges of increased storage and consolidation, log shipping, clustering and other solutions to help the true heroes of SQL Server meet the test. Presented by: AppAssure (www.appassure.com)

Webcast: SQL Server Reports and OLAP cubes in SharePoint (7/1/2009 @ 12:00)

Quickly see how easy it is to use SSRS web part to display SSRS reports on SharePoint pages. Quickly see how to display an OLAP cube KPI on SharePoint page by using the included web part. Presented by: Lynn Langit

Webcast: How to Hire a DBA Part 1 of 3 (7/8/2009 @ 12:00)

Are you looking to hire a DBA? This 3 part series will help you in what you should look for. In Part one of this series we will talk about defining the role. Presented by: Chris Shaw

Webcast: How to Hire a DBA Part 2 of 3 (7/15/2009 @ 12:00)

Are you looking to hire a DBA? This 3 part series will help you in what you should look for. In Part two of this series we will talk about reviewing a resume. Presented by: Chris Shaw

Webcast: How to Hire a DBA Part 3 of 3 (7/29/2009 @ 12:00)

Are you looking to hire a DBA? This 3 part series will help you in what you should look for. In Part three of this series we will talk about the interview. We will finish up with making a decision on who to hire. Presented by: Chris Shaw

Webcast: DTS Conversion to SSIS � Conversion Best Practices (8/5/2009 @ 12:00)

Join this webcast and Learn how and why to convert DTS to SSIS. See how you can save time and money and easily migrate your DTS packages to SSIS � Introduction to SSIS and its differences vs. DTS � Advantages of SSIS over DTS � Options for converting DTS packages to native SSIS � Adding value to packages during the conversion process � Assessing the scope of a DTS conversion project Presented by: Brian Knight of Pragmatic Works (www.pragmaticworks.com)

Creating Stored Procedures in MySQL Using HeidiSQL 4�s Stored Routine Editor

(Rob Gravelle) In the �Write MySQL Queries Using HeidiSQL 4� article, we learned how to connect to a MySQL database and execute queries against it using the free HeidiSQL GUI client. The latest version adds many enhancements and new features, one of which is an editor for creating stored procedures and functions. Today, we�ll learn how to create a stored procedure using HeidiSQL�s Stored Procedure Editor.