Here is the update from Tony Rogerson about upcoming SQL Server usergroup meetings: There is exciting times ahead on SQLServerFAQ with a new user...
The number of services related to SQL Server has been doubled since SQL Server 2005 is released and 2008 R2 version has got few more to watch. The...
Over a period of time I will always visit the few pages that consist information about SQL Server. It is a best practice to get updates about Service...
In continuation to the SQL Server 2008 R2 Service Pack 1 CTP release post, I had a follow-up question from a user asking about list of cumulative...
SQL Server 2008 R2 service pack 1 contains all the cumulative update pack releases since RTM release. This means SP1 CTP consist the CU Package...
When you are dealing with multi-instances and multiple databases then handling server resources is essential. By default every instance of SQL Server...
SQL Server 2008 version added a new face within SQL Server Management Studio that can help users to administer/manage/execute queries against...
What causes the query to recompile? Is it a good sign or bad sign for performance? How frequently should I recompile the stored procedures? Does a...
Yet another achievement (renewal) in my career! Glad to achieve 6th time in a row. Dear Satya Jayanty, Congratulations! We are pleased to present you...
Dimension design is an important aspect to build the Business Intelligence around the data within the data platform. Just on bascis, on OLAP world...
Here is the announcement from Microsoft Learning about Microsoft Virtualization for VMWare professionals. What is a “Jump Start†course? A...
What is the default SQL Server edition used in your organization? As a DBA/Architect are you involved in deciding what version and edition of SQL...
Virtualization is a hot topic to discuss and essentail to consider when you are referring to server consolidation to save physical sprawl &...
Exciting prizes for you to win! - An Apple iPad awaits the winner (from Redgate )! A month long quiz! Fresh up your knowledge in SQL Server...
Over 85 practical recipes for administering a high-performance SQL Server 2008 R2 system. Book and eBook expected June 2011 . Pre-order now!...
Here is the best opportunity to freshen up the training and knowledge-update schedule for the year of 2011, you may know SQLBits the popular...
Parallel query processing is one of the best performance features available from SQL Server 2008 version onwards. By default Microsoft documentation...
The Channel 9 Office and SharePoint Developer Training Courses have been moved and are now available on MSDN . All the same great content just a new...
During a recent DBA consulting engagement one of the users at a client posed a question stating, "how do we hide certain tables on Management Studio...
If you know about OData services then you don't need introduction about WCF data services. Here is the latest release of WCF Data Services Toolkit...
Separate names with a comma.