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,097 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,546 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,918 reads
Blogs
Azure Storage tips
By James-Serra
As a followup to my blog post Azure Data Lake Store Gen2 is GA,...
Managing Agent Jobs on Availability Group Servers
As always, the scripts in this post can also be found on our Git...
Permissions required for row counts to show up on Object Explorer Details
I ran into a rather obscure permissions problem the other day. Since I wasn’t...
Forums
First DW design - advice appreciated
All, Up to this point I've only worked with relational databases. I'm trying to...
Backup Strategy For distributed availability groups
What is the recommendations for backups in distributed availability groups? I have AG setup...
What happens when I drop a huge table with LOBs? will the space be reused?
Thanks in advance for your help. I have a 5TB database with mutliple filegroups. ...
Ask SSC