Monthly Archives: April 2014

Session reset – Log off other user on remote server

Posted on April 29, 2014 by

It is always a good practice to log-off session from remote server after completing the work. At times users miss to log off their session from Windows remote server not allowing other users to login into the Server. You may … Continue reading →

Posted in Network, Productivity, Windows Server | Tagged , , , , , | Leave a comment

Knowledge Share 2014-04

Posted on April 24, 2014 by

In SQL Server 2014, you can have 8 secondary replicas, it was 4 in SQL 2012 Ref: What’s New (DB Engine) SQL Server 2014 – http://msdn.microsoft.com/en-us/library/bb510411%28v=sql.120%29.aspx#DataFiles What is Cardinality Estimation? This is new feature in SQL Server 2014: The cardinality … Continue reading →

Posted in knowledge, Productivity, SQL, sql2014 | Tagged , , , , , , , | Leave a comment

How to send sql mail from personnel account

Posted on April 24, 2014 by

In this blog, I am would like to explain the setting required to configure SQL mail to send SMTP mails using live.com account. For additional information about the configuration, please refer: http://windows.microsoft.com/en-US/windows/outlook/send-receive-from-app You may use different accounts to send the … Continue reading →

Posted in Productivity, SQL | Tagged , , | Leave a comment

Long running job monitor – Alert

Posted on April 17, 2014 by

I have created this script which will monitor long running jobs and alerts the analyst. One advantage of this custom script is to find threshold dynamically using job history! – Vijred

Posted in Productivity, Script, SQL, SQL Query | Tagged , , , , , , | Leave a comment

SQL-dependency analysis-Identify impacted modules

Posted on April 15, 2014 by

I am sharing this script which will help during dependency analysis! One of the table needs to be updated in my database, I had to identity all the Views/ Functions/ Procedures along with the usage stats which will be impacted … Continue reading →

Posted in Productivity, Script, SQL, SQL Query | Tagged , , , , , , , | 3 Comments

SQL Server Deadlocks

Posted on April 10, 2014 by

I had been talking about deadlocks few hundreds of times, worked on it few tens of times, questioned in most of the interviews. I will give an attempt to document Deadlock basics in this Blog! By Wiki definition, deadlock is … Continue reading →

Posted in Productivity, Script, SQL, SQL Query | Tagged , , , , | Leave a comment

SSIS – Connection Manager – Dynamic Connection string – Connection String with date and time

Posted on April 3, 2014 by

This Blog explains how to dynamically generate Connection string! I had a requirement to push the data to a file in specific folder but the file name should contain Date and Time. To address the requirement, I had to generate … Continue reading →

Posted in Productivity, SQL, SSIS | Tagged , , , , , , , | Leave a comment