Category Archives: SQL Server

Add a table to an Existing Transactional Replication using T-SQL and Generate Snapshot using T-SQL

Replace the PublishedDB with your published database and TableName with the table name you want to replicate The next step is to start the snapshot agent to pick up the new tables added to replication and replicate across to Subscriber … Continue reading

Posted in Replication, SQL Server, T-SQL Scripts, Transactional Replication, Tricks | Leave a comment

Script to check Job history of a particular job.

Posted in SQL Server, T-SQL Scripts | Tagged , | Leave a comment

Script to get All database file sizes, used and unused space

Posted in SQL Server, T-SQL Scripts | Tagged , , , | Leave a comment

How to realign your skills as a DBA

One of a few things a lot of Data professionals ask me in this age of data overload – How to realign your skills as a DBA. Especially those who are starting their careers or are Junior level DBAs or … Continue reading

Posted in SQL Server, SQL Server 2012 | Leave a comment

Merge Statement for a SQL Server 2000 compatible Database

I have recently been asked if we can write a Merge T-sql to handle inserts and updates in the same statement for a Database on SQL Server 2008 at SQL 2000 compatibility level. The answer is YES and NO; I … Continue reading

Posted in SQL Server, T-SQL Scripts | Tagged , , , , , , | 3 Comments

Database Migration Automated

Its been a while since I posted anything here… Phew… Finishing a very tight deadline and critical Database Migration Project today. I have done myself some justification by automating the Database Migration work, that would otherwise require me to perform … Continue reading

Posted in .bat scripts, LogShipping, Replication, RoboCopy, Setup, SQL Server, SSIS, T-SQL Scripts, Transactional Replication, upgrade | Tagged , , , | Leave a comment

Passed Exam 70-465 : Designing Database Solutions for Microsoft SQL Server 2012

Passed 70-465 : Designing Database Solutions for Microsoft SQL Server 2012 on Saturday the 11th Aug 2012 Watch this space for my next stop i.e., Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

Posted in MCITP, MCM, MCSA, MCTS, SQL Server, SQL Server 2012 | Tagged , , , | Leave a comment

Passed Exam 70-464 : Developing Microsoft SQL Server 2012 Databases

Passed Exam 70-464 : Developing Microsoft SQL Server 2012 Databases Watch this space for my next stop i.e., 70-465 : Designing Database Solutions for Microsoft SQL Server 2012

Posted in MCM, MCSA, SQL Server, SQL Server 2012 | Tagged , | Leave a comment

Passed Exam 70-462 : Administering Microsoft SQL Server 2012 Databases

Passed Exam 70-462 : Administering Microsoft SQL Server 2012 Databases Watch this space for my next stop i.e., Exam 70-464 : Developing Microsoft SQL Server 2012 Databases

Posted in MCM, SQL Server, SQL Server 2012 | Tagged , , | Leave a comment

Send an Email Alert when SQL Server Agent Service Stops/Fails

Here is how you can setup an Alert to send you an Email when SQL Server Agent Server Stops or Fails. As a matter of fact you can do this for any Service you want to Alert on. Open computer … Continue reading

Posted in Alert, SQL Server, SQL Server Agent | Tagged , , | 4 Comments