Click here to monitor SSC

2012 February


Simon Cooper

Oh no! My padding’s invalid!

5 comments

Recently, I’ve been doing some work involving cryptography, and encountered the standard .NET CryptographicException: ‘Padding is invalid and cannot be removed.’ Searching on StackOverflow produces 57 questions concerning this exception; it’s a very common problem encountered. So I decided to have a closer look. To test this, I created a simple project that decrypts and […]

28 February 2012 12:33 pm by
Phil Factor

Database Migration Scripts: Getting from place A to place B

2 comments

We’ll be looking at a typical database ‘migration’ script which uses an unusual technique to migrate existing ‘de-normalised’ data into a more correct form. So, the book-distribution business that uses the PUBS database has gradually grown organically, and has slipped into ‘de-normalisation’ habits. What’s this? A new column with a list of tags or ‘types’ […]

28 February 2012 1:00 am by
Grant Fritchey

Tuning Red Gate: #4 of Some

1 comment

First time connecting to these servers directly (keys to the kingdom, bwa-ha-ha-ha. oh, excuse me), so I’m going to take a look at the server properties, just to see if there are any issues there. Max memory is set, cool, first possible silly mistake clear. In fact, these look to be nicely set up. Oh, […]

23 February 2012 5:00 am by
Simon Cooper

Inside the Concurrent Collections: ConcurrentDictionary

3 comments

Using locks to implement a thread-safe collection is rather like using a sledgehammer – unsubtle, easy to understand, and tends to make any other tool redundant. Unlike the previous two collections I looked at, ConcurrentStack and ConcurrentQueue, ConcurrentDictionary uses locks quite heavily. However, it is careful to wield locks only where necessary to ensure that […]

22 February 2012 6:08 pm by
Grant Fritchey

Tuning Red Gate: #3 of Lots

0 comments

I’m drilling down into the metrics about SQL Server itself available to me in the Analysis tab of SQL Monitor to see what’s up with our two problematic servers. In the previous post I’d noticed that rg-sql01 had quite a few CPU spikes. So one of the first things I want to check there is […]

22 February 2012 5:00 am by
Damon Armstrong

SharePoint Scenario Framework

0 comments

I’ve worked with SharePoint for some time now, and I like to think that I know all there is to know about it.  Deep down I know that’s not true, but it’s a fun delusion.  However, I found out yesterday that there is a mechanism in SharePoint called the Scenario Framework that has been around […]

21 February 2012 3:58 pm by
Red and the Community

Red Gate’s on the road in 2012 – Will you catch us?

0 comments

Annabel Bradford, our Communities and Events Manager, tells all about her experience of our 1st SQL Saturday of the year. The first stop this year was SQL Saturday #104 Colorado Springs, back in early January. I made the trip across from the UK just for this SQL Saturday event, and I’m so glad I did. […]

21 February 2012 3:01 pm by
Phil Factor

Normalisation and ‘Anima notitia copia’ (Soul of the Database)

8 comments

(A Guest Editorial for Simple-Talk) The other day, I was staring  at the sys.syslanguages  table in SQL Server with slightly-raised eyebrows . I’d just been reading Chris Date’s  interesting book ‘SQL and Relational Theory’. He’d made the point that you’re not necessarily doing relational database operations by using a SQL Database product.  The same general […]

17 February 2012 6:23 am by
Michaela Murray

ANTS Performance Profiler 7.0 has been released!

2 comments

Please join me in welcoming ANTS Performance Profiler 7 to the world of .NET. ANTS Performance Profiler is a .NET code profiling tool. It lets you identify performance bottlenecks within minutes and therefore enables you to optimize your application performance. Version 7.0 includes integrated decompilation: when profiling methods and assemblies with no source code file, […]

16 February 2012 2:58 pm by
Phil Factor

Curing the Database-Application mismatch

5 comments

If an application requires access to a database, then you have to be able to deploy it so as to be version-compatible with the database, in phase. If you can deploy both together, then the application and database must normally be deployed at the same version in which they, together, passed integration and functional testing. […]

14 February 2012 7:52 am by
Older posts