2012 Fall & Winter Conference Sessions

Fall is a busy time for speaking engagements which include user groups, SQL Saturdays and the PASS Global Summit. I'm...

Automated Disk Space Alerts For Windows Server

PowerShell Style
I recently needed to automate disk alerts for each of our servers, to keep it simple I wrote a...

Connection String from Visual Studio

Querying Microsoft SQL Server : Connection String from Visual Studio: Connection String: A connection string contains connection information need to connect...

Data Types in SQL Server

Querying Microsoft SQL Server : Data Types in SQL Server: Data Type Description Remarks BIGINT Used for large Integer data.(Range -2^63 ...

Error Handling in T-SQL

 Error Handling in T-SQL: Error handling in T-SQL: Error handling in T-SQL is similer to other programming languages as C#,C++,Java.A...

Functions in SQL Server

 Functions in SQL Server: Functions in SQL Server In SQL Server functions are subrotienes that encapsulate a group of T-SQL...

Vacation and SQLSat149

When I was considering submitting some sessions to SQL Saturday 149 in Minnesota I thought I would have a difficult...

VMware vSphere 5.1 vCenter Data Protection Funny

VMware, why won’t you allow special characters in your root password?

Tweet

Welcome to Everday SQL

My name is Patrick Keisler and I have been a Microsoft SQL Server DBA for over 12 years.  During that...

Create Database Script

I always try to enforce standards across all the SQL Servers I manage, it makes tons of administrative tasks much...