SqlServer-QA.net

This is first time Microsoft has divided the conference into 2 sections, Developer & IT-PRO.  Why Attend Tech-ed? IT Pros, you'll gain new solutions and new ideas for being more productive from sessions, product assessments, and interaction with experts and peers. Gain real-world learning from the Microsoft IT support ...

Have you ever asked this question about how do I identify the queries that worth tuning? The simple answer it is neither easy or hard to obtain such information if you have managed your SQL Server by deploying industry best practices (wherever possible). Then it comes what kind of practice you should deploy in order to obtain the ...

Don't miss our SQL Server DBA Bootcamp in Dallas, TXNovember 12-16, 2007 Register Now for this SQL Server DBA Bootcamp taught by Randy Dyess5-Day Bootcamp only $3,200!  Course Information:This course will give you a broad look at the enhancements found in SQL Server 2005. The bootcamp is designed to prepare any SQL Server DBA for the ...

As most of blogs in this section travels through usage of Dynamic Management Views (DMV) & Dynamic Management Functions (DMF) I have had an email asking What is DMV & DMF and how to find list of them from a SQL Server instance. The internal mechanism of DMV is totally relies on calls to a set of Dynamic Link Libraries that ...

Honestly I have had such decision time to choose whether to go to CLR (Common Language Runtime) or TSQL (Transact-SQL) to design on one aspect of component design at our place. Obviously TSQL was first choice as I have been experienced mostly, but don't want to miss the advantages in using CLR, with TSQL fundamentals its easy to achieve as ...

Having a feature of Notification on the server happenings is add-on for every DBA, Notification Services for SQL server 2005 has got that advantage. Microsoft confirms that capitalizing on the Microsoft .NET Framework and SQL Server, Notification Services provides an easy-to-use programming model for generating and formatting notifications based ...

Learn how to get more out of SQL Server in this free, virtual event on January 24, 2008, sponsored by SQL Server Magazine. Discover ways to more effectively utilize SQL in your current 2000 or 2005 environment, while also gaining valuable insight into how SQL Server 2008 will affect you. Who Should Attend: Database administrators Application ...