From the category archives:

SQL Server

Step by Step : SQL Server 2012 RC 0 Installation

Thumbnail image for Step by Step : SQL Server 2012 RC 0 Installation January 21, 2012

I have put together a video of SQL Server 2012 RC 0 installation for everyone’s reference.The video guides through the installation steps from beginning till end. Before proceeding with the video, Its recommended to read the prerequisites here and about some known issues during the installation here. Once you are done with the installation, You [...]

2 comments Read the full article →

AdventureWorks sample database for SQL Server 2012 RC 0 and how to attach it

Thumbnail image for AdventureWorks sample database for SQL Server 2012 RC 0 and how to attach it January 21, 2012

After going through prerequisites and installing SQL Server 2012 RC 0, You might want to try your hands on on the SQL Server Sample Databases for this release. AdventureWorks for 2012 RC 0 is available for download at : Download Adventure Works for SQL Server 2012 RC0 . AdventureWorks database provided in the link above [...]

0 comments Read the full article →

Issue with Distributed Replay Controller access while installing SQL Server 2012 RC 0

Thumbnail image for Issue with Distributed Replay Controller access while installing SQL Server 2012 RC 0 January 21, 2012

The Microsoft SQL Server Distributed Replay feature helps you assess the impact of future SQL Server upgrades. You can also use it to help assess the impact of hardware and operating system upgrades, and SQL Server tuning. Similar to SQL Server Profiler, you can use Distributed Replay to replay a captured trace against an upgraded test environment. Unlike SQL [...]

2 comments Read the full article →

Prerequisites and things to remember before installing SQL Server 2012 RC 0

Thumbnail image for Prerequisites and things to remember before installing SQL Server 2012 RC 0 January 21, 2012

Based on the feedback from SQL Server 2011 CTP3 , Microsoft released the latest release candidate (feature complete) of its flagship relational database management system SQL Server 2012 RC 0. Its available for download here . The complete hardware and software requirements are available here on MSDN. In this post I will cover some of [...]

2 comments Read the full article →

Find lead blocker on a SQL Server Instance

Thumbnail image for Find lead blocker on a SQL Server Instance December 26, 2011

When database server is experiencing slowness one of the very first things we check are blocks. Blocking can be described as Blocking is an unavoidable characteristic of any relational database management system (RDBMS) with lock-based concurrency. On SQL Server, blocking occurs when one SPID holds a lock on a specific resource and a second SPID [...]

1 comment Read the full article →

Extract Object Level Permissions from a Database

Thumbnail image for Extract Object Level Permissions from a Database December 25, 2011

Database restoration is a very generic task which DBAs encounter on a daily basis. Be it restoration of a DEV copy from a prod one or creaing new TEST/QA/UAT environment. Many time such requests require a database to be overwritten by a some backup. In such cases its extremely important to make sure that the [...]

0 comments Read the full article →

Get size of all databases in MB | SQL Server

Thumbnail image for Get size of all databases in MB | SQL Server December 23, 2011

Many times during our day to day operations, a DBA needs to gather info regarding databases that is easy to get for a single database but for multiple database it become s abit of challenge. One similar thing is getting database sizes of all databases on a SQL Server . For a single database sp_helpdb [...]

0 comments Read the full article →

Red Gate Software is Sending a DBA into Space !

Thumbnail image for Red Gate Software is Sending a DBA into Space ! October 14, 2011

Yes , Its true! DBA job could just become the coolest job on planet. Redgate Software has started a competetion to send one exceptional DBA into space.Winning the five week video based quizes will get you seat on a commercial Space Adventures flight reaching 62 miles above the earth, into what is officially space. Red Gate [...]

0 comments Read the full article →

What is Restore/Backup Doing?

Thumbnail image for What is Restore/Backup Doing? September 28, 2011

In SQL Server, a database RESTORE shows just the following rows in the logs :- 2008-01-23 08:38:40.42 spid52 Starting up database ‘dbPerf_MAIN’. 2008-01-23 08:38:40.52 spid52 The database ‘dbPerf_MAIN’ is marked RESTORING and is in a state that does not allow recovery to be run. 2008-01-23 08:38:43.71 spid52 Starting up database ‘dbPerf_MAIN’. 2008-01-23 08:38:46.82 Backup Restore [...]

0 comments Read the full article →

Pluralsight’s On-Demand video tutorials for SQL Server Course (FREE for 48 hours)

Thumbnail image for Pluralsight’s On-Demand video tutorials for SQL Server Course (FREE for 48 hours) April 26, 2011

Thanks to Pinal Dave , I got to know about Pluralsight’s  On-Demand (FREE)  for SQL Server Course . I attended T-SQL I , T-SQL II and T-SQL III sessions and must admit that nothing beats a well structured tutorial by an expert. All of these tutorials are by Dan Sullivan (Follow on Twitter) . The [...]

2 comments Read the full article →

Use database without restoring the backups | Idera Virtual Database

Thumbnail image for Use database without restoring the backups | Idera Virtual Database April 17, 2011

Idera’s Virtual Database is a tool to make a database available from a backup without actually restoring it. Since there is no actual restoration happening – It can be counted as one of  the fastest way to restore a database. A virtual database appears in SSMS as any normal database.In SSMS it is no different than [...]

0 comments Read the full article →

Query Optimization Statistics used by SQL SERVER

Thumbnail image for Query Optimization Statistics used by SQL SERVER April 13, 2011

Recently I came across a user request to create statistics on few newly created indexes. Index names were not provided to use so we had to figure out the indexes created in last 2 days and them create statistics on those indexes.Also, AUTO_CREATE_STATISTICS option was OFF when these indexes were created. I noticed three things [...]

0 comments Read the full article →

← Previous Entries