Its the last day of SQLPASS Summit 2008 and in few hours time I will be presenting my talk (first time in US SQLPASS) on " Effective Usage of SQL Server 2005 Database Mirroring, what's new in SQL 2008 " topic which is an enhanced version of what I have presented before in SQLBIts UK during...

The News is out for next SQL Server release!! During the Keynote presentation by Ted Kummert at PASS conference, Microsoft announced future capabilities for application and multi-server management as part of the SQL Server code-name “Kilimanjaro” release. This release is concentrated on multi-server...

Cumulative Update package 2 has now been released for SQL Server 2008. See the following KB article for full details: http://support.microsoft.com/kb/958186/en-us...( read more )

Another set of Cumulative Update package is ready for review on SQL Server 2008 - this package contains hotfixes for the issues that have been fixed since the release of SQL Server 2008. Earlier posting on Cumulative Update Package 1 for SQL 2008 one of the user asked me how to find out how many update...

PERFMON and Resource Governor - two great tools in hand for a DBA to monitor/resolve the performance problems, agreee! Back in olden days you may remember about SQLDiag and PSSDiag, the utility used as a general purpose diagnostics collection utility that can be run as a console application or as a service...

In Forums sometimes I read questions on how to find out the difference between two times which are stored as float Here are some possible answers declare @t1 char ( 5 ), @t2 char ( 5 ), @sum float select @t1 = '12.56' , @t2 = '7.58' set @sum = cast ( @t1 as float )- cast ( @t2 as float...

Direct reference to the subject ForumPost

In continuation to SQL Server - Precision Performance techniques using RML Utilities and SQL Server troubleshooting tools PSSDiag, SQLDiag, SQLNexus, RML Utilities and ReadTrace: which one to choose? posts here it will be a wonderful news for DBAs to hear that Microsoft Development team developed an...

Here is an interesting question posted in the forums here asking about: Lots of time I face the problem with dynamic sql that I cant get the temporary table with data created through dynamic sql. for instance: SET NOCOUNT ON DROP TABLE Employee CREATE TABLE Employee(EmpId INT, EmpName VARCHAR(50), Sal...

Have you ever been in a situation that one of the database has been giving hard time! It may be the times that every DBA might go through this path without realising the root cause of the issue. The issue could be out of space on the drive where that database is located and further you might see the...