Uploading Files to an HDInsight Cluster (No Scripting Required)

As I noted in my first post, I am not a fan of scripting. In that post we set up...

Use FILEPROPERTY to find free space in all the database

The use of SpaceUsed property of the FILEPROPERTY function gives how much space is used also we can derive lot...

Assigned reading: FREEPROCCACHE

I don’t often find myself blogging for the sole purpose of showing you someone else’s blog, but today is one...

Catch up with T-SQL Tuesday

T-SQL Tuesday is a monthly blog party where we get an invitation the first week of the month to write...

Pulling data from the error log

The other day I was asked to pull a list of errors from the SQL Server log into a table...

Query cost and Query Execution time - Difference

This post is my 100th post 🙂 Was inactive in blogging for few years in between. Now back in full flow....

SQLSaturday & The Speaker Wait List

When a new SQLSaturday event is launched an email is sent to all the speakers who have opted in to...

The Log Chain

I ran across a question recently from someone that received a similar message to the one showed in this image:

In...

Above All, Good Judgment

What is permissible is not always honorable. – Marcus Tullius Cicero
Rules. Best practices. Guidelines. Design patterns. Policies. All are good and...

Compressing Outcomes

You find yourself cruising along, just doing your thing as a database administrator. Then the CIO plops down into a...