Optimising SQL Server 2012- Part 2

Guys,

Here is a very useful session on "Optimising SQL Server 2012- Part 2"

Speaker: Gareth Swanepoel

An "accidental DBA" is a SQL Server administrator who has been thrust into the task without having the experience or know how required to keep SQL running at peak performance. This is not their fault and is purely due to the fact that they have not been exposed to it before. This is a follow-on to a previous webinar and I will continue to explore the process of designing and building your SQL Server for optimal performance. I will be exploring topics such as IO considerations, database file placement, partitioning, compression, and many other performance optimisation tricks.

Click here to watch it now.

Happy Learning

Sudhir

How SQL Server Replication Works Webinar

Guys,

There is a new webinar on "How SQL Server Replication Works" from pramatic works.

Speaker: Chad Churchwell

This session will dive into the different types and describe how replication works internally for snapshot, transactional, and merge replication. Also I will cover the difference in push vs pull subscriptions. Also there will be some design decisions covered when creating a replication topology.

Click here to watch it now.

Happy Learning

Sudhir

New T-SQL Features in SQL Server 2012 Webinar

Guys,

Watch this webinar by Kathi Kellenberger on New T-SQL features of SQL Server 2012.

The SQL Server 2012 release has something for everyone: Column Store Index, AlwaysOn Availability Groups, Power View and more. I bet you haven’t heard about all the great new T-SQL features! Attend this webinar to learn about the Sequence Object, new functions, THROW, and more!

Click here to watch it now.

Happy Learning
Sudhir

Inside the Query Optimizer Webinar

Guys,

Pramatic works has come up with another webinar on "Inside the Query Optimizer Webinar"

Schedule : Thu, Jan 10, 2013 9:30 PM - 10:30 PM IST

When it comes to SQL Server one of the biggest request you hear is “How can I make my Query Run FASTER!?”.  The answer understanding the first step in that process Is understanding the Query Optimizer.  Understanding the Optimizer beings with knowing the Rules. The way our queries are written reflect directly on the output that we get. In this session we will look at the rules in SQL Server, write queries to show those rules in action, and walk out with a better understanding of how the Optimizer works.

Speaker: Bradley Ball

Click here to register.

Happy Learning
Sudhir

Understanding SQL Server Concurrency

Hi,

Hope you all are doing well and had a great christmas.

Hope everyone understand what a concurrency means and what problems it can cause. To understand it better I request everyone to go download & go through this book:

Click here to download the book. Key in your email id and Name to download the book.

Book Name:  SQL Server Concurrency (Locking, Blocking and Row Versioning)
Author: Kalen Delaney

Here is the list of chapters from the book:

Chapter 1: Concurrency and Transactions
Chapter 2: Locking Basics
Chapter 3: Advanced Locking Concepts
Chapter 4: Controlling Locking
Chapter 5: Troubleshooting Pessimistic Concurrency
Chapter 6: Optimistic Concurrency

I am sure you all will find this extremely useful & can make full use of it.

Let me know if you find any problem in downloading the file.

Regards,

Sudhir Chawla