The best SQL Server training ever

If you wish to attend the best SQL Server training available on earth you have no other options as to go with SQLSkills because those guys provide the best inside ever about SQL you can imagine. The team provides only senior level of expertise and beyond literally about everything related to SQL Server ecosystem. The main reason why the team is so awesome is experience (just looks through their job records). Any other information or debates in order to persuade you to have a look at those courses are redundant.

Here is my next one I would like to attend: IEPTO2: Performance Tuning and Optimization – Part 2 class in Chicago, October 9-13, 2017




Categories: Uncategorized

Procedure Cache – Memory Pressure

December 13, 2012 3 comments

_MG_2719Hi everyone,

Recently I was dealing with unusual behavior of Procedure Cache caused pseudo-random execution plans to be removed from memory (SQL Server 2005, 2008, 2008R2). As a result, under a large workload there was observed locks contention related to schema locks required in order to compile and insert a procedure into Procedure Cache. This is a predictable behavior of heavy loaded systems. But, the main question here is – how can we identify this type of issues related to so called Memory Pressure in Procedure Cache? Read more…

Categories: Memory, Uncategorized

Inside the SQL Server Query Optimizer

September 30, 2011 Leave a comment

A new book about SQL Server query optimizer has been published recently by Red gate.

I have not had enough time yet to cover an entire book but selected chapters were really impressive. I would say the book contains much more useful explanations and examples I could expect and focused to an audience which want to go dipper. If you are SQL Server professional and keen dealing with query optimizer the book is definitely for you.

I would like to tell thank you to Benjamin Nevarez which wonderful work as the main author is amazing.

Now it is available on Amazon and some other book-stores. You also can find more detail description chapter y chapter using this link. Read more…

NetScaler DataStream as a database server load balancer

August 26, 2011 1 comment

NetScaler DataStream represents a technology which can help IT professionals in enterprise database area enhance scalability and fail-over capability their production databases even further than we have thought.

I want to describe the main features of the package in order to provide readers some more confidence with using such solutions: Read more…

Categories: News Tags: ,

Microsoft® SQL Server® 2008 R2 Service Pack 1

Hi everyone!

Eventually SQL Server 2008 R2 Service Pack 1(SP1) has been released and now it is accessible for downloading. SQL Server 2008 R2 service pack updates all services of SQL Server 2008 R2 until SP1. Service pack includes all cumulative updates starting from 1 up to 6. You can use it easily to update the further list of SQL Server editions:

(1) SQL Server 2008 R2 Datacenter Edition
(2) SQL Server 2008 R2 Enterprise Edition and Developer Edition
(3) SQL Server 2008 R2 Standard Edition
(4) SQL Server 2008 R2 Web Edition
(5) SQL Server 2008 R2 Workgroup Edition
(6) SQL Server 2008 R2 Express Edition

Important: in order to update SQL Server 2008 R2 Express Edition, you should use SP1 for Express Edition or Express Edition with Advanced Services. Read more…

Using fn_dblog

I like the fn_dblog function even if it is undocumented. It enables you to read from you transaction log which contains very valuable information about stuff that is happening in your database. It is for example the only way I now at this time to determin which object experienced a page split if you search for the LOP_DELETE_SPLIT operation.

FROM ::fn_dblog(NULL, NULL)

Read more…

Categories: News, SQL Server 2005 Tags: , ,

Key improvements in Microsoft SQL Server 2008 R2 Service Pack 1

The Microsoft SQL Server Sustained Engineering team is pleased to announce the availability of SQL Server 2008 R2 Service Pack 1 CTP. Both the Service Pack and Feature Pack updates are available for download on the Microsoft Download Center.  Service Pack 1 for SQL Server 2008 R2 includes product improvements based on requests from the SQL Server community, and hotfix solutions provided in SQL Server 2008 R2 RTM Cumulative Update 1 to 6.

Key improvements in Microsoft SQL Server 2008 R2 Service Pack 1 are: Read more…

Categories: News Tags: