SQL View: Beyond the Basics

This article discusses cool stuff beyond the basics of how with check option" works

http://www.simple-talk.com/sql/t-sql-programming/sql-view-beyond-the-basics/

cheers
samitha

Indexed view deadlocking

Following article provide some insight into tracking down deadlocks.

http://www.sqlservercentral.com/blogs/dave_ballantynes_blog/2012/06/13/indexed-view-deadlocking/

cheers
samitha

Cumulative Updates available for SQL Server 2008 SP2 & SP3

Cumulative Update #10 for SQL Server 2008 Service Pack 2 and Cumulative Update #5 for SQL Server 2008 Service Pack 3

SQL Server 2008 Service Pack 2
http://support.microsoft.com/kb/2696625

SQL Server 2008 Service Pack 3
http://support.microsoft.com/kb/2696626

cheers
samitha

Deciding on table partitioning

If you think you have come to a point where you need to partition tables, check this post to determine whether you actually need it,

 http://www.brentozar.com/archive/2012/03/how-decide-if-should-use-table-partitioning

Cheers,
Samitha

SQL Server 2012 Released to Manufacturing

Take a look at new SQL Server 2012

http://blogs.technet.com/b/dataplatforminsider/archive/2012/03/06/sql-server-2012-released-to-manufacturing.aspx

Cheers
Samitha

Getting Started with Business Intelligence Semantic Model (BISM) in SQL Server 2012

The Business Intelligence Semantic Model is one of the most significant enhancements in SQL Server 2012. BISM allows aspects of the traditional multidimensional model to coexist with the relational model in a format called the tabular model and can be used with all client tools in the Microsoft BI stack.

Read More
http://www.sql-server-performance.com/2012/bism-sql-server-2012/

cheers
Samitha

Intersect, Except, Union, All and Any

This article examines some of the little used T-SQL items function and see if they work for you

reade more

http://www.sqlservercentral.com/articles/T-SQL/67545/

cheers
Samitha

INSERT, UPDATE and DELETE against a Database Snapshot

This article demonstrates that it is possible to run an INSERT, UPDATE or DELETE against a Database Snapshot. 

http://sqlcat.com/sqlcat/b/msdnmirror/archive/2011/10/17/successfully-execute-an-insert-update-and-delete-against-a-database-snapshot.aspx

cheers
Samitha

Download Microsoft SQL Server 2012 Release Candidate (RC)

Experience the full value of SQL Server 2012 now. The release candidate is a production-quality release that gives you the chance to download, preview, and deploy the full marquee capabilities being delivered in SQL Server 2012.

http://technet.microsoft.com/en-us/evalcenter/hh225126.aspx?prod=SQL%25tech=CL%20%25type=DL%25prog=eval 

Cheers,
Samitha

XLSExport

A CLR procedure utilizing the NPOI library to export the results of a passed stored procedure to an Excel spreadsheet. read more cheers samitha

Index Management

This article demonstrates an Index Management strategy to tackle day to day performance issues due to improper indexes.   read more http://www.sqlservercentral.com/articles/Indexing/68079/  cheers samitha

Using Extended Events to troubleshoot SQL Server issues

As a DBA, you'll encounter elusive performance, connectivity and locking problems that you'll need to troubleshoot. There are many tools that you can use such as Profiler. In addition to these tools, SQL Server 2008 offers extended events ("XEvents"), which you can use as a powerful tracing system. By default, the "system_health" extended events session is always on, and can provide you help to locate the source of trouble much faster

read more
http://www.mssqltips.com/tip.asp?tip=2369

cheers
samitha

SQL Azure Migration Wizard

There’s a project over on code plex to come up with a mechanism for validating databases and generating the necessary scripts to allow you to move those databases, and data, over to SQL Azure

http://www.sqlservercentral.com/blogs/scarydba/archive/2011/5/9/sql-azure-migration-wizard.aspx

cheers
samitha

Using SQL Server Resource Governor to Control Resource Utilization

This article introduces SQL Server Resource Governor and provides a detailed walkthrough of using Resource Governor to manage the resource utilization of SQL Server

 http://www.sql-server-performance.com/articles/per/resource_governor_system_resources_p1.aspx

cheers
samitha

Server-side Tracing

SQL Trace is one of my favorite SQL Server features. Tracing in SQL server allows one to selectively capture and record valuable details of SQL Server Database Engine events that would otherwise be discarded. Information captured with these events is useful for a variety of purposes, such as performance analysis, troubleshooting, forensics, establishing baselines and proactively identifying problem areas.

Read more
http://www.sqlservercentral.com/articles/SQL+Trace/71693/

cheers
samitha

The DELETE statement in SQL Server

This article discusses some tricks about the Delete statement that might save your time.

http://www.simple-talk.com/sql/learn-sql-server/the-delete-statement-in-sql-server/

Cheers
Happy coding
samitha

An example of Test-Driven Development in SQL Server 2005

This article demonstrates principles of test-driven database development (TD3) along with Try/Catch and SqlCmd functionality. Make sure u read all 5 parts...!!!

http://www.sqlservercentral.com/articles/Testing/66553/

Cheers
samitha

centralize your SQL Server Event Logs.

Learn how you can centralize the Event log data for your servers.

http://www.sqlservercentral.com/articles/Monitoring/71390/


Cheers
Happy coding
Samitha