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

Languages of Big Data Apache Hadoop

Languages of Big Data
Big Data is here and rapidly growing.  If you are just starting to learn about Big Data...

Last Weeks Top “Reading” Links #85

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

Microsoft’s free virtual labs

If you have spent any time looking around my site, you will notice that I love study materials and in...

NodeXL – Accessible Network Graph Analysis, part 2

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

If you are interested,...