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,...

It’s Time to End Password Reuse

Last week Ebay announced that some accounts were compromised, including passwords with as yet unstated encryption. Those who aren’t tech...