SqlServer-QA.net

How many tools (new and enhanced) are available within SQL Server 2008 when you have a need to monitor the performance of queries that are executing/generated? The initial ones you remember is PROFILER and PERFMON (SYSMON) tools, even further few will say Performance Dashboard reports & Dynamic Management Views. The new tools that are ...

En français Get a 300$ early bird discount by registering before September 13th. We are offering an early bird of 300$ CAD for attendees that are registering before September 13th, 2008. Registered attendees have access to the DevTeach Archive sessions material for download. Early registration (3 Days) Cost CAN Cost ...

          Date: Wednesday, August 20, 2008*     Time: 4 PM Eastern | 3 PM Central | 1 PM Pacific     Speaker: SQL Server MVP, Hilary Cotter     Attend and win! Find out how!     *Want to attend ...

Microsoft press announces that SQL Server 2008 is available for users and as per PressRelease : ...announced the release to manufacturing of Microsoft SQL Server 2008, the new version of the company’s acclaimed data management and business intelligence platform. This version of SQL Server provides powerful new capabilities such as support for ...

When it comes to the data encryption within SQL Server 2008 you would think about Transparent data encryption (TDE) which is a new encryption feature.   It sounds good that this is a high level security feature you can deploy to secure the data, and a catch is you can do it without affecting existing applications. Traditional ...

SQL Native client or MDAC - which is best one to use? This was the question I was asked during my presence at DAT booth at the Tech-Ed ITPRO conference in Orlando. The sensible answer will be 'it depends'. Practically I have seen that there are a number of differences between SQL Server Native Client and MDAC. Although both provide native data ...

Ok, replication concepts and technology has been continuing since the olden days (version 70) within SQL Server journey. To talk about new features within SQLServer 2008 comapring to the previous versions, FILESTREAM where much of data is created every day such as documents, images and videos that needs a structured storage for better performance ...

Scalability is an important aspect in every application, a common achievement within OLTP environment and still applicable to OLAP (Anlaysis Services) environment. In any if the application or a cube or mining model may be unavailable for querying because of a hardware or software failure, also it could be one of the reasons such as ...

You may be aware that MVPs have the advantage of getting to know about the product information before it is let to the user community, that is the main advantage (I feel) to make the most of MVP award experience, Microsoft keeps MVPs informed of award benefits, updates, news about their peers, and events that are occurring in their region and ...

Have you looked at the Activity Monitor screen within the Managment Studio? I feel this is somewhat surprise features included from February CTP (or was it there before?). This is more useful to the DBAs to have a look at resource activity and locking/blocking. There is no doubt that Ken Henderson's insight is filled up within this feature and ...