30 April 2007
30 April 2007

We’re going on a bug hunt

0
0
One Monday lunchtime not so long ago we ran a bug hunt for SQL Backup 5. During the hour and a half session 12 participants (all willing Red Gate employees) paired up to try and break the application with the promise of wine and chocolates for the ‘most interesting bug found’. This was by far … Read more
18 April 2007
18 April 2007

Too Much HR, Not Enough Guts and Glory

0
0
At some point in a DBA’s career, assuming he or she has had the mettle to withstand the onslaught of mediocrity and ineptness in its various forms (I may qualify this bold statement in a future post), there comes a time when said DBA is asked to manage other DBAs.  This “management” includes mentoring, coaching, training, … Read more
15 April 2007
15 April 2007

At Half-past three, it’s time for tea…

0
0
‘Look, see what I mean?’, the manager said, as a dishevelled DBA stumbled past his pig pen grunting inconsequentially to himself. ‘Good morning’, said the manager to him, forcing a beam from ear to ear with a rather strained Bonhomie The DBA gave an extra-loud grunt, his pale puffy face turned to stare balefully at … Read more
09 April 2007
09 April 2007

sp_helptext squared

0
0
As I sat at my desk, like most days, pondering what a partial database restore truly is in regards to object-level restores and filegroups and noting that though this sentence will go on longer than I intended I will not finish it prior to finishing the initial thought, my phone rang and the question came … Read more
03 April 2007
03 April 2007

SQL Server Search Macro (plus build your own directed search!)

0
0
Microsoft has built a little site for searching the books online on the web (which gives you links that are more readily shared with others): http://search.live.com/macros/sql_server_user_education/booksonline That is nice, but what is nicer is that you can create your own search macros and save them.. Just click the “create your own search engine” and go … Read more
03 April 2007
03 April 2007

That makes a lot more sense now

0
0
I’ll admit it, I never really got the yield statement in C# before today. However there’s a very good article I’ve just read on msdn that takes you through it step-by-step. It’s certainly an interesting read and with luck will help you out when you really really need it. Have a look…http://msdn2.microsoft.com/en-us/vcsharp/bb264519.aspx On an aside, … Read more
29 March 2007
29 March 2007

Grayscaling transparent gifs and pngs

0
0
I find that I end up custom painting a lot of the controls in Red Gate products, this is normally due to some gripe from our usability engineers – I was doing this today and wanted to gray scale some of the pngs when I need to show them disabled – This normally means loading up … Read more
28 March 2007
28 March 2007

Kill or Be Shamed

0
0
Every tidbit of knowledge gleaned over years of working with a product comes at a price and that price is sometimes shame at not having known such slacious info beforehand. So it is with shame I admit that today I learned something I suspect I should have known. I run the risk of criticism of my … Read more
28 March 2007
28 March 2007

Powerpoint Pointlessness: You read it here first!

0
0
Professor John Sweller, from the University of New South Wales School of Education, first came up with ‘Cognitive Load Theory’ in the 1980s. Most of his reasearch has been in the effectiveness of current teaching techniques. He has now produced evidence that PowerPoint presentations are impossible to take in if the information on the screen is the same … Read more
26 March 2007
26 March 2007

Mass Produced Beer and SQL

0
0
I was on vacation last week. Ok, you may call it Holiday…but with four kids in tow to Orlando, FL to spend as yet un-tallied sums of cash, it is hard to call it relaxing.  The trip did afford me the ability to see the convention center in Orlando, the designated focal point of the upcoming … Read more
23 March 2007
23 March 2007

SharePoint Permission Names

0
0
SharePoint 2007 has a new control called the SPSecurityTrimmedControl.  It’s a container control that allows you to hide or display a section of your page depending on whether or not the currently logged-in user has the appropriate permissions.  To set the permissions, however, you need to know what SharePoint calls the permissions.  Took a little … Read more
23 March 2007
23 March 2007

**SQL Prompt 3.1 Released**

0
0
We are very pleased to announce that SQL Prompt 3.1 has now been released. You can download it from: http://www.red-gate.com/products/SQL_Prompt/index.htm The most notable addition is support for SQL Server Management Studio Express Edition, however even if you don’t use this version of Management Studio we’d recommend the upgrade so you can take advantage of the … Read more
22 March 2007
22 March 2007

Twiddling the knobs: The Default Backup directory

0
0
Whenever I attempt to set myself up as an expert on anything,  a Higher Being seems to belabour me with a metaphorical baseball bat for my lack of humility. In consequence, this Blog entry is really more of a question than a nugget of information. How does one change the default backup directory for a server by using … Read more
16 March 2007
16 March 2007

Exciting New .NET Language Features

0
0
If you haven’t already, check out Scott Guthrie’s blog about Extension Methods that will be available when the next version of the .NET framework.  It’s always cool when they add a completely new feature because it opens up more options for really elegant solutions.  And it also opens up new ways for people to really … Read more