Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: February 2014

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

1 comments, 65 reads

Posted in Jason Carter on 26 February 2014

SQL Intersection, Spring 2014

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

0 comments, 905 reads

Posted in The Scary DBA on 26 February 2014

Impersonating a server level permission

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

2 comments, 1,222 reads

Posted in SQLStudies on 26 February 2014

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 know quickly when a database had its last backup.

The post Last Backup Times per Database and Backup Type appeared first on .

Read more

0 comments, 34 reads

Posted in Guy Glantser on 26 February 2014

What is HDInsight?

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

6 comments, 544 reads

Posted in James Serra's Blog on 25 February 2014

Write The Perfect Question (Of The Day)

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

0 comments, 988 reads

Posted in SQLAndy on 25 February 2014

Approachable? Sometimes.

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

10 comments, 1,160 reads

Posted in The Scary DBA on 25 February 2014

Reinstall SQL Server Performance Counters

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

10 comments, 1,600 reads

Posted in Ryan Adams on 25 February 2014

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

1 comments, 166 reads

Posted in Guy Glantser on 25 February 2014

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, 59 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

0 comments, 500 reads

Posted in MSSQLFUN on 25 February 2014

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 me rephrase a bit. They're giving away a free month of PluralSight to people who run a bit of code on their SQL Server(2005 and up) for 24 hours.…

Read more

6 comments, 502 reads

Posted in DBA On The Go on 25 February 2014

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

2 comments, 45 reads

Posted in Guy Glantser on 25 February 2014

Lock Escalations

(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

0 comments, 2,206 reads

Posted in Klaus Aschenbrenner on 25 February 2014

Tonight: NYC Metro User Group Presents Kimberly L. Tripp & Jonathan Kehayias

 Tonight: The NYC Metro User Group Presents Kimberly L. Tripp (blog) and Jonathan Kehayias (blog)!

Let's welcome them to NYC!  Now at the NEW NYC Microsoft HQ (see below)

It's time to get some SQLSkills, Big Apple Style!  Just bringing you an update on this special… Read more

1 comments, 532 reads

Posted in Pearl Knows on 25 February 2014

Notes From SQLSaturday #273

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

Read more

0 comments, 188 reads

Posted in SQLAndy on 24 February 2014

PowerShell – Export SQL Data to Excel with Powershell

SQL Server  Export  to Excel with Powershell is very useful for all sorts of activities – ETL and reporting are some examples.
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…

Read more

5 comments, 2,680 reads

Posted in PowerSQL By Prashanth Jayaram on 24 February 2014

The “Perfectly Optimized” Page – #infographics

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

0 comments, 429 reads

Posted in Go Big with Data on 24 February 2014

31 Days of SSIS for SQL Server 2014 Update Question

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

8 comments, 351 reads

Posted in StrateSQL on 24 February 2014

Why I Developed SQL Code Guard: A Fairy Tale from a DBA

A long time ago, in a galaxy far, far away….

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…

Read more

3 comments, 98 reads

Posted in SQL Code Guard on 24 February 2014

Newer posts

Older posts