Browse by Tags

Print vs Select - security through obscurity ?

Now here's an interesting snippet which I'm sure will provoke a few " ... and you didn't know that! " comments. I wanted to take the output from a stored procedure into a table using the insert into mytable exec proc; command but despite my best efforts this just wasn't happening...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 02-10-2010
Windows 2008 build fun and games.

I run a number of test servers at home, these are technically PCs running a server o/s, these currently number 6. I generally build these myself with a base spec of supporting 8GB ram in 4 slots, a minimum of a dual core proc and at least one x16 pci e slot. The latest builds ideally support 16GB ram...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 08-17-2009
How to determine that hardware DEP is available and configured on your computer

Well here we are again with another post I’d been saving up until I resolved the images issue. DEP and how it affects memory on your SQL Server!!! Microsoft KB: 912923 MICROSOFT KB: 875352 ======================================================================================= Notes...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 03-19-2009
NTFS Fragmentation may be more harmful than you think

I’ve posted previously about the adverse affect of ntfs fragmentation and I’ve also mentioned that it is sometimes suggested that fragmentation is not a concern on a SAN. I’ve yet to finish testing this on a SAN, after all you don’t often get a free play with a SAN for this type of testing, but I did...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 03-04-2009
Tracking contention on the SAN - testing Times

One hotly disputed topic on SAN performance is the matter of contention. This may materialise in the fabric due to over subscription or excessive fan in. A fibre channel fabric is a network which connects servers and storage through switches, just like an Ethernet network connects us to the internet...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 01-14-2009
Testing Times 3

( I was on holiday for three weeks so sorry for the delays ) In my previous posts I briefly mentioned the task in establishing a method to benchmark a SQL Server new build or migration. This hasn't been an easy task by any means and I am under pressure not to make any posts based around non disclosure...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 11-23-2008
Testing Times 1

It's an interesting time with being asked to performance test/benchmark a new server setup for a migration of sql server and data centre. Both current and new servers are SAN attached and it has been what is effectively the testing of the storage which has proved interesting. To add to the mix I...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 10-07-2008
When is a number not a number?

Bob Dorr has posted about conversion issues with isnumeric http://blogs.msdn.com/psssql/archive/2008/08/25/isnumeric-returns-1-true-and-i-expected-0-false.aspx?CommentPosted=true#commentmessage This reminds me of a difficult "bug" in an application whereby a lookup actually entered a numeric...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 08-26-2008
Cannot generate SSPI context

Now here's a slightly interesting point about this error. Although the kb does actually mention this reason for the error it is about the last thing on the article, a footnote, and it doesn't specifically word it to cover this scenario, and we all read the entire KB before doing anything - right...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 07-19-2008
Performance Dashboard for SQL 2008

Just in case you haven't seen this http://sqlblogcasts.com/blogs/thepremiers/archive/2008/06/20/sql-server-2008-performance-studio.aspx then have a read. As I actually create dashboards and performance reporting for sql 2000 and sql 2008, and have been for many years, I'm seeing some of my work...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 06-23-2008

Page 1 of 5 (42 items) 1 2 3 4 5 Next >