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
8,312 reads
Derek Colley
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
4,886 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
6,960 reads
Blogs
Daily Coping 2 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Presenting on Ethics in Modern Data at Houston HASSUG/SQL BI Group July 2020 Meeting
By Will Assaf
Looking forward to presenting with my wife Christine Assaf our talk on Ethics in...
MVP for Another Year 2020-2021
By Tim Radney
Early this afternoon I received an email from Microsoft presenting me with the 2020-2021...
Forums
Expression expression runtime failure in SSIS
Hi Team, I have the following expression in ssis and the value of @[User::ExecutionId]=12dfg...
Daily Coping 2 Jul 2020
Today’s tip is share a happy memory with someone who means a lot to...
Query taking more than 4 hrs. - Any recommendations/suggestions?
One of our stored procs has been running for more than 4 hrs. and...
Ask SSC