Virtual Lab – Setting up a new VM

This is part of a series where I set up a virtual lab for testing and misc. work. The other...

Acadiana SQL Server User Group - Introduction to SQL Server Security Principals and Permissions

Great crowd last night and a great job by organizers Glenda Gable and Jill Joubert for the very first meeting...

Colorado SQL Events for March 2014

SQL Meetings are training events for SQL Server professionals and those wanting to learn about SQL Server. Please note that...

Last Backup Times per Database and Backup Type

This script displays the last date and time of each backup type for each database.
It’s useful when you need to...

SSPI Handshake Failed

A fellow community member sent me an email saying he was having trouble authenticating with Kerberos.  Here is the error...

Tell Me How I’m Doing: A Fable About the Importance of Giving Feedback

I read a lot of blogs using BlogTrottr as my inbox delivery mechanism, but it has been quite a while since I’ve...

Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

When I right click on the database diagrams folder in SSMS to create new diagram. Following popup window open with error.

Solutions:
From the Message you can clearly see that the...

ERROR || The query processor is unable to produce a plan because the index ‘IND_TABLE’ on table or view ‘Table’ is disabled.

Table with clustered index is totally depended on index accessibility.
ERROR : The query processor is unable to produce a plan because...

Free Month To PluralSight!

Free Month of PluralSight!
Ok, personally this is pretty cool. www.SQLSkills.com is giving away a free month to pluralsight! Well, let...

How to Load Data from Excel in SSIS – 32-bit vs. 64-bit

Let’s say you are developing an SSIS package on your dev box to load data from an Excel file to...