CPU and Scheduler Performance Monitoring using SQL Server and Excel
This article will demonstrate a method of creating an Excel-based CPU/scheduler performance dashboard for SQL Server 2005+.
2012-10-04
9,187 reads
Derek Colley
- Interests: SQL Server
SQL Triggers in a Security Context
This article will show you how to use user-defined triggers to supplement your security policies, preventing unauthorised data manipulation and blocking unfriendly logins.
2012-07-12
5,963 reads
Three Attack Vectors in SQL Server 2005
This article outlines three different tried and tested methods of obtaining access to databases in SQL Server 2005 where no database-level administrative access exists.
2012-03-07
7,171 reads
Blogs
Daily Coping 30 Sep 2022
By Steve Jones
Today’s coping tip is to find a new way to use one of your...
Why You Need Presentation Skills
And no, the answer is not because you want to be a Microsoft MVP....
Daily Coping 29 Sep 2022
By Steve Jones
Today’s coping tip is to avoid saying “I should” and make time to do...
Forums
Save Query Results to Excel and Automatically run it
Hello, I have a very simple query Select * from Employees where company...
TCP Provider: A connection attempt failed for target server
Hi. In source SQL Instance target linked server has been created and connection tested...
Get Part number and display in Header
Hello, so I have a part number, and I want to display it in...
Ask SSC