SQL Server Crossword #5

When there’s something worth celebrating, such as a birthday or achieving the Microsoft Certified Master (MCM) SQL Server certification, I like...

Survey: Are you a SQL Server Professional and running on Mac?

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
I know a...

Be Cautious When Critizing About Guidance

I recently posted some comments about some guidance offered by Microsoft when talking about the CXPACKET wait type. Nothing I...

Connect to SQL Server When Window account Locked Out || Sql authentication(Sa) not configured

Hello Friends,
It’s being a many days I haven’t written anything. But there was lot of stuff I was thinking to...

Normalisation

The purpose of normalisation is to remove redundancy and prevent conflict. 1st Normal Form (1NF) – Every field can have only...

Presentations slides for Best Practices to Deliver BI Solutions

Thanks to everyone who attended my session “Best Practices to Deliver BI Solutions” for Pragmatic Works.  The abstract for my session...

Register for the SQL Server Live! Conference in Orlando Through TheSQLPro.com and Receive a $500 Discount

The SQL Server Live! Conference in Orlando is between November 18-22, 2013. There is a discount code provided for those...

SQL Server – Automating Backup Files Cleanup Task Using Maintenance Plans

Cleaning/deleting the old backup files is equally important as taking the backups. Doing so we can (i) Avoid overhead cost for...

SQL Server 2012 Express installation failed issue

I got an strange error when installing SQL Server 2012 Express

Environment:Window Server 2008 R2 Enterprise + SP1Microsoft Visual Studio 2012 installed.Net...

SQL Training – Introduction to SQL Server Data Tools

Introduction
This document will provide a basic understanding on SQL Server Data Tools (SSDT) and its integration into Visual Studio 2012...