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

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

PolyBase explained

PolyBase is a new technology that integrates Microsoft’s MPP product, SQL Server Parallel Data Warehouse (PDW), with Hadoop.  It is designed to...

Spezialrabattaktionen: 22% zum Jubiläumsjahr der PASS Deutschland e.V für Sicherheits- XEvent Tracing, sowie SQL Server 2014 Seminare + 10% Microsoft TechNet Aktion für alle

Damit auch alle, die vor 2 Wochen nicht auf der SQL Konferenz in Darmstadt (www.sqlkonferenz.de) waren, oder nicht regelmäßig bei...

The CASE Statement and Performance

In case you don’t know, this query:
UPDATE dbo.Test1
SET C2 = 2
WHERE C1 LIKE '%33%';Will run quite a bit slower than this...