Monthly Archives: January 2010 - Page 2

Udostępniono zestaw webcastów z zakresu SQL Server.

IDERA udostępniła wszystkie swoje webcasty z zakresu Microsoft SQL Server, jakie ukaząły się w 2009 roku. Cykl jest bogaty, więc czym prędzej zapraszam:

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.
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.
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.
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?
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.
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.
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.
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.
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.
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.
Ten Tips for Proactive SQL Server Monitoring, Part 2
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.

Przyjemnego oglądania.

 

Symantec Data Catcher – chcesz zagrać?

Była kiedyś gra: jak dobrze zbudować serwerownię. Z tego co wiem spora cżęść koleżanek i kolegów z branży nieźle się bawiła. Jeśli już zbudowaliście serwerownię, czas zabezpieczyć dane, czyli: dane, tasiemki, komputery i wirusy. Ciekaw jestem ile punktów oda wam się zdoyć – i mnie było to 22 w pierwszym podejściu:

SQL Server Performance Tuning – kolejna część webcastów na poziomie 400 do pobrania.

Pisałem w listopadzie o ukazaniu się pierwszej części webcastów z zakresu: SQL Server Performance Tuning. Ich autorem jest światowej klasy konsultsant w tej dziedzinie Ramesh Meyyappan. W pierwszej części dostaliśmy trzy webcasty i tak samo jest w drugiej. W lutym zaś ma się ukazać część trzecia, również złożona z trzech filmów:

Truly Level 400 Performance Monitoring and Tuning Webcast 1
Part 1: SQLWbcast1Part1of3.wmv(29.1MB)
Part 2: SQLWbcast1Part2of3.wmv(47.5MB)
Part 3: SQLWbcast1Part3of3.wmv(37.4MB)

Truly Level 400 Performance Monitoring and Tuning Webcast 2
Part 1: SQLWbcast2Part1of3.wmv(35.1MB)
Part 2: SQLWbcast2Part2of3.wmv(34.9MB)
Part 3: SQLWbcast2Part3of3.wmv(30.6MB)

Wszystkie sześć części można pobrać z adresu SQL Workshops.

Wydawnictwo O’Reilly wspiera grupy społeczności IT

Kilkanaście dni temu pojawiła się informacja że wydawnictwo O’Reily dołączyło do firm wspierających Społeczności IT. Nowy rok zapowiada się więc jeszcze lepszym rokiem dla społeczności. Myślę, że nie ma sensu tłumaczyć “co autor miął na myśli, bo i tak komunikacja z wydawnictwem jest prowadzona w języku angielskim. Poniżej treść zapisu jaki ukazał się ósmego stycznia na Blogu Microsoft Press:

Hello Microsoft Press readers!

Marsee Henon, from O’Reilly Media, here. Do you run a user group, professional association, or other community group? I’d like to invite you to join the user group program sponsored by O’Reilly Media. As part of our new relationship with Microsoft Press, O’Reilly Media can extend the following benefits to you and your group members:

  • Free book samples. Use them for your group library, for meeting giveaways and special events, to write reviews, and more
  • Discount on books, e-books, and O’Reilly-sponsored events
  • News and product announcements
  • Book authors as potential speakers
  • Event sponsorship opportunities

For more information or to register, go to: http://ug.oreilly.com/

Content Protected Using Blog Protector By: PcDrome.
Skip to toolbar