Normal
0
false
false
false
EN-US
X-NONE
X-NONE
MicrosoftInternetExplorer4
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"Times New Roman";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;}
SQL Server Data Recovery and Troubleshooting - strategy and
standards
DBAs will need to be pro-active,
that means the data should be recovered quickly or be prepared for worst.
How can you be assured that your RECOVERY strategies are best?
How many times you have tested the
backups?
So the action should be quickly,
when you encounter a problem that could lead to a loss of data in a customer
location which terms as "Data Recovery" problem.
SQL Server 2008 brings flavour of
new and enhancements to existing features to correct various problems like DBCC
CHECKDB failing or database being marked as suspect or log file fails to
restore etc. This session covers how to take corrective actions and what
process need to be in place in yoru database platforms.
(Prior DBA knowledge is essential)
400 DBA
SQL Server 2008 Compression features, reduce size of data
not the IT budget!
Data Compression is a buzz word if
you want to reduce the storage of data efficiently, SQL Server 2008 provides
you with native data compression feature for your tables, indexes and
partitions that can significantly reduce the size of your database. Also think
about BACKUP compression, helps in reducing its size of your database to 1/2 or
even to 1/3!
Find out whether its a myth or assumption that a smaller database can lead to
better performance. We will cover the "mission impossible
(MI)" about strategies and standards to sustain
performance for IO bound loads, reduce memory requirement and the manageability
cost (e.g. backup/recovery) of your database.
We will cover from basics to
advanced level having a flavour of demos.
400 Kat
SQL Server End To End Troubleshooting - How to use tools
& techniques?
Its a joy to see majority of SQLBits
sessions concentrates on Performance Troubleshooting.
In this session I'm covering the End-To-End track of how to detect, diagnose,
and resolve performance problems in SQL Server (not a difficult job). Be aware
that it may takes years of on-the-job experience to learn how to use the tools
and techniques that help you detect when a problem is occurring, diagnose the
root-cause of the problem, and then resolve the problem.
The talk details and demonstrates native tools and techniques that can make
your long days shorter and make difficult troubleshooting activities much
faster and easier. This is not for a DBA, every SQL Server user needs to know
how to keep their database platform in pristine condition, and you'll need
these skills to do it.
400 Kat
SQL Server 2008 R2 - What's new with virtualization and
server consolidation?
Answering the question "which
servers needed more horsepower or which ones could be consolidated
together" is not a straight one. The solution depends on deployment and
application availability, some of them may not have good answer and they are
behind in terms of monitoring the platform.
Come to this session to know what SQL Server 2008 R2 features can bring the
advantages to DBAs, SYSAdmins to plan/chalk out process to virtualize or
consolidate the server platform. You don't need a third party tool if you can
apply the technique in right place, at right time - Virtualization for
Databases!
300 Kat
Achieve SQL Server 2008 High Availability and Disaster
Recovery - technical case study
Achieving
maximum availability and near immediate recovery from a disaster is essential
for maintaining our revenue stream. Service Management principles must be
worked hard to eliminate all single points of failure in architecture, and
developed procedures for patching servers, upgrading software, and implementing
application changes that preserve high availability. Based on these efforts,
you can achieve 99.99 percent uptime, including both planned and unplanned
downtime.
This
session covers the decisions and procedures that are employed to maintain
maximum availability with minimal downtime. This information will be of
interest to senior IT managers, project leads, architects, and database
administrators (DBAs). All the content is presented from my own experience and
industry best practices, it will sum up a great deal of procedures to achieve
high availability and disaster recovery.
400 DBA
SQL Server Extended Events - diagnose and resolve production
issues!
This session covers the introduction
and concepts of SQL Server Extended Events Architecture.
Deploying and configuration of Extended Events can dramatically reduce the time
required to diagnose and resolve production issues and also find out deep
visibility into SQL Server internals.
We will also cover the online analysis that brings information about an
incident closer to the incident itself and by using Extended Events lowers time
to resolution for production problems. Let us also dive into best practices in
diagnosing the production problems.
400 Kat
Query Optimizer and Table Hints - what's best in SQL Server
2008
Hints are a powerful mechanism to
force SQL Server to use alternate query plans. More often than not, the query
optimizer does a fantastic job in creating the most optimized query plan for
data access, but there may be numerous occasions when you would like to use
alternate query plans to boost performance.
Query Hints may adversely affect performance so should be used with care. In
this breakout session, we first alert the DBAs on using Hints as they need to
be sure that there is indeed a problem with the query plan. This session
covers SQL Server Query hints topic to specify that the indicated hints should
be used throughout the query. Let us have a look at different types of
Hints including Query & Table Hints with various concepts on SQL Server
query processing architecture are also explained wherever relevant, to ensure
that the audience gets the most out of the session.
We will also cover the best practices, how-to and when-to tricks on using query
hints and optimizer.
400 DBA
SQL Server 2008 R2 new features for efficient multi-server
management
SQL Server 2008 R2 Application and
Multi-server management helps the database platform deployment in a pro-active
manner. You can manage environment efficiently at scale through centralized
visibility, resource utilization and streamlined manner of consolidation for
your application lifecyle. Come to this session to know more about control
point explorer, resource optimization (consolidation & improved service
levels) and improved efficiencies of database deployment.
400 Kat
Make your DBA life better using SQL Server technologies -
notes from field & best practices
This session details a typical DBA's
day demonstrating the new improvements of the Management Platform made for
Microsoft SQL Server 2008.
We will concentrate on how best you can make use of tools (pre-installed) of
Microsoft, as they pertain to efficient systems management, multi-server
management, performance tracking, and policy implementation. Take advantages of
detection and enforcement of security policies & design practices in your
database environment using both graphical and command-line tools. We cover
everything from the new Management interface in SQL Server and Management Data
Warehouse that also have a practical demonstration of PowerShell integration in
SQL Server administration tasks, not to mention about best practices.
400 Kat
SQL Server 2008 - Unstructured Data Storage Solutions and
Best practices
This session helps you to build a
strategy and learn how the SQL Server 2008 new feature is addressing the needs
of storing large volumes of unstructured data, while still retaining relational
control over it. These solutions enable you to reduce both capital and
operational costs for large stores of unstructured data. In this session we
also cover the best practices in such storage kind of projects.
400 DBA
Build a strategy for database backup and Disaster Recovery -
SQL Server
Planning for a disaster is not
enough, unless you have tested it! Also it's a topic that not many people like
to think about it! Let us have a look at how SQL Server technologies can help
to build a strategy that is essential to your Business, before you need it.
With SQL Server 2005 and SQL Server 2008, there are many features that will
help you to successfully weather the storm with minimal loss of data and time.
Make sure you're aware of all of the tools available to help you sleep easier at
night.
300 Kat
Take your time to register and vote for your favourite topic.
Hope to see you there, as I will be speaking on SQL Server 2008 R2 topic (Friday) and on Free Community day (Saturday).
