SQL Server security best practice

Security! This is the word comes in mind of every concerned person when it come...

Change the Collation Settings in MS SQL Server

This post will show you how to change the collation settings in MS SQL Server for specific database...

Resolve collation conflict

In this post I will show you how you can resolve collation conflict error...

Book: SQL Server 2008 High Availability

In this book I have tried to cover every single piece of information that might requires for installing and configuring SQL Server HA option like Clustering, Replication, Log Shipping and Database Mirroring...

Why to recompile Stored Procedure

Generally, we create views and stored procedures (proc here after) ...

Showing posts with label vinod kumar. Show all posts
Showing posts with label vinod kumar. Show all posts

9/26/2011

SQL 2008 R2 Administration Cook Book


Couple of week back I have received a special gift, from the person whom I admire as a elder bro and mentor – Satya SkJ. Recently he has written a cook book on SQL Server 2008 R2 Administration, forward written by MVP Brad McGehee, and reviewed by Vinod Kumar M – the most admirable person in SQL Server Community in INDIA. I am very excited to read this book thoroughly, the thing I like most in every chapter is “How it works”  section. Very soon I will post detailed review for this book.

You can find the detailed information about each chapter at the below location :
                                                  Chapter 1: Getting Started with SQL Server 2008 R2
1445EN_Microsoft SQL Server 2008 R2 Administration Cookbook Chapter 2: Administrating the Core Database Engine
Chapter 3: Managing the Core Database Engine
Chapter 4: Administering Core Business Intelligence Services
Chapter 5: Managing Core SQL Server 2008 R2 Technologies
Chapter 6: Improving Availability and enhancing Programmability
Chapter 7: Implementing New Manageability Features and Practices
Chapter 8: Maintenance and Monitoring
Chapter 9: Troubleshooting
Chapter 10: Learning the Tricks of the Trade
Appendix: More DBA Manageability Best Practices



Sounds interesting ? You can purchase the one for you at Link => https://www.packtpub.com/microsoft-sql-server-2008-r2-administration-cookbook/book#in_detail



-- Hemantgiri S. Goswami (http://www.sql-server-citation.com)

1/19/2009

Microsoft Virtual Techdays

It would be a good time again.... Microsoft Virtual Techday (VTD) is back; below is an agenda
http://www.virtualtechdays.com/agendaday1.aspx

Get registered!!

8/14/2007

Webcast on Reading Execution Plan and Query Tuning

http://www.microsoft.com/india/webcasts/default.aspx

Aug - 28th ; 14:00 - 15:30 IST

SQL Server 2005: Reading Execution Plans
The toughest part of analysis of any query is reading the execution plans. Many see this as the most difficult part, but this webcast removes this myth. We will walk you through the various operators and what they mean in the actual reading of the execution plan. There are some small changes made between SQL Server 2000 to SQL Server 2005 and we will take a quick at the same too.

Speaker: Vinod Kumar

Aug - 28th ; 14:00 - 15:30 IST

SQL Server 2005: Query Tuning
As part of application development everyone is faced with the need to tune their applications query. One aspect will be reading execution plans, but there are tons of other parameters that need attention to start the tuning exercise. This webcast takes a look at those parameters and the various tools and the tuning parameters we need to use with SQL Server 2005.

Speaker: Vinod Kumar