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,470 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
6,306 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,271 reads
Blogs
Extended Events in Azure Data Studio
I know I can use extended events (xevents) in Azure SQL DB when in...
Azure Workbooks
I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...
SQL Prompt Tips–Using $surroundtext$ in a Snippet
By Steve Jones
A user on the SQL Community Slack was asking about what the $surroundtext$ variable....
Forums
Reduction of installation time of sql server 2008 R2 Express
The installation of SQL Server 2008 R2 Express on a virtual machine takes around...
Creating Aggregates
Comments posted to this topic are about the item Creating Aggregates
Getting Started with DDL statements of Cassandra Query Language
Comments posted to this topic are about the item Getting Started with DDL statements...
Ask SSC