Tag Archives: mssql

SQL Drill – Excel Add-In for building and running SQL queries

Posted on March 16, 2012 by Stephen

About SQL-Drill Building complex SQL queries for a particular database can take some time and effort. SQL-Drill is a simple Excel Add-in which can connect to a SQL Server or MySQL Database, show all the tables, and allow you to … Continue reading →

Posted in Uncategorized | Tagged , | Comments Off on SQL Drill – Excel Add-In for building and running SQL queries

Allow Domain Admin to Login to SQLServer & have full Access

Posted on January 1, 2012 by Stephen

For some reason when SQLServer 2008 was installed/setup, admins were not added. Therefore when trying to login via SQL Management Studio, an error was obtained: Login failed for user “username”. (Microsoft SQL Server, Error: 18456) I also didn’t know the … Continue reading →

Posted in IT | Tagged | Comments Off on Allow Domain Admin to Login to SQLServer & have full Access

Find all MSSQL Instances running, Connect and show Version

Posted on January 1, 2012 by Stephen

The diagram below, shows how you can use SQL Management Studio to connect to all instances of SQLServer running on your computer (as indicated in the Services list) and run a simple query to find out the exact version and … Continue reading →

Posted in IT | Tagged | Comments Off on Find all MSSQL Instances running, Connect and show Version

SQL Activity Monitor – Debug high CPU Usage for SQL Server

Posted on January 1, 2012 by Stephen

START -> All Programs -> Microsoft SQL Server 2008 R2 -> SQL Server Management Studio Connect as normal and right-click on the SQL Server (top left) and go “Activity Monitor”. The Activity Monitor will show the queries been run, the … Continue reading →

Posted in IT | Tagged | Comments Off on SQL Activity Monitor – Debug high CPU Usage for SQL Server