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)

Analyzing data to best customers using Crystal Reports

(John Charles Olamendy) In the sales analysis, there is a principle named the Pareto principle also known as the 80-20 rule. The 80-20 rule states that 80% of the effects come from the 20% of the causes and then the remaining 20% effects come from 80% of the causes. Pareto observed that 80% of the land in Italy was owned by 20% of the population. One example in the IT world is that Microsoft has noted that 20% of the most reported bugs are the causes of the 80% of the errors or crashes of the systems. After Pareto observed this principle, a lot of application appeared. One of the most common applications of the Pareto principle is in the sales analysis. Companies perform analysis in their sales orders in order to discover the best customers, that is, the 80% of the sales come from the 20% of the customers.

Introducing the Entity Framework

(Mark Strawmyer) Welcome to this installment of the .NET Nuts & Bolts column. A few the recent .NET Nuts & Bolts columns have been about LINQ. Articles such as an Introduction to Language Integrated Query (LINQ), LINQ to XML, and LINQ to SQL have explained what LINQ is and how to use it with XML and SQL. This article introduces yet another flavor�LINQ to Entities, which is a part of the Entity Framework.

ASP.NET DropDownList with Custom Paging

(Malcolm Sheridan) Let me start this article off by saying this is something I thought would be interesting to try as an exercise, but it might not fit into a real world scenario. All I wanted to achieve with this is if you can think of something cool to do in ASP.NET, try it! I was thinking about websites that have drop down lists that contain hundreds of items. I thought it would be nice to be able to page through the DropDownList items like you can do with a GridView. Well I came up with a solution!

Integrating Master Pages and Content Pages

(Peter Vogel) In an earlier column ("Integrating Master Pages + Content Pages + a Little AJAX") I showed one way to display in a MasterPage information from the Content page it was displaying. The problem is relatively common: There is some information that you want to display in the same place on every page (and, as a result, you want to put it on the MasterPage) but the information you want to display is being provided by the Content page.