Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2008   (RSS)
Sunday, November 16, 2008 2:01 PM

SQL Server 2008 - Resource Governor - Part II

Hi Friends, I was a bit caught up during these days so I could not update my blogs since a long time. Today again it is a weekend and I have some time so I am writing the article on Resource Governor Part II which is overdue since a long time. In my first
Posted by Ravi | (Comments Off)
Attachment(s): ResourceGovernor.sql
Wednesday, July 23, 2008 2:50 AM

SQL Server 2008 - Resource Governor - Part I

Hi Friends, I am back with one more blog post on an interesting feature in SQL Server 2008. Today I was discussing about run away situations with my colleagues and I found that only few people read about this excellent feature available in SQL Server
Posted by Ravi | (Comments Off)
Monday, July 21, 2008 7:08 AM

SQL Server 2008 - Auditing

Hi Friends, I am back again with one more blog post on SQL Server 2008 Auditing. As we all know that SQL Server 2008 is coming up with *Cool* enhancements that will help the End Users, DBAs, Developers in improving their productivity. Today I am going
Posted by Ravi | (Comments Off)
Thursday, July 10, 2008 1:08 AM

Policy-Based Management : SQL Server 2008

NOTE: Declarative Management Framework has been renamed to Policy-Based Management so I just changed the Title of the article, the contents are unchanged. Hi, I am writing this post after somewhat long time … I hope you all are continuing with your
Posted by Ravi | (Comments Off)
Tuesday, July 08, 2008 6:38 AM

SQL Server 2008 - Change Data Capture - Part II

Hi ! It's been a long time since I last updated my blog. To continue with the Change Data Capture feature of SQL Server 2008, this is new post that helps you to know how you can write your own stored procedures / functions to get the required data in
Posted by Ravi | (Comments Off)
Attachment(s): CDC Modified.sql
Sunday, March 30, 2008 5:40 AM

SQL Server 2008 - Change Data Capture - Part I

Hello everyone .. It's been a long time since I haven't blogged. So today being a weekend again I have some time for jotting down this blog. Writing gives me a great pleasure and since last few months I didn't get this pleasure to get in touch with you
Posted by Ravi | (Comments Off)
Attachment(s): CDC.sql
Saturday, March 29, 2008 5:05 AM

White Papers : SQL Server 2008

Discover SQL Server 2008 through a variety of solution and technology-focused white papers.   General SQL Server 2008 Product Overview Microsoft SQL Server provides a policy-based system for managing one or more instances of SQL Server along with
Posted by Ravi | (Comments Off)
Sunday, October 21, 2007 5:36 PM

FileStream Data Type : SQL Server 2008

I am loving the enthusiasm that people have for SQL Server 2008. Everyday I come across many questions on SQL Server 2008, this shows that people are curious and I am pretty sure that people are regularly reading and learning SQL Server 2008 to know more
Posted by Ravi | (Comments Off)
Sunday, September 23, 2007 4:38 PM

Table-valued Parameters - SQL Server 2008

Hi... here is one more article on SQL Server 2008 Enhancements. In past we should have found it a bit difficult to pass numerous parameters to the T-SQL Statements or Functions or Stored Procedures. The approach we used to take is creating a Temporary
Posted by Ravi | (Comments Off)
Monday, September 17, 2007 1:51 AM

Scale up with SQL Server 2005 / SQL Server 2008 - NUMA

This article is related to the NUMA (Non Uniform Memory Access) feature available with SQL Server. NUMA is a very useful feature to scale up the Server. Even before we discuss how SQL Server 2005 supports NUMA we have a few questions that needs to be
Posted by Ravi | (Comments Off)
Tuesday, August 28, 2007 6:33 PM

SQL Server 2008 - Enhancements in Date and Time Data Types

I am finding SQL Server 2008 very exciting. Every day it's a new learning for me and my eyes glitter seeing the sweet surprises that SQL Server 2008 is bringing in for efficient data management. I like SQL Server because I realize that data is like the
Posted by Ravi | (Comments Off)
Tuesday, August 28, 2007 4:56 PM

SQL Server 2008 - HierarchyID - Part II

Hi ! are you interested to know more about the HierarchyID then grab a bag of chips for yourself and read on. If you haven't read about the HierarchyID then it is recommended that go to my last post SQL Server 2008 - HierarchyID - Part I and read that
Posted by Ravi | (Comments Off)
Friday, August 17, 2007 12:37 PM

SQL Server 2008 - HierarchyID - Part I

I am excited by the cool new features that SQL Server 2008 is binging up ! SQL Server 2008 is bringing some commendable new features one of the nice feature is HierarchyID . This a new data type that is available in the in the latest July CTP of the SQL
Posted by Ravi | (Comments Off)
Attachment(s): HierarchyID Query.sql
Monday, August 13, 2007 12:37 AM

Data Compression with SQL Server 2005 SP2 and SQL Server 2008

One of the very useful feature introduced in SQL Server 2005 SP2 and SQL Server 2008 is vardecimal data type. When the databases are growing every day it is a significant concern for the DBAs to use the storage space efficiently. Bigger the row size then
Posted by Ravi | (Comments Off)
 
Page view tracker