Escaping from a runaway Logon trigger

Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon...

Get User In Reporting Services-Question of the Day

Get User In Reporting Services is my newest question to be published at SQLServerCentral.com as a “Question of the Day”....

How Much Value Would a SQLSaturday Certificate of Completion Have?

Note: Posted May 27, 2014, additions posted May 28, 2014 further down.
I think it’s been discussed a time or two,...

NodeXL – Accessible Network Graph Analysis, part 3 (Twitter)

This is the third blog post in the series dedicated to the Network Graph Analysis Tool – NodeXL.

If you are interested,...

SQL Server 2014 Launch Party Mississauga Ontario (Toronto) June 21, 2014

This event promises to be a highlight of the Canadian SQL Server calendar year.

The presenters are all 'first class'.

All...

Webcast Follow-Up: 5 SQL Server Indexing Myths

Similar to yesterday’s post, I have a follow-up for another Pragmatic WorksTraining on the T’s session that I delivered last month....

Attaching All Databases with PowerShell–Finding My MDF Files

I wrote a PowerShell script recently to actually accomplish a task I that I needed. What’s more, this was the...

Database Backup Encryption with SQL Server 2014

A brand new & long awaited feature “Backup Encryption” along with SQL Server 2014. Microsoft reveled this upcoming feature in PASS...

Dealing with SQL Server LOCK resource errors.

I was recently doing some testing that required a fairly large table. I created the test table, and set it...

How Database Mail works in SQL Server ?

Database Mail is email feature in SQL Server from SQL Server 2005 onwards. This feature used for mailing alerts, notification,...