Archives: February 2014
I read a lot of blogs using BlogTrottr as my inbox delivery mechanism, but it has been quite a while since I’ve been cover to cover on a good book, or any book for that matter. My wife calls me a reference reader, I know how to find information I… Read more
I am terribly jazzed to be involved with this amazing event, SQL Intersection. It’s featuring some truly amazing speakers presenting on important topics. It’s being held here on the East Coast, right near the Mouse, the Duck and Dog. This is one of those conferences you need to… Read more
Warnings up front, this has some serious security implications. The method I’m going to use minimizes that somewhat but it’s really easy to shoot yourself in the foot here, so be careful!
Impersonation allows you to grant a user the ability to mimic another user and gain access to all… Read more
This script displays the last date and time of each backup type for each database.
It’s useful when you need to know quickly when a database had its last backup.
The post Last Backup Times per Database and Backup Type appeared first on .
There are two flavors of HDInsight: Windows Azure HDInsight Service and Microsoft HDInsight Server for Windows (recently quietly killed but lives on in a different form). Both were developed in partnership with Hadoop software developer and distributor Hortonworks and were made generally available in October, 2013.
Windows Azure HDInsight… Read more
Have you ever voted against something only to be glad later you got out voted? Too many years ago the idea of a question of the day for SQLServerCentral came up for discussion. I was against the idea not because it was a bad idea, but because it is one… Read more
Deservedly so, I got called out for a bit of attitude I displayed in a recent blog post: Time for a Quick Rant. Steve Hood took the general attitude of “Do this or I will beat you” to task in his blog post The Approachable DBA.
Granted, my… Read more
I’ve had several instances over the last few months where I had to reinstall the SQL Server Performance Counters. It sounds odd to have them magically disappear, but I’ve found a 3rd party monitoring product to be the culprit.
First we need to unload the counters just to make sure… Read more
Let's say you are developing an SSIS package on your dev box to load data from an Excel file to SQL Server. For this example, let's assume your dev box is Windows 7 64-bit with SQL Server 2012, and the Excel version is above 2007 (meaning you're using an "xlsx"… Read more
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 TechNet vorbeischauen, eine Chance haben, poste ich es hier einmal öffentlich:
1) Zum Jubiläumsjahr der PASS Deutschland e.V erhalten alle Mitglieder den „Jubiläums-Rabatt“ von 22 Prozent (!)… Read more
0 comments, 99 reads
Posted in Andreas Wolter SQL Server & BI blog (English / German) on 25 February 2014
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 the index ‘IND_TABLE’ on table or view ‘Table’ is disabled.
REASON : We find that some disable the cluster index due to which issue occur. Clustered index physically… Read more
Let’s say you are developing an SSIS package on your dev box to load data from an Excel file to SQL Server. For this example, let’s assume your dev box is Windows 7 64-bit with SQL Server 2012, and the Excel version is above 2007 (meaning you’re using an “xlsx”… Read more
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)
In todays blog posting I want to talk about Lock Escalations in SQL Server. Lock… Read more
Let's welcome them to NYC! Now at the NEW NYC Microsoft HQ (see below)
- Speaker dinner at Spaghetti Warehouse was packed. Great crowd, not such great service. At 8:45 pm we still had not had a chance to order dinner. With a crowd of 40+ its challenging to get a good venue that can handle the service and provide an environment conducive to networking.…
This post is to Export SQL Data to Excel with Powershell.In this example, a connection is made to a SQL server Instance using DSN and then SQL output…
The “Perfectly Optimized” Page infographic states that there is no such thing as a “Perfect Page”. But don’t be discouraged! Moz.com presents 3 key points to be followed to increase user happiness and outreach.
One important takeaway from this post should be that modern on-page SEO is about juggling competing… Read more
A few years back, I put together a blog series on SQL Server Integration Services (SSIS) titled 31 Days of SSIS. This series focused on a number of lessons learned that I’d gone through with while working with SSIS. That version focused on using SSIS with SQL Server 2008… Read more
About ten years ago, I realized I was spending more than 75% of my business day writing T-SQL code. It was cool – yet awful at the same time! Cool ‘cause I became a ReAl TsQl GuY :) and awful…