SQL Server with Mr. Denny


March 1, 2013  6:34 PM

Recommended reading from mrdenny for March 01, 2013

Denny Cherry Denny Cherry Profile: Denny Cherry

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week.

Hopefully you find these articles as useful as I did.

Don’t forget to follow me on Twitter where my username is @mrdenny

.

Denny

February 28, 2013  9:00 AM

Get a discount when attending the SQLPASS BA Conference

Denny Cherry Denny Cherry Profile: Denny Cherry

The SQLPASS BA Conference is coming up in April, just a few short weeks from now.  At this conference you’ll see some of the best and brightest minds in Business Analysis and Business Intelligence all in one conference.  This includes speakers like Stacia Misner, Jessica Moss, Chuck Heinzelman, Joseph D’Antoni, Denny Lee, Cindy Gross, Neil Hambly and many, many more.

The keynote presentations for this conference will be delivered by Steven D. Levitt, Kamal Hathi and Amir Netz.

This conference is going to be full of some fantastic sessions which will help you use technology to find the information in the mountain of data that your company has been collecting. Without knowing how to get access to the information that is within all the data there’s no hope of running business operations at their peak performance.  Don’t forget the full day pre-con sessions where the speaker can really dive into the topic at hand.

Still not sure that you want to attend, the conference has recorded some previews of a few of the speakers and sessions that you’ll be able to see at the PASS BA Conference which you can watch, for free from the comfort of your home or office.

If you’d like another great reason to attend, I’ve got 200 of them for you through a $200 discount on the cost of attending the conference.  Just use the discount code BAC984BL when you register to save $200 off of the cost of this great conference.  So get registered for the conference today.

Denny


February 25, 2013  11:44 PM

SQL Saturday 177 Slide Deck

Denny Cherry Denny Cherry Profile: Denny Cherry

This last weekend I had the privilege of speaking at SQL Saturday 177 in Mountain View, CA.  One of the great things about this SQL Saturday is that in some ways it is an extension of the MVP Summit as for the second year in a row (that I know of) this SQL Saturday has been scheduled the weekend after the MVP summit.  This means that they are able to attack a large number of MVPs from all over the country (and hopefully next year the world) as they all stop by on their way home.  This gives us MVPs a couple of extra days of hanging out and catching up and it gives the attendees the chance to see some speakers that they might not normally be able to get access to.

I gave one presentation this year, and it was a session of table partitioning.  The slide deck has been uploaded to the SQL Saturday site as has the sample code.  You can download it from the session page for my session.

I hope that everyone liked the session, and I hope to see everyone at a future SQL Saturday.

Denny


February 22, 2013  6:03 PM

Recommended reading from mrdenny for February 22, 2013

Denny Cherry Denny Cherry Profile: Denny Cherry

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week.

Hopefully you find these articles as useful as I did.

Don’t forget to follow me on Twitter where my username is @mrdenny

.

Denny


February 20, 2013  2:00 PM

Cleaning Up Reporting Services Snapshots

Denny Cherry Denny Cherry Profile: Denny Cherry

If you’ve been running a SQL Server Reporting Services machine for a long time you may have noticed that your ReportServerTempDB database has filled up quite large over the years with lots of crap.  And it’s just kept going.  This is because sometimes SQL Server Reporting Services may be keeping more Snapshot data than it is supposed to (or maybe it has old stuff from before you limited how much crap it could keep.

In the case of one SSRS instance I ran across recently there were over 40k expired snapshots sitting in the ReportServerTempDB database.  Microsoft does include a stored procedure to get rid of these snapshots, but it only works on a single snapshot at a time, so you’ll need to call the stored procedure in a loop to clean up the extra crap.  This script worked nicely for me.

USE [ReportServer]
GO
DECLARE @return_value int,
@SnapshotsCleaned int = 1,
@ChunksCleaned int,
@TempSnapshotID uniqueidentifier
while @SnapshotsCleaned <> 0
EXEC @return_value = [dbo].[CleanBrokenSnapshots]
@Machine = @@SERVERNAME,
@SnapshotsCleaned = @SnapshotsCleaned OUTPUT,
@ChunksCleaned = @ChunksCleaned OUTPUT,
@TempSnapshotID = @TempSnapshotID OUTPUT
GO

You’ll notice that I’m simply setting the @SnapshotsCleaned value to 1 then running the procedure in a loop until that variable comes back as 0. That variable will only ever come back as 0, 1 or 2 (based on the SQL 2008 R2 version of Reporting Services) but the input parameter is INT so the variable matches that.

In any case, hopefully this helps you clean up your SQL Server Reporting Services ReportServerTempDB databases.

Denny


February 15, 2013  6:03 PM

Recommended reading from mrdenny for February 15, 2013

Denny Cherry Denny Cherry Profile: Denny Cherry

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week.

Hopefully you find these articles as useful as I did.

Don’t forget to follow me on Twitter where my username is @mrdenny

.

Denny


February 11, 2013  7:56 PM

SQL Saturday Albuquerque Slide Deck

Denny Cherry Denny Cherry Profile: Denny Cherry

This last weekend was SQL Saturday Albuquerque (#183) and I had the privilege of speaking at their first SQL Saturday.  I had a great time at the event, and kudos to the event team for putting together a fantastic SQL Saturday.

The session which I presented at SQL Saturday was titled “SQL Server Indexing for the .NET Developer” where I talk to a group of mostly application developers about SQL Server indexes, what they do, and some of the overall best practices for SQL Server indexes.

You can download the slide deck from my site.

If you attended the SQL Saturday I hope that you had as great a time as I did, and if not hopefully I’ll see you at the next SQL Saturday.

Denny


February 8, 2013  6:05 PM

Recommended reading from mrdenny for February 08, 2013

Denny Cherry Denny Cherry Profile: Denny Cherry

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week.

Hopefully you find these articles as useful as I did.

Don’t forget to follow me on Twitter where my username is @mrdenny

.

Denny


February 6, 2013  2:00 PM

When Designing Logon Systems, Pay More Attention To Password Questions.

Denny Cherry Denny Cherry Profile: Denny Cherry

In recent months the Internet has started to wake up to security just a little bit more, and probably forgotten all about it as well (read this, this, this and this if you need a refresher). The big problem that I speak of is those annoying questions that we have to answer when setting up a password for a new high security system. Those questions are supposed to be things that only you know. Which was great 20 years ago when we first started building these systems. Today however for most of these systems I can find out all the answers to these questions between Facebook and Twitter.

Recently I was setting up access to just another high security system and I was presented with this list of questions (I had to select three) as my security questions so that I can get my account back if (when) I forget my password.

Lets review these questions for a minute.  Now some of these Facebook actually asks you to provide them so that they can put them on your profile (that annoying part at the top of your Facebook profile).   The rest you can probably figure out about most people just by looking at the information that they provide during the course of using social media in their daily lives and with the groups on Facebook that they belong to.  You add access to a public linked in profile and a little searching in public records and getting most if not all of these answers shouldn’t take you more than a couple of hours.

As the people that build these applications we need to take more notice of just how easy it is to figure out these questions.  The questions that we are putting into the applications shouldn’t be so annoying as “Favorite Teacher’s Last Name”, which I’ve actually seen but they need to be stuff that is at least a little harder to figure out if these are the things that we are going to use to ensure that people are who they say they are.

Things like drivers license number or state ID number (for those without a drivers license) are a good start.  They don’t change all that often (except when you move between states).  Social Security Numbers basically never change so those aren’t a bad number to use (granted there are other issues with using a persons tax ID here in the US).

When you are designing these sorts of authentication systems, don’t assume that just because your paranoid ass doesn’t upload your entire live to Facebook, LinkedIn and Twitter that no one else does that either.  People do, do that and they will continue to do that.  If you want to actually provide a level of security for your customers, which I sure hope that you do as that is kind of your job, then assume that the customers will be posting the easy to figure out questions online for all to see so you might want to use some slightly more complex questions.

Denny


February 1, 2013  6:04 PM

Recommended reading from mrdenny for February 01, 2013

Denny Cherry Denny Cherry Profile: Denny Cherry

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week.

Hopefully you find these articles as useful as I did.

Don’t forget to follow me on Twitter where my username is @mrdenny

.

Denny


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: