| Description | Speaker | Register |
|
Introduction to SQL Server Statistics 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. | Andy Warren | View on Demand |
|
SQL Server Myths Debunked…Or Are They? 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.
| Michael K. Campbell | View on Demand |
|
Delivering Information with Reporting Services 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 | View on Demand |
|
Accelerating Answers with Analysis Services 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 | View on Demand |
|
Building a Data Mart with Integration Services 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 | View on Demand |
|
5 Common High-Availability Mistakes 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.
| Michael K. Campbell | Register Now |
|
Introduction to SQL Server CLR Extensibility 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. | Michael K. Campbell | View on Demand |
|
Common SQL Server Security Mistakes
Join independent SQL Server expert Michael K. Campbell for a webcast that contrasts core SQL Server Security concepts against common security mistakes found in the wild. By attending this webcast you will:
• Review core security concepts such as the difference between auditing and security and address advanced topics like misconceptions about how to prevent SQL Injection.
• Learn about the perils of not adhering to the principles of least privilege and will learn tips, tricks, and tactics to help make the transition to least privilege much easier in your own environment.
• Learn about security concerns for data at rest and review ways to prevent wholesale circumvention of SQL Server security constraints for your data.
| Michael K. Campbell | View on Demand |
|
Top 10 Most Useful SQL Server DMVs With the release of SQL Server 2005 and SQL Server 2008, Microsoft exposed new valuable data elements that can be used for managing your SQL Server. These new data elements can be accessed via Dynamic Management Views (DMVs) and Dynamic Management Functions (DMFs). In this webcast we will look at some of the most commonly used DMVs and DMFs and how they can be best put to use in your SQL Server environment.
Speaker: Greg Robidoux is the President and founder of Edgewood Solutions, a technology services company delivering services and solutions for Microsoft SQL Server. He has been working with SQL Server for the past 11 years and has authored numerous articles and delivered several presentations online and at local and national SQL Server events.
| Greg Robidoux | View on Demand |
|
Exploring SQL Server 2008 R2 Reporting Services Designed for both SQL Server developers and DBAs, this webcast will explore the rich reporting features introduced in SQL Server 2008 and 2008 R2, including Report Builder 3.0, enhanced visualization using spark lines, indicators, data bars and map integration. We will also explore Report Part Gallery, and show how users now have the ability to share, store, process and cache data sets outside the reports. Join us in this webcast, and learn how to get the most from your reports using SQL Server 2008 R2!
Presenter Donabel Santos, DBA/Developer/Trainer at Black Ninja Software and Instructor at the British Columbia Institute of Technology for more than 8 years, will provide tips, tricks and solutions to common administrative challenges faced by SQL Server developers and discuss ways DBAs and developers can work together to increase efficiency and avoid those terrible ‘oops’ moments.
| Donabel Santos | View on Demand |
|
The SQL Developer's Guide to Solving Database Administration Headaches Many SQL Server developers are finding themselves having to deal with an increasing number of administrative tasks traditionally assigned to DBAs. In this session of Secrets of SQL Server, SQL Server developers will learn how to recognize and address common administrative issues to ensure successful implementation of their development projects. Tune into this live webcast to learn SQL Server secrets from the pros. Presenter Donabel Santos, DBA/Developer/Trainer at Black Ninja Software and Instructor at the British Columbia Institute of Technology for more than 8 years, will provide tips, tricks and solutions to common administrative challenges faced by SQL Server developers and discuss ways DBAs and developers can work together to increase efficiency and avoid those terrible ‘oops’ moments. | Donabel Santos | View on Demand |
|
Top 10 SQL Server Backup Mistakes and How to Avoid Them
You already know that backing up your SQL Server databases is essential to minimize data loss in the event of a failure. However, putting the wrong strategy in place could be just as harmful as having no plan in place at all.
Sign up now for our webcast to discover how to avoid common mistakes when creating and implementing a backup solution. Don't miss this opportunity to get the know-how you need to ensure that your SQL Server environment is protected. | Greg Robidoux | View on Demand |
|
Getting Started with SQL Server Replication
While SQL Server replication has been around for quite some time, you may be one of those who are reluctant to leverage this built-in capability—even though replication is generally considered both robust and stable.
In this webcast, you will get the basic knowledge required to understand the various types of replication and step-by-step advice on how to get started. We will review commands – from both a GUI and T-SQL perspective. Don’t miss this chance to take the next step toward tackling your first replication implementation.
| Greg Robidoux | View on Demand |
|
Access Data from your Backups Instantly without Having to Restore
In this webcast we take an indepth look at Idera's brand new product SQL virtual database.
This is a revolutionary approach to accessing data in your backup files without having to do a restore. You can use any native SQL Server or SQL safe backup file and instantly access all of the data and objects within the backup. In addition to being able to read the data you can also update the database just like any other SQL Server database.
We will go over how to attach database backups and go through various scenarios for recovering your data.
Don't miss this exciting new approach to instant data recovery.
It’ll change the way you do your job.
| Greg Robidoux | Register Now |
|
SQL Server Data Recovery
In this webcast we will discuss data recovery. We will look at how to restore user and system databases, restore objects and also talk about ways to prevent loss of data in your databases. In addition, we talk about database corruption and ways to identify and fix corruption. This webcast is the second part of our backup and recovery series. | Greg Robidoux | Register Now |
|
Everything you wanted to know about SQL Server backups and more
In this webcast we will go over the different options for backing up your databases. Look at the commands, what’s new with SQL 2008 and some of the underlying components. We will also look at the restore process and talk about how backups impact log shipping, database mirroring, and replication.
Presenter: Greg Robidoux is the President and founder of Edgewood Solutions, a technology services company delivering services and solutions for Microsoft SQL Server. He has been working with SQL Server for the past 11 years and has authored numerous articles and delivered several presentations online and at local and national SQL Server events.
| Greg Robidoux | Register Now |
|
Options for SQL Server Scalability and Availability
Database mirroring, transaction log shipping, replication, clustering, SQL Services for Azure, federated databases, indexed partitioned views... bewildered by the seemingly overlapping options SQL Server offers for improving scalability and availability?
Let Don Jones, author of Definitive Guide to Scaling Out SQL Server, clarify things for you. We'll explore all of SQL Server's various options, see how each one works, and learn when each one is appropriate. You'll even learn when it might be time to give up and switch to Windows Azure, Microsoft's cloud computing platform, to meet your business goals - using SQL Services for Azure, of course! | Don Jones | Register Now |
|
Understanding SQL Server Security Options
Security should always be at the forefront of your database development and deployment or your databases. In this webcast we will take a look at the different security options that SQL Server has to offer and how you can take advantage of these security features. Tune into this live webcast to learn about SQL Server security. Presenter Greg Robidoux, President and Founder of Edgewood Solutions, will show you all you need to know about SQL Server security to make sure your database servers are secure.
| Greg Robidoux | Register Now |
|
Under The Hood with SQL Server Fundamentals
The best way to be an effective SQL Server administrator - even if that's not your full-time job - is to understand exactly how SQL Server moves data around inside its head. Don Jones, self-described "Jack of All Tech" and author of the "Reluctant DBA" series at ConcentratedTech.com, proves that SQL Server isn't as complicated as you might think under the hood. Understanding a few simple principles can make disaster recovery, index tuning, performance optimization, replication, and much more all easier to understand, implement, and maintain - so join us for Don's easy-to-understand explanations and insights.
| Don Jones | Register Now |
|
Using Automation to Simplify SQL Server Management
One of the biggest challenges SQL Server DBA’s face each day is trying to find the time to complete routine, repetitive administrative tasks quickly so more time can be focused on high priority items. In this webcast, you’ll learn how automating routine SQL Server tasks and events can significantly reduce the amount of time you spend on routine tasks and dramatically increase your overall productivity.
Tune into this live webcast to learn about SQL Server automation from the pros. Get expert advice on how to efficiently manage and administer your SQL Server environment. Presenter Greg Robidoux, President and Founder of Edgewood Solutions, will show you all you need to know about SQL Server automation to make your life easier and more productive. | Greg Robidoux | Register Now |
|
Database Mirroring Concepts Since its introduction in SQL Server 2005, database mirroring has become a popular high availability method to ensure fault tolerance and to prevent server outages and data loss. In this webcast, we will discuss: - Several database mirroring concepts and why they are important to you - How to setup mirroring using the GUI and T-SQL Key administrative functions such as alerting and managing mirroring - When to choose mirroring versus other high availability and fault tolerance alternatives. You'll also get a first look at Idera's brand new SQL diagnostic manager v6.0. Come check out one of the new cool features in SQL diagnostic manager which enabels you to monitor mirrored databases and notifies you of performance issues or when there's a change in mirrored database roles. | Greg Robidoux | Register Now |
|
Understanding & Managing SQL Server Fragmentation
In this on-demand webcast, SQL Server expert Greg Robidoux discusses what database fragmentation is, how it occurs and how to avoid the performance degradation it can cause. The presentation includes a demonstration of how to use the native tools in SQL Server to find and fix fragmentation. You’ll also see a demo of how you can manage fragmentation automatically using Idera SQL defrag manager.
Our presenter is Greg Robidoux - President and Founder of Edgewood Solutions, a technology services company delivering services and solutions for Microsoft SQL Server. He has been working with SQL Server for the past 11 years and has authored numerous articles and delivered several presentations online and at local and national SQL Server events. | Greg Robidoux | Register Now |
|
Ten tips for proactive SQL Server monitoring, Part 2
Tired of phone calls from end users complaining about slow SQL Server performance? Tune into this two-part webcast to learn practical tips for proactively monitoring and managing SQL Server performance.
In this live series, Greg Robidoux with Edgewood Solutions will demonstrate 10 tasks every DBA should know to keep SQL Server running smoothly. You’ll also see a demo of how you can use Idera’s award-winning SQL diagnostic manager to complete these tasks in no time. | Greg Robidoux | Register Now |
|
Ten tips for proactive SQL Server monitoring, Part 1
Tired of phone calls from end users complaining about slow SQL Server performance? Tune into this two-part webcast to learn practical tips for proactively monitoring and managing SQL Server performance.
In this live series, Greg Robidoux with Edgewood Solutions will demonstrate 10 tasks every DBA should know to keep SQL Server running smoothly. You’ll also see a demo of how you can use Idera’s award-winning SQL diagnostic manager to complete these tasks in no time.
| Greg Robidoux | Register Now |
|