April 13, 2011 Webcast

As databases grow larger in both size and usage scaling out becomes a natural design evolution to improve performance and availability. This presentation will make the case for using transactional replication as one good way to do this. We'll look at how transactional replication is both a high performance and high availability technology, explain the fundamentals of how transactional replication works, demonstrate different ways that it can deployed, and then walk through how to set up a simple publication and subscription.

About the Speaker:
Kendal began working with SQL Server 7.0 as a VB developer 10 years ago. He has spent the last 8 years as a production DBA working on systems that process hundreds of millions of transactions per day. He is currently Senior DBA at Channel Intelligence in Celebration, FL where he is responsible for the management, monitoring, and performance of 40+ SQL Servers.

Kendal stays active in the SQL Community by speaking at events such as SQL Saturday, .NET Code Camp, and the PASS Summit. He is the president of MagicPASS, Orlando's newest PASS chapter. Kendal is known as @SQLDBA on Twitter and maintains a blog on topics related to PASS, SQL Server, and being a DBA at http://www.kendalvandyke.com.

Watch now!

In today's environment many developers are extolling the merits of ORM tools like NHibernate, Linq to SQL, and Entity Framework.  Jack will share the reasons why he still believes that stored procedures are the best way to access data in SQL Server.  When the session is over you will be able to discuss the issues with developers and have resources to show why you think stored procedures can improve application performance, data security, and code maintenance.

About the Speaker:

Jack Corbett is currently the a DBA and developer for New Tribes Mission in Sanford, FL.  Jack has worked been working with SQL Server since late 1999 and has worked with versions from 6.5 to 2005 in production and 2008 in development.  Jack has also worked with .NET technologies since version 1.1.  Jack is a frequent speaker at SQLSaturday's and user groups, mainly in Florida.  Jack is a frequent contributor to the SQLServerCentral forums, written several articles for SQLServerCentral, and has done a series of videos on SQL Server Profiler for SQLShare.com. 

Jack is very involved in the SQL Server community as president of the Orlando SQL Server User Group (OPASS), co-organizer of the last 2 SQLSaturday's in Orlando, and a member of the local planning team for PASS SQLRally (www.sqlrally.com) which will be held in Orlando, May 11-13, 2011.

Jack recently completed his MCITP: SQL Server 2008 Database Administration.  When he is not working with SQL Server & .NET, Jack enjoys hanging out with his family and playing and watching sports.

Watch now!

This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes. Whether you're a DBA or trying to get by without one, this session will give you the information you need to know.

About the Speaker
Andy Warren is a SQL trainer consultant and trainer in Orlando, FL. He runs the free SQLShare.com training site, is currently a SQL Server MVP, blogs daily at SQLAndy.com, started the SQLSaturday franchise, is the past-President of the Orlando SQL Server Users Group, serves as a member of the Board of Directors of PASS, and was a founding partner in SQLServerCentral.com.

Watch now!

Numerous SQL Server experts have done a great job of debunking many of the common myths that crop up around SQL Server best practices and usage. However in some cases, the debunking of those myths creates unintended consequences – we ignore the underlying truth which started the myth in the first place.

Join independent SQL Server expert Michael K. Campbell for a survey of misperceptions that have arisen from commonly debunked SQL Server myths. By attending this free webcast you'll learn how shrinking and using multiple files can be a best practice, what AWE and locking files in memory really means, along with other best practices that you may be missing out on because of misconceptions.

About the Speaker
Michael K. Campbell is a contributing editor for SQL Server Magazine, a regular columnist on DevProConnections.com, and an ASPInsider. Michael is the president of OverAchiever Productions, a consultancy dedicated to technical evangelism, mentoring, and quality solutions. He specializes in SQL Server, ASP.NET, and related technologies. Michael has been a professional developer, web-master, and production DBA for several well-known companies. He enjoys learning, problem solving, teaching, and creating videos for his site www.sqlservervideos.com.

Watch now!

Whether your data source is an operations database, a data mart, or an Analysis Services cube, you can use Reporting Services to deliver information on demand or on a scheduled basis in a variety of formats. With Reporting Services in place, report developers can quickly produce static or interactive reports, system administrators can effectively manage security and performance, and decision makers can easily find, use, and share information.  If you're never used Reporting Services, join us for this webcast to learn about the report controls available to satisfy a variety of reporting requirements, the reporting features that create an interactive user experience, and the steps to publish, secure, and manage content on the report server.

Stacia Misner is a consultant, educator, mentor, and author specializing in business intelligence solutions since 1999 with more than 25 years of experience in information technology. She is the author and co-author of eight books about business intelligence, with Microsoft SQL Server 2008 Reporting Services Step by Step and Introducing SQL Server 2008 R2 as her most recent books. Stacia is a regular speaker at Microsoft SQL Pass and has taught all aspects of Microsoft BI around the world, enlivening the course materials with insights, tips, best practices, and plenty of interaction to help students connect theory to actual practice. Stacia provides consulting and custom education services through Data Inspirations , a SQL Skills BI Partner,  writes about her experiences with BI at blog.datainspirations.com, and tweets as @StaciaMisner.

Watch now!

A relational data mart is a great way to improve query performance for business analysis, but having that data available in an Analysis Services cube can provide an even better experience. A cube can not only deliver queries faster, but can simplify the queries needed to compare one time period to another or to work with cumulative values, like month-to-date and quarter-to-date. Join us for this webcast to learn how a cube can deliver high-performance queries, how to build a basic cube, and how to share the cube with your user community.

Stacia Misner is a consultant, educator, mentor, and author specializing in business intelligence solutions since 1999 with more than 25 years of experience in information technology. She is the author and co-author of eight books about business intelligence, with Microsoft SQL Server 2008 Reporting Services Step by Step and Introducing SQL Server 2008 R2 as her most recent books. Stacia is a regular speaker at Microsoft SQL Pass and has taught all aspects of Microsoft BI around the world, enlivening the course materials with insights, tips, best practices, and plenty of interaction to help students connect theory to actual practice. Stacia provides consulting and custom education services through Data Inspirations , a SQL Skills BI Partner,  writes about her experiences with BI at blog.datainspirations.com, and tweets as @StaciaMisner.

Watch now!

Understanding current trends in business conditions often requires asking a lot of questions, but allowing users to run query after query against your operations databases causes more problems  than it solves. By creating a data mart, you can maintain a separate data store that can withstand the heavy query load that business analysis demands. In this webcast, you'll learn why you need a dimensional data model for your data mart, how to quickly build a dimensional model, and how to use control flow and data flow components in Integration Services to build simple packages that populate the dimensional model with data.

Stacia Misner is a consultant, educator, mentor, and author specializing in business intelligence solutions since 1999 with more than 25 years of experience in information technology. She is the author and co-author of eight books about business intelligence, with Microsoft SQL Server 2008 Reporting Services Step by Step and Introducing SQL Server 2008 R2 as her most recent books. Stacia has taught all aspects of Microsoft BI around the world, enlivening the course materials with insights, tips, best practices, and plenty of interaction to help students connect theory to actual practice. Stacia provides consulting and custom education services through Data Inspirations, writes about her experiences with BI at blog.datainspirations.com, and tweets as @StaciaMisner.

Register now!

High availability solutions are the pro-active counterpart to a solid disaster recovery plan and are increasingly becoming more and more commonly deployed. If you’ve already deployed an HA solution or are planning on it, join independent SQL Server expert Michael K. Campbell for a free webcast that provides an overview of the top mistakes and problems organizations are prone to make when deploying HA solutions.

Speaker: Michael K. Campbell is an independent SQL Server consultant and contributing editor to SQL Server Magazine. As a former DBA and Database developer for several well-known companies, he has over 11 years of experience of working with SQL Server and has written articles and given presentations on a wide variety of SQL Server Best Practices. He enjoys teaching and sharing insights about SQL Server and has made over four hours of free SQL Server Video tutorials available at www.sqlservervideos.com.

Watch now!

Microsoft has long billed the ability to extend SQL Server with the .NET Framework’s Common Language Runtime (or CLR) as a panacea to a myriad of woes. Join independent SQL Server expert Michael K. Campbell for a free webcast that will look at the hype, mystery, and confusion out of when and how to extend SQL Server with the CLR. By attending this webcast you’ll learn about potential CLR pitfalls, review best practices, and see first-hand how easy it is to extend SQL Server with CLR functionality.

About the Speaker
Michael K. Campbell is an independent SQL Server consultant and contributing editor to SQL Server Magazine. As a former DBA and Database developer for several well-known companies, he has over 11 years of experience of working with SQL Server and has written articles and given presentations on a wide variety of SQL Server Best Practices. He enjoys teaching and sharing insights about SQL Server and has made over four hours of free SQL Server Video tutorials available at www.sqlservervideos.com.

Watch now!