Author Archives: Suleman

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

Run multiple batch files simultaneously in background every 2 seconds

I have been working on developing a custom monitoring tool to monitor Version Store information for Row versioning and snapshot isolation performance on tempdb. Have to run a multiple SQL scripts I developed simultaneously and in background every 2 sec. … Continue reading

Posted in .bat scripts, Tricks, Windows | Tagged | Leave a comment

File *.ps1 cannot be loaded because the execution of scripts is disabled on this system. Please see “get-help about_signing” for more details.

Error:- PS D:\> .\ScriptKeys.ps1 File D:\ScriptKeys.ps1 cannot be loaded because the execution of scripts is disabled on this system. Please see “get-help about_signing” for more details. At line:1 char:17 + .\ScriptKeys.ps1 <<<< + CategoryInfo          : NotSpecified: (:) [], PSSecurityException + … Continue reading

Posted in PowerShell, Uncategorized | Tagged , , | 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