SQL Server and Hyper-threading

This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation for them. Licensing is given at the end of...

The New PASS Logo and More

Change is not always easy. In fact, change is hard.
“Change” is a word from which some people shy away, and...

:OUT :OUT darn results!

Years ago I worked for a company that had a rather cool way of handling requests. When we ran the...

Announcing Tuga IT 2017

Its the right time & the right moment of the year to announce the 2nd edition of the ultimate portuguese IT...

Database Clone

There are a bunch of ways you could create a database clone. Backup and restore is one method. Export/Import is...

Delivering workshop at SQLBits 17

Its the end of the another great year (2016) and I already have received an incredible news for the next...

Invoke-SqlCmd and error results

Don’t trust Invoke-SqlCmd and error resultsI love to call Invoke-sqlcmd from powershell but one must beware of the risk of...

New whitepaper with ScaleArc

I’m pleased to announce a new collaborative whitepaper with ScaleArc entitled “Improving uptime and performance of legacy apps on Microsoft...

PASS Board: Year-End Wrap-Up

This month concludes my second full year on the PASS Board of Directors and my first full year on the...

PowerShell : Monitoring and Notification – Disk Space Alerts

“Microsoft Technet Guru – Gold Medal Winning Article- Nov, 2016”

Abstract
Monitoring disk space utilization of server(s) is the critical and important job for...