Monthly Archives: June 2016

“If you could give a DBA just one piece of advice, what would it be?”

“If you could give a DBA just one piece of advice, what would it be?” For those of you hunger to learn and explore your skills you may read the book DBA Jump start  This book contains advice from most … Continue reading

Posted in Database Administration | Leave a comment

Export and Import the database objects using BACPAC file

In this post i will be explaining about how to export the database objects to backpac and import from bacpac file. Connect to SQL Server , Right click on the database and Go to Tasks –> Export Data Tier Application   2. Introduction … Continue reading

Posted in Database Administration | Leave a comment

Different ways to Monitor Deadlocks

Every database environment, deadlocks are common problems and it is important for DBA’s to monitor deadlocks and make sure to prevent them from reoccurring. There are multiple ways to monitor deadlocks Using Trace Flags  We can enable two trace flags 1204 … Continue reading

Posted in Database Administration, Deadlock, Uncategorized | Leave a comment

SQL Server 2008 SP4 and SQL Server 2008 R2 SP3 now available in Microsoft Update Catalog

SQL Server 2008 Service Pack 4 and SQL Server 2008 R2 Service Pack 3 were the last service packs for both versions respectively and they are now available on Microsoft Update Catalog. Refer Original Post: Click Here  References: SQL Server 2008 … Continue reading

Posted in Database Administration | Leave a comment

Find Missing Backups and send email notification

This is another useful script to find missing backups and send email notifications to DBA Cheers Hope you like the post! Ramasankar Molleti LinkedIn: LinkedIn Profile Twitter: Twitter

Posted in Uncategorized | Leave a comment

Free SQL Server 2016 Developer Edition

Earlier this month, Microsoft announced the general availability of SQL Server 2016 for Windows and Windows Server.  You can get started today with SQL Server 2016 Developer Edition, which is free and has all the features and capabilities of Enterprise Edition … Continue reading

Posted in Uncategorized | Leave a comment

Script to find failed sql agent jobs and notify via email

This is one of the useful script to check and find failed jobs on sql server every day and send notification via email.   Cheers Hope you like the post! Ramasankar Molleti LinkedIn: LinkedIn Profile Twitter: Twitter  

Posted in Database Administration, T-SQL | Leave a comment