by windy
15. March 2011 00:38
April 13, 2011 Webcast
The most important part of your SQL Server is also the slowest, storage. These presentations will take you through the fundamentals of your server's I/O system. From how hard drives work, through RAID configurations, and how to configure the file system. We will also cover other technologies such as storage area networks, network attached storage, iSCSI and solid state disks. These sessions should give you a solid foundation over storage systems, help you understand why they are slow and how to overcome some of their limitations.
About The Speaker
Wes Brown is currently serving as Chief Database Architect for eScan Data Systems. Previously, Wes has served at Quest Software as Litespeed product manager and SQL Server domain expert and GoldenGate Software as SQL Server domain expert and professional services consultant. He is also active in the SQL Server community serving on the PASS Summit program committee and is coordinator of the Austin, TX PASS chapter CACTUSS. Wes also founded the San Antonio PASS chapter SALSSA. He posts technical content around SQL Server at SQL Server Input/Output (www.sqlserverio.com).
by windy
9. February 2011 18:38
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!
by windy
18. January 2011 00:56
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!
by windy
9. December 2010 23:37
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!
by windy
19. November 2010 22:55
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!
by windy
19. November 2010 22:49
What are you really gaining from backup compression? In order to calculate the true gain in higher backup compression one must compare the sizes of the compressed backup files to each other and NOT to the original size of the database. Smaller backups enable a site to maintain a greater number of backups online for a longer period or conversely dramatically reduce the amount of backup space required. This whitepaper describes the value of higher backup compression that is realized when using SQL safe with IntelliCompress to perform SQL Server backups.
by windy
3. November 2010 00:58
What are you really gaining from backup compression? In order to calculate the true gain in higher backup compression one must compare the sizes of the compressed backup files to each other and NOT to the original size of the database. Smaller backups enable a site to maintain a greater number of backups online for a longer period or conversely dramatically reduce the amount of backup space required. This whitepaper describes the value of higher backup compression that is realized when using SQL safe with IntelliCompress to perform SQL Server backups.
Read more!
by windy
13. October 2010 01:18
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!
by windy
12. October 2010 09:39
A user hierarchy is more than simply an aid to the user. In combination with the attribute relationships for the attributes defining each level of the hierarchy, the user hierarchy is used for designing aggregations. You can think of aggregations as a collection of summary tables that are managed for you by Analysis Services. The addition of aggregations to a cube is one way to improve performance. You probably won't notice much if your fact table contains thousands of records, but once you cross into the "millions of records" zone, you'll notice a difference in query performance between a cube with aggregations and one without aggregations.
Tip by Stacia Misner, a consultant and author specializing in business intelligence solutions since 1999, providing consulting and training services through Data Inspirations, and writing about BI at blog.datainspirations.com.
by windy
7. October 2010 01:21
The best way to turn off a best practice warning is to implement the design change that the best practice warning is recommending! However, there are cases where the warning is just a recommendation, and not critical to the performance or usage of the cube. In those cases, you have two options--either disable the warning on a case by case basis, or disable the warning forever within the current database.
When you deploy the Analysis Service project, the Error List window will contain all the warnings, even if it the project deploys successfully. If you don't see the Error List window, click Error List on the View menu. In the Error List window, right-click on the warning that you want to ignore, and click Dismiss. You can provide a comment to remind yourself (or anyone else that looks at the project) why you are ignoring the best practice warning. Dismissing best practice warnings in this way operate case by case. You'll continue to get the same warning for another object until you dismiss it.
Rather than dismiss the same best practice warning over and over again across multiple objects, you can disable it globally -- for the current database. There is no effect on other databases that you are managing. To disable the best practice warning, click the Edit Database command on the Database menu, and then click the Warnings tab. On the top half of the window, you'll see the categories of warnings. Expand a category and then clear the checkbox for the particular warning that you want to disable. You can add a comment to remind yourself why you did it. If you dismissed individual warnings using the case by case method as described above, you'll see those in the lower half of the window along with the comments if provided.
Tip by Stacia Misner, a consultant and author specializing in business intelligence solutions since 1999, providing consulting and training services through Data Inspirations, and writing about BI at blog.datainspirations.com.
