20 May 2007
20 May 2007

Sorting and case sensitive collations

0
0
This is an addition to my book, on page 255, to the end of the section on collation (before the statement that I won’t delve any deeper into collations, of course :)), I want to add the following bit of information about collations and how they affect sorting and searching.  You can download the entire … Read more
17 May 2007
17 May 2007

Cut-n-paste your code nicely

0
0
One thing that has annoyed me quite a lot lately is the way that cut-n-paste code from visual studio 2005 fails to look nice in emails. Your tabs dissappear you very large line gaps for every new line in your code and it sets the text to be a very strange font. Now maybe it’s … Read more

SQL Compare 6.0 beta – read and sync to and from SQL scripts

0
0
We have just released the first public beta for SQL Compare 6.0. The full version of SQL Compare 6.0 is scheduled for release towards the end of June 2007. For the forum and download information visit http://www.red-gate.com/MessageBoard/viewforum.php?f=65   So what is new in SQL Compare 6.0 beta? SQL Compare 6.0 beta introduces a new data … Read more
10 May 2007
10 May 2007

The ballad of the tuple relation

0
0
I was peacefully pottering away at my workstation, contentedly spawning a daughter thread or something similar, when Robyn popped in. She’d been wrestling with the Grouping Workbench and trying to come up with a copper-bottomed explanation for what the GROUP BY statement does. I’d been trying to help out in my usual arrogant paternalistic way. This … Read more
01 May 2007
01 May 2007

SQL Backup 5.0 has been released

0
0
SQL Backup 5.0 is a major upgrade including a complete redesign of the user interface. What’s new in 5.0? Complete redesign of the UI including a timeline feature for monitoring past backup activity and future backup jobs Integrated support for clusters Reporting across multiple servers using a central reporting database New keywords THREADCOUNT (to get … Read more
01 May 2007
01 May 2007

Welcome to my world…SQL Backup 5

0
0
A year and a little bit ago, I sat down with Tom (head of development at Red Gate) to talk about what was next on the cards after SQL Data Compare. Tom asked that I join Helen and the rest of the SQL Backup team to act as technical lead on a new version of … Read more
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