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

Archives: November 2012

NY SQL Server User Group Meeting - Bill Pearson

Thursday, November 29, 2012, brings us the November meeting of the NY SQL Server User Group, with BI expert, SQL MVP and Author William E. Pearson III, aka, Bill Pearson.  Bill has quite an impressive collection of writings on the topic of BI, Data Warehousing, Analysis Services, MDX,… Read more

0 comments, 1,208 reads

Posted in Pearl Knows on 28 November 2012

Significant Achievements

As a few of you know, I took the Microsoft Certified Master (MCM): SQL Server 2008 lab at this year’s PASS Summit.  Now, I’ve been working on this certification for a while.  With the knowledge exam, I failed before retaking and passing.  A couple months later, I took the… Read more

10 comments, 408 reads

Posted in StrateSQL on 28 November 2012

HDInsight: First Pass

I installed HDInsight with no errors. The install is so brain-dead, I couldn’t see how there could be errors. But, I decided to fire up the service to start playing with it. That’s when I hit the errors. First up, I was getting logon errors for the Hadoop service itself.… Read more

0 comments, 515 reads

Posted in The Scary DBA on 28 November 2012

The Last DBCC CHECKDB Date and Restores

I ran across a question on Twitter recently where someone asked about the DBCC CHECKDB date after a restore. For those of you that don’t know this, you can run this command on your instance (in a database)

DBCC DBINFO WITH tableresults;

This returns a lot of information, but… Read more

1 comments, 1,533 reads

Posted in The Voice of the DBA on 28 November 2012

New Toy: The Brydge iPad Keyboard – Updated

Finally a REAL keyboard for my iPad!

I can’t tell you how long I’ve wanted a real keyboard that my iPad could dock with easily. I have always hated lugging around a laptop everywhere to do any real typing. When I got the first iPad I really thought it was… Read more

3 comments, 674 reads

Posted in SQL Man of Mystery on 28 November 2012

How To Download Free Sessions From PASS

For all members of the Professional Association for Server (PASS), are you downloading slides and videos from all sorts of great PASS events?  If not, what are you waiting for … an invitation?

Ok, here it is.  I invite you to download like a madman!  (How a madman… Read more

1 comments, 2,128 reads

Posted in Kevin E. Kline on 28 November 2012

WIT Wednesday

On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call to discuss and plan upcoming WIT activities, be it SQL Saturday WIT panels or the WIT luncheon at the annual PASS Summit. To help promote women in technology, I’m declaring… Read more

0 comments, 441 reads

Posted in Cleveland DBA on 28 November 2012

Differential Restore Fail

We have all heard that backup is not complete until you test it by restoring it.  We also know that part of a DR plan involves the testing of those backups through restores.

I recently had the opportunity to run through a test scenario and ran into a substantial failure.… Read more

8 comments, 1,048 reads

Posted in SQL RNNR on 28 November 2012

A Rickety Stairway to SQL Server Data Mining, Part 0.1: Data In, Data Out

                 In the first of a series of amateur tutorials on SQL Server Data Mining (SSDM), I promised to pull off an impossible stunt: explaining the broad field of statistics in a few paragraphs without the use of equations. What other SQL Server blog ends with a cliffhanger like that?… Read more

0 comments, 3,402 reads

Posted in Multidimensional Mayhem on 28 November 2012

should I use clustering on a VM?

ok, I'm going to keep this high level and simply share my opinion.

I am not prescribing anything.

If you want prescriptive advice, read Allan Hirt (that's what I do) and go to #sqlhelp.

read more Read more

0 comments, 498 reads

Posted in @chuckboycejr on 28 November 2012

One Interview question. Many Answers

Conducting technical interview is an art.

Most likely I would start a discussion with simple questions like "What is your favourite topic in SQL Server?" .

here are some open ended questions that could be answered in 10 seconds or may lead to an hour long interesting discussion.

1. I have created a Non Clustered Index to improve a query… Read more

1 comments, 2,035 reads

Posted in LivingForSqlServer on 27 November 2012

SQL Server 2008 Diagnostic Information Queries (Nov 2012)

Here is the November 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to a couple of the existing queries. To go with it is an updated, blank 2008 results spreadsheet, where the tabs in the spreadsheet are labeled and in…

Read more

0 comments, 724 reads

Posted in Glenn Berry's SQL Server Performance on 27 November 2012

Querying Performance Counters in SQL Server

In a previous post, there was a comparison between sysperfinfo and sys.dm_os_performance_counters which included the use of a simple query.  The query just returned the contents of the dynamic management view, but didn’t provide the data from the view in a manner that immediately useful for all performance counters.

The… Read more

0 comments, 3,425 reads

Posted in StrateSQL on 27 November 2012

Billing rates – other side of the fence

The following is a guest post by Tim Morgan from Sullexis in response to a resent blog of mine:

Thanks for letting me reply to your last post, “Should a placement firm tell you what they are billing the client?“.  This question has been around for many years… Read more

6 comments, 852 reads

Posted in James Serra's Blog on 27 November 2012

Unused Indexes


A sound indexing strategy is paramount to performance in an OLTP system.  Not having the correct indexes in place can cause unnecessary reads placing additional overhead on, among other things the IO subsystem.  Having said that indexes that are in place but never used cause unnecessary writes during…

Read more

3 comments, 1,464 reads

Posted in SQL Server 365 on 27 November 2012

What’s the deal with Excel & SSIS?

When it comes to importing data from an Excel sheet with SSIS, Excel has quite a reputation. And not a terribly good one. Well deserved, to be honest, because numerous issues can rise when dealing with this piece of software. This blog post will deal with the issue I encounter… Read more

10 comments, 485 reads

Posted in Koen Verbeeck on 27 November 2012

Time Pass With Transaction Log - Part 5 INSERT

 In this article We are going to INSERT a record in a simple table and try reading Transaction log record.

Note: This article is incomplete. I could not interpret lots of Hex values (no clues) and also you can expect inaccuracy in interpreted values.

USE MASTER
GO

-- Drop this… Read more

4 comments, 1,549 reads

Posted in LivingForSqlServer on 27 November 2012

Are Your Protecting Your DB Backups?

Folks have cited the recent InformationWeek article on how South Carolina's Department of Revenue was hacked because the SC state government basically said, "It's the IRS' fault for not telling us we should encrypt social security numbers." I'm not going to touch that. It stands on its own for its foolishness.… Read more

1 comments, 1,682 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 27 November 2012

Help Bring #SQLFamily to Fargo, North Dakota

Did you know that a SQL Saturday in Fargo is in the works?  If not them, hey… there’s a SQL Saturday coming to Fargo.  And it’s happening this coming spring on April 27!

Now what’s the big deal about Fargo, you might be wondering.  Well, it’s one of the… Read more

2 comments, 662 reads

Posted in StrateSQL on 26 November 2012

Newer posts

Older posts