MSSQL
Articles
Database Auditing in Ms-SQL 2008

Database Auditing in Ms-SQL 2008

How To Build a Cube Without a Data Source Using SQL Server Analysis Services

How To Build a Cube Without a Data Source Using SQL Server Analysis Services

How to use SSIS package as a data source for SQL Server Reporting Services 2008 R2

How to use SSIS package as a data source for SQL Server Reporting Services 2008 R2

DBA Checklist

DBA Checklist

Sometimes, all a DBA needs, to help with day-to-day work, is a checklist of best-practices and dos and don’ts. It provides a handy reminder. Brad has come up with a new update to his famous checklist...

Management Studio Improvements in SQL Server 2008

Management Studio Improvements in SQL Server 2008

Not everybody  who had to use Management Studio when it first appeared in SQL Server 2005 liked it. The paint seemed still wet and there was still scaffolding around. To give Microsoft its' credit, it has succeeded in transforming it into a much more useful product, in its SQL Server 2008 reincarnation. Brad McGehee gives the details.

Policy-Based Management

Policy-Based Management

Every DBA knows the frustration of trying to manage tens of servers, each of which has a subtly different configuration. Policy-based management, now introduced in SQL Server 2008, could ease a lot of this pain.

What is Resource Governor?

What is Resource Governor?

SQL Server 2005/2008/2008 R2 Tables with Data Partitioning

SQL Server 2005/2008/2008 R2 Tables with Data Partitioning

 
Copyright 2010 www.sqlpassnepal.org