Monthly Archives: April 2014

Session reset – Log off other user on remote server

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

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

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

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

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

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

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