Archives: November 2012
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
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
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
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
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects. You can find a list of all of the deprecated views in the introduction post.
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
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
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
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
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
ok, I'm going to keep this high level and simply share my opinion.
I am not prescribing anything.
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
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…
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
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
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
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.
-- Drop this… Read more
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, 2,208 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 27 November 2012
Now what’s the big deal about Fargo, you might be wondering. Well, it’s one of the… Read more