SQL Saturday 112 Recap

I had the pleasure of attending SQL Saturday 112 this past weekend.  This was my second time speaking at a...

Tips to improve your blog, really!

As I learnt a few things about blogging, I made a list of tips to get better at blogging. Thought...

Use Powershell script to verify backup files

Before restoring backup, we always verify the backup file first, and run the 3 command below:

1. RESTORE HEADERONLY
    Returns a result...

All about Kerberos authentication

http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91-448AB733B1AF/SSRSKerberos.docx

Dell 12th Generation Server Cheat Sheet

Over the past several months, Dell has been rolling out a number of new 12th generation servers that all use...

Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool

Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool

As blogged on “Denali – Day 11: SSMS enhancement” about Features added on...

Don’t You Know Who I Am?

I’m happy to say that for most of you out there, the answer to this question is “no.” That’s as...

MAGICPASS Tonight It’s All About Encryption

http://www.flickr.com/photos/shuck/3971270079/
Tonight I will be live in front of my home town crew at MagicPASS, lead by the one and only...

Quick tip: sp_configure and sys.configurations

In order to query the configuration settings of a server you can run this sproc:
exec sp_configureOn a default install of...

Suggestion: “USE” keyword with Linked Servers

Using special functions for querying and executing commands at linked servers is not very convenient, and sometimes even very problematic.

For...