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

Upgrading Packages to SSIS 2012

Many of you may now or in the future have the need to upgrade your SSIS packages to the new...

Ad hoc query optimization in SQL Server

When ad hoc queries are executed in sql server, if it is executed without parameters, and it is simple,  SQL...