Tarun Kumar Jaiswal — Personal, Political and Technical Musings

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

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

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

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 →

Help Stop SOPA/PIPA

January 14, 2012

After reading Jane Wells‘ post on WordPress blog and ‘ Fight For The Future‘ article today, I realized how SOPA act would affect our life and daily work we do. Internet is the most democratic place and Government is trying to own it. The Senate is scheduled to vote on the internet censorship bill on [...]

0 comments Read the full article →

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

0 comments Read the full article →

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

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 →

Steve Jobs’ Vision of the World – Says This Will Be Your Greatest Life Revelation

December 2, 2011

Pay close attention to this video, people. Not because it’s Steve Jobs, but because it’s some of the best advice you will ever get: Steve Jobs giving you his vision of life and how you can make a difference. When you grow up you tend to get told the world is the way it is and you’re [...]

1 comment Read the full article →

CubeStormer II: The Fastest Rubik’s Cube Solving Robot

December 2, 2011

CubeStormer II solves the Rubik’s Cube puzzle faster than the human world record. This ARM Powered robot was designed, built and programmed by Mike Dobson and David Gilday, creators respectively of CubeStormerhttp://youtu.be/eaRcWB3jwMo and Android Speedcuber http://youtu.be/ylFb4pqAUd8. The mechanics are constructed entirely from LEGO, including four MINDSTORMS NXT kits, with the addition of a Samsung Galaxy S II smartphone [...]

0 comments Read the full article →

Spirit Of India | Flash Mob Mumbai – CST

December 1, 2011

200 ordinary Mumbaikars (aged 4-60) come together one busy Sunday evening for the pure joy of dancing. The historic CST station blares ‘Rang De Basanti’ on their speakers while surprised train commuters rush to see whats going on.

0 comments Read the full article →