From the category archives:

SQL Server

How to find tables without Primary Key?

Thumbnail image for How to find tables without Primary Key? November 16, 2012

We all know that for better performance, every table should have a primary key.  Here is a short script that will enlist all the tables in a database which do not have a primary key :- Once you have the tables without primary keys, you can decide on the possible candidates for creating a primary [...]

0 comments Read the full article →

A way to set execute permissions on all stored procedures in a SQL Server database

Thumbnail image for A way to set execute permissions on all stored procedures in a SQL Server database November 15, 2012

Very often, we need to grant execute permissions on all SP (Stored Procedures) in a SQL Server Databases. Below is a sample script to get this done for all SP in a databases. This method will grant EXECUTE permission on existing SPs only. A new user defined database role can be created and it can [...]

0 comments Read the full article →

How to start with Microsoft SQL Server 2012?

Thumbnail image for How to start with Microsoft SQL Server 2012? April 14, 2012

Started morning with many good news such as More Good News for SQL Server Developers . The next one came in form of free trainings on SQL Server 2012 from Microsoft – A training that’s complete with webcasts, tutorials and exams. And all of this for FREE. Microsoft Virtual Academy . As first part of [...]

0 comments Read the full article →

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 [...]

4 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 [...]

3 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 →

← Previous Entries