Welcome to MSDN Blogs
Sign in
|
Join
|
Help
Technology - My Profession, Passion and Avocation
Ravi S.Maniam's Blog
This Blog
About
Email
Syndication
RSS 2.0
Atom 1.0
Search
Go
Tags
.net
Administration
ASP.net
Audit
Auditing
Best Practices
Business Intelligence
C#
CDC
Change Data Capture
CPU
Data Compression
Data Engine
data type
Database Audit
Date
DateTime
DateTimeOffset
Declarative Management Framework
Demo
Enhancements
File
FileStream
Hierarchy
HierarchyID
Katmai
Management
Memory
NUMA
Parameter
Policy
Policy-Based Management
Reporting
Resource Governor
Sample
Sample Code
Scalability
Scale Up
Security
Server Audit
SQL
SQL Server
SQL Server 2005
SQL Server 2005 Reporting Services
SQL Server 2008
SQL Server Server 2008
Table-valued
Time
T-SQL
vardecimal data type
Visual C++
What's new
White Paper
News
SQL Server 2008 Information Center
Microsoft Business Intelligence
SQL Server 2008 Whitepapers
Microsoft SQL Server Security
Video: NASDAQ Deploys SQL Server 2005 to Support Real-Time Trade Booking and Queries
Archives
July 2008 (4)
March 2008 (2)
October 2007 (1)
September 2007 (2)
August 2007 (4)
July 2007 (2)
June 2007 (1)
May 2007 (2)
April 2007 (1)
My Favorites
Katmai - SQL Server 2008
SQL Server 2008 BI
SaaS - Software as a Service
Browse by Tags
All Tags
»
SQL Server
(RSS)
.net
Administration
ASP.net
Audit
Auditing
Best Practices
Business Intelligence
C#
CDC
Change Data Capture
CPU
Data Engine
data type
Database Audit
Date
DateTime
DateTimeOffset
Declarative Management Framework
Demo
Enhancements
File
FileStream
Hierarchy
HierarchyID
Katmai
Management
Memory
NUMA
Parameter
Policy
Policy-Based Management
Reporting
Resource Governor
Sample
Sample Code
Scalability
Scale Up
Security
Server Audit
SQL
SQL Server 2005
SQL Server 2005 Reporting Services
SQL Server 2008
SQL Server Server 2008
Table-valued
Time
T-SQL
Visual C++
What's new
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)
Filed under:
SQL
,
SQL Server
,
Katmai
,
SQL Server 2008
,
Data Engine
,
Enhancements
,
Management
,
Administration
,
What's new
,
CPU
,
Memory
,
Resource Governor
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)
Filed under:
SQL
,
SQL Server
,
Katmai
,
SQL Server 2008
,
Data Engine
,
Enhancements
,
Best Practices
,
Administration
,
Policy
,
What's new
,
Sample
,
Database Audit
,
Auditing
,
Demo
,
Security
,
Audit
,
Server Audit
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)
Filed under:
SQL
,
SQL Server
,
SQL Server 2008
,
Declarative Management Framework
,
Policy
,
What's new
,
Policy-Based Management
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)
Filed under:
SQL
,
SQL Server
,
SQL Server 2008
,
Change Data Capture
,
CDC
,
Sample
,
Sample Code
Attachment(s):
CDC Modified.sql
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)
Filed under:
SQL
,
SQL Server
,
Katmai
,
SQL Server 2008
,
T-SQL
,
data type
,
Data Engine
,
Enhancements
,
FileStream
,
File
,
What's new
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)
Filed under:
SQL
,
SQL Server
,
.net
,
Katmai
,
SQL Server 2008
,
T-SQL
,
data type
,
Data Engine
,
Enhancements
,
Table-valued
,
Parameter
,
What's new
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)
Filed under:
SQL
,
SQL Server
,
SQL Server 2008
,
SQL Server 2005
,
Scalability
,
NUMA
,
Scale Up
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)
Filed under:
SQL
,
SQL Server
,
Katmai
,
SQL Server 2008
,
data type
,
Time
,
Date
,
DateTimeOffset
,
DateTime
,
What's new
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)
Filed under:
SQL
,
SQL Server
,
SQL Server 2008
,
HierarchyID
,
Hierarchy
,
What's new
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)
Filed under:
SQL Server
,
SQL Server 2008
,
HierarchyID
,
T-SQL
,
data type
,
Hierarchy
,
What's new
Attachment(s):
HierarchyID Query.sql
Saturday, July 28, 2007 8:37 PM
SQL Server 2008 - Katmai
Excited about SQL Server 2008 ! so I am. "Your Data, Any Place, Any Time" It is highly exciting to know about the features in SQL Server 2008. The mission of SQL Server 2008 is to provide your data on your demand at your place, isn't it exciting.
Posted by
Ravi
|
(Comments Off)
Filed under:
SQL Server
,
SQL Server Server 2008
,
Katmai
Saturday, July 28, 2007 5:58 PM
Dynamically add images to SQL Server 2005 Reports – ASP.Net Web Project
It is very exciting to know that people are widely using SQL Server 2005 Reporting Services. I am always happy to answer their questions. A couple of days back a gentleman requested for some help on the project that I have posted on this blog –
Posted by
Ravi
|
(Comments Off)
Filed under:
SQL Server 2005 Reporting Services
,
Reporting
,
SQL Server
,
ASP.net
,
.net
Attachment(s):
DynamicImage.zip
Monday, June 04, 2007 2:09 PM
Business Intelligence Virtual Labs
http://www.microsoft.com/technet/traincert/virtuallab/bi.mspx The following labs are available on this page: Business Intelligence: Excel 2007 PivotTables and Analysis Services Business Intelligence: Using Business Scorecard Manager 2005 and ProClarity
Posted by
Ravi
|
(Comments Off)
Filed under:
SQL Server 2005 Reporting Services
,
SQL Server
,
Business Intelligence
Sunday, May 20, 2007 12:48 PM
Dynamic Data Binding - SQL Server 2005 Reporting Services
In reference to my earlier post regarding - How to dynamically add the images to the SQL Server 2005 Reporting Services – Reports, I received a few queries so I decided to write a small code sample myself just in order to demonstrate how we can
Posted by
Ravi
|
(Comments Off)
Filed under:
SQL Server 2005 Reporting Services
,
SQL Server
,
C#
Attachment(s):
MyBlog.zip
Sunday, May 20, 2007 7:41 AM
How to use SQL Server Reporting Services with Visual C++
We can render the SQL Server 2000 Reporting/ 2005 Services (SSRS 2000) Reports in Excel/ PDF or any other format that is supported by SSRS by calling the web services exposed by SSRS 2000/ 2005. The SSRS 2000 will use .Net 1.1 at the server end and SSRS
Posted by
Ravi
|
(Comments Off)
Filed under:
SQL Server 2005 Reporting Services
,
Visual C++
,
Reporting
,
SQL Server
More Posts
Next page »