| Date & Time | Description | Speaker | Register |
|
| 05/09/2012 2PM CT | HA - No Longer a Laughing Matter with AlwaysOn
Today’s DBA is on the hook for ensuring high availability of their databases more so than ever. Tune in to this webcast to learn more about one of the most anticipated enhancements to Microsoft SQL Server 2012, AlwaysOn for high availability (HA). Previously, multiple methods – mirroring, clustering, log shipping - had to be employed to achieve high availability. Now, with AlwaysOn, SQL Server 2012 combines these actions into one step, reducing the cumbersome work DBAs typically went through for HA. | Denny Cherry | View Archive |
|
| 04/11/2012 2PM | Why Is My Virtual SQL Server So Slow?
After we virtualize SQL Server, troubleshooting performance becomes a lot tougher. There's more moving parts like shared storage and VMware, and we DBAs don't usually get access to those tools to find out what's going on. Join Microsoft Certified Master Brent Ozar as he shows you how to use your familiar tools like Perfmon to get the evidence you need, plus learn new tools like wait stats and vSphere that help you identify bottlenecks. This session is targeted at production database administrators with 1-5 years of experience. | Brent Ozar | View Archive |
|
| 3/14/2012 | What Are You Waiting For?
In this session, we’ll look at wait statistics and what they are. We’ll look into how they are accumulated and how they can be monitored. By the end of the session, you’ll be equipped with the tools needed to determine if there are resource issues in your environment and methods to start mitigating them. | Jason Strate | View Archive |
|
| 2/8/2012 | Successfully Meeting Your Audits for Microsoft SQL Server
What information is in your SQL Server database? Who has access to it? Should they have access to it? Can they change the data surrepitously to cover something up? These are the basic questions a whole host of regulations, standards and laws like SOX, PCI, HIPAA, and others are designed to ask. Microsoft SQL Server is smack in the middle of these questions as a repository for that information. In this webinar, we'll cover some of what Microsoft SQL Server provides to answer these questions and how best to implement them for your environment. We'll look at what works and what doesn't. And because the fine details of dealing with audits and compliance can be tedious and time consuming, we'll also look at ways to automate these things to reduce the amount of time you're required to spend on them.
| Brian Kelly | View Archive |
|
| 01/18/2012 | Putting a Better SQL Server in Production
Problems come up everyday that could have been avoided by simply configuring SQL Server appropriately before using it. The tricky part is knowing what to change and how to determine the correct setting. Some settings require knowledge of how SQL Server works internally and how the setting affects performance. We'll take a look at the default settings in SQL Server that should be changed before a SQL Server is put into production and provide guidelines on how to determine the best settings with which to go into production. | Robert L. Davis | View Archive |
|
| 12/14/2011 | Database Worst Practices
"Oh no! What did I do?" Chances are you have heard, or even uttered, this expression. This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days. The goal of this session is to expose the small details that can be dangerous to the production environment and SQL Server as a whole, as well as talk about worst practices and how to avoid them. Shedding light on some of these perils and the tricks to avoid them may even save your current job.
| Pinal Dave | View Archive |
|
| 11/09/2011 | Learning to Hate the SMO: A PowerShell Love Story
Sure, you can interact with the SMO and other assemblies directly from PowerShell, but who wants to write complex scripts time and time again? When you need to write your own customizations to work against SMO, you’ll want to make something more reusable by building PowerShell functions rather than leaving them as scripts. Part of the real magic of PowerShell is the ability to combine basic functions to do complex operations. The more reusable functions you build, the fewer scripts you have to write.
In this session Microsoft MVP and Idera ACE Aaron Nelson will show you how to write a custom SMO script and turn it into a reusable function. He’ll then take it a step further by making it work with a function from the SQLPSX. | Aaron Nelson | View Archive |
|
| 10/05/2011 | SQL Server PowerShell Extensions
Windows PowerShell is an easy way to automate tasks, gather info, and deploy objects to your SQL Servers but how do you get started? Microsoft MVP Aaron Nelson will discuss easy shortcuts the SQLPSX Module provides for managing multiple SQL Servers. Aaron will also walk you through the hierarchy of some of the core functions and provide you with a sequence that enables you reuse your scripts. | Aaron Nelson | View Archive |
|
| 09/14/2011 | Easily Manage your SQL Servers with CMS and PBM
In this session, you will learn how to setup and implement Central Management Server (CMS) to run queries against multiple SQL servers in your environment. We will also cover Policy Based Management (PBM) and how to use out of the box best practices and create custom policies to maintain your environment. We will then look at using both CMS and PBM in conjunction with each other to monitor your environment.
| Mitchell Bottel | View Archive |
|
| 8/10/2011 | PowerShell for SQL Server: An Introduction
Windows PowerShell is rapidly becoming the go-to scripting choice of System Administrators but what does that mean for SQL Server DBAs? In this session of Secrets of SQL Server, Microsoft MVP Aaron Nelson will discuss what PowerShell is and demonstrate how and why DBAs should use it. Aaron will step you through the basics of Windows PowerShell and provide you with some commonly used first scripts to help you get started. He’ll also cover some basic troubleshooting techniques and introduce you to new and exciting ways you can use Windows PowerShell in your production environment.
| Aaron Nelson | View Archive |
|
| 07/13/2011 2PM CST | TempDB: Performance and Manageability
Misconceptions and inconsistent advice on tempDB abounds - even highly skilled DBAs cannot always agree on how to best configure tempDB. Part of the problem is that there is no single solution that can be applied to every situation. How many files should tempDB have? Should it be on RAID 1? RAID 10? How about Solid State Drives (SSDs)? This session will give you the tools to determine the optimal configuration for tempDB. Also covered is how to detect, prevent, and monitor for common tempDB performance problems. | Robert L. Davis | View Archive |
|
| 06/08/2011 2 PM CST | SQL Server, Storage and You - Part III: Solid State Storage
Rounding out the series we will cover more exotic methods of storing your data aimed squarely at speeding things up. Solid state storage has burst onto the database scene in the last three years with amazing performance numbers and a price tag that brings it within reach. Covering the basics of NAND Flash, the foundation of solid state storage, you should be able to ask the right questions and evaluate if solid state is the best option for your growing data needs. Like every other storage technologies, solid state has its own issues you need to be aware of.
| Wes Brown | View Archive |
|
| 5/26/2011 | SQL Server, Storage and You - Part II: SAN and NAS
Building on your new understanding of disk and RAID we will apply that knowledge to understanding Storage Area Networks and Network Attached Storage. This could be in the form of a traditional SAN attached via Fibre Channel or newer iSCSI attached storage across your regular IP network. SAN’s and NAS’s have their own challenges, but also open up a whole new set of tools for disaster recovery and high availability. We will touch on the basics that can be applied to most SAN’s and talk about strategies for setting up your storage.
| Wes Brown | View Archive |
|
| 04/13/2011 | SQL Server, Storage and You
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. | Wes Brown | View Archive |
|
| 03/09/2011 | Security, Performance, and Maintenance Advantages to Using Stored Procedures over ORM Tools
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.
| Jack Corbett | View Archive |
|
| 02/16/2011 | Improving Performance By Scaling Out With Transactional Replication
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. | Kendal Van Dyke | View Archive |
|
| 01/12/2011 | 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 Archive |
|
| 12/08/2010 | 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 Archive |
|
| 11/17/2010 | 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 Archive |
|
| 10/12/2010 | 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 Archive |
|
| 09/08/2010 | 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 Archive |
|
| 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 | View Archive |
|
| 7/14/2010 2 PM CST | 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 Archive |
|
| June 9, 2010 3PM CST | 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 Archive |
|
| 05/12/2010 3 PM CST | 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 Archive |
|
| 04/14/2010 3PM CST | 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 Archive |
|
| 03/10/2010 3 PM CST | 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 Archive |
|
| 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 Archive |
|
| 1/13/2010 3 PM CST | 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 Archive |
|
| 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 | View Archive |
|
| On demand | 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 | View Archive |
|
| On demand | 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 | View Archive |
|
| On demand | 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 | View Archive |
|
| On demand | 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 | View Archive |
|
| On demand | 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 | View Archive |
|
| On demand | 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 | View Archive |
|
| On demand | 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 | View Archive |
|
| On demand | 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 | View Archive |
|
| On demand | 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 | View Archive |
|
| On demand | 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 | View Archive |
|
like us
follow us
link to us
channel us
join the circle