Use this VB script to check SQL Server connectivity. You can add N number of SQL Server instances to verify its status.
Last month Ive wrote an article on Performance Data Collector part one, I thought of writing part 2 soon however I was stuck with Organizing SQL Code Camp with my fellow MVP Deepak & Sugesh. Now its almost a month so thought of writing the second part. In this part we are going to see… Continue reading Performance Data Collector
Performance Data Collector is one of the new features thats accompanied from SQL Server 2008. If you are a DBA , you know its very hard to get performance data from necessary inputs. We will get the data from Perfmon (system monitor), profiler, DMV etc and correlating this data is very hard, implementing the same… Continue reading Performance Data Collector
In this article we are going to discuss about installing SQL Server 2008 R2, I know Im little late as R2 is released last month. Before we stepping into installation make sure you have necessary hardware and software requirements, check http://technet.microsoft.com/en-us/library/ms143506(SQL.105).aspx this KB article for the same.
I was thinking about writing a script to capture the objects that were either CREATED/DELETED or MODIFIED in the last 24hrs. Instead of directly querying the sys.objects I from where I can only get minimal information I decided to get a whole bunch of useful information using the SQL Server default trace. By default the… Continue reading Recent Objects – Without Triggers