Check our collection of high-quality articles, on a variety of SQL Server 2008 topics. The collection is being regularly updated with new articles.
In this article, we will be discussing about a very useful built-in SQL Server Management Studio tool, that is the SQL Server Copy Database Wizard. About the Copy Database Wizard in SQL Server Management Studio There is many times where we might need to copy or move a database with the least amount of … Read more…
SQL Server 2008 Service Pack 1 was just released yesterday (April 7, 2009). Along with the fixes for known bugs, this Service Pack also adds some new functionality to SQL Server 2008 mainly from the DBA’s perspective. What’s new Microsoft has added new functionality to SQL Server with this service pack. The main new features … Read more…
This short post, discusses about SQL Server 2008 Feature Pack, what it is and what functionality it offers. SQL Server 2008 is undoubtedly an extremely powerful Relational Database Management System. It comes with many new features that increase the database developer’s productivity and make the life of the DBA easier. In September 2008, Microsoft has published … Read more…
This article, discusses about the SQL Server 2005 Surface Area Configuration Tool. What is SQL Server 2005 Surface Area Configuration Tool? An important security improvement in Microsoft SQL Server 2005 is that various of its features that could be potentially susceptible to security risks are turned off by default. One of these features is … Read more…
Hi friends, this article discusses the “Backup Compression” feature in SQL Server. About Backup Compression in SQL Server How many times have we backed up a database and then we have tried to minimize the size of the backup set by compressing it with an archiving utility? I am quite sure that such cases … Read more…
In this article, we will be discussing about Table-Valued Parameters (TVPs) in SQL Server 2008 and later. Support of Table-Valued Parameters is another great new feature in SQL Server 2008 and later. I am sure that all of us had to make a stored procedure or function call in SQL Server many times. In the … Read more…
In this article, we will compare DATETIME2 vs DATETIME in SQL Server, discuss about their precision and see some examples. About DATETIME2 in SQL Server The DATETIME2 is a data type in SQL Server, that was originally included in SQL Server 2008. We all know of the existence of the DATETIME. So, what is … Read more…
Yesterday I managed to pass the Microsoft exam 070-432: Microsoft SQL Server 2008, Implementation and maintenance and thus, earned the Microsoft Certification MCTS: SQL Server 2008, Implementation and Maintenance. Additionally I earned the title of Charter Member for my MCTS on SQL Server 2008. Microsoft SQL Server 2008 provides many useful features thus forming a … Read more…