Click here to monitor SSC

2008 February


Andras Belokosztolszki

SQL Server 2008 CTP6 takes a day off

1 comment

SQL Server 2008 CTP6 does not work on February 29th. Period. On one hand, it is really nice that Microsoft is releasing Community Technology Previews for its latest SQL Server. It helps developers and DBAs to test their solutions and get familiar with the next version of SQL Server. On the other hand, since Microsoft […]

29 February 2008 10:55 am by
Andras Belokosztolszki

Type less in SQL Server 2008 (variable initialization and multiple row inserts)

2 comments

  Among the large number of new features in SQL Server 2008 there are two, almost insignificant features, that I use almost constantly. These are variable initialization and the values clause of insert statements that now accept multiple rows. When playing with SQL one inevitably declares some variables. After the declaration, and as per the […]

28 February 2008 3:34 am by
Tony Davis

How should you layout code?

22 comments

It is strange to see the heat generated over arguments about how code should be formatted. With Visual Studio, of course, it isn’t much of an issue, as it is done for you, but the closer you get to the ‘live free and die’ communities of the LAMP platforms, the more contentious it gets. Likewise, […]

27 February 2008 5:02 am by
Andrew Clarke

Coram magnificos manifeste scalpere nolis …

1 comment

‘Coram magnificos manifeste scalpere nolis Torquendo digitos nares…’ Daniellis Becclesiensis c1200 AD (meaning: Do not pick your nose in front of managers) One of the delights of being Simple-Talk’s subeditor, under the watchful eye of Tony (sir), Anna and Simon, is to interact with our team of regular writers. When I use the word ‘Team’, […]

26 February 2008 10:56 pm by
Richard Mitchell

Serialization – that annoying little problem

0 comments

 As I’ve been doing a bit of work on remoting (see my previous blog post) I’m necessarily looking quite a bit into the serialization of messages. Yesterday I found quite a good article on the CodeProject website with a good set of references about remoting it’s well worth a read. While I’m on the subject […]

21 February 2008 3:04 am by
Andras Belokosztolszki

Can I redeclare a variable in T-SQL? Teaser for SQL Bits

2 comments

Variables in T-SQL behave differently from what people may be used to in languages like C or C#. The scope of a variable is the batch in which it is declared. This may not be intuitive to people who are used to local variables. So let’s look at an interesting example:   DECLARE @counter INT […]

15 February 2008 7:17 am by
Bart Read

The world is once again as it should be

0 comments

Weeeeell… okay, so a cursory glance at today’s news headlines would suggest that to be a rather bold claim, however a few days ago I noticed that The Daily WTF was back to its old self. I’m not the most avid reader, although I do stop by fairly regularly, so I’m not sure when it […]

12 February 2008 8:28 am by
Bart Read

Win one of 10 free copies of ANTS Profiler

0 comments

We’re going to be working on a new version of Red Gate’s award winning performance profiler over the next few months and we need your feedback to make it even better! Respond to the survey at https://www.surveymk.com///s.aspx?sm=AY9BjmF5HBBxhifLo5uQIw_3d_3d, and you will be entered into a prize draw to win a copy of the profiler. It’s dead […]

12 February 2008 5:53 am by
Tony Davis

SQL Server Diagnostics

7 comments

SQL Server diagnostics are a mess. To monitor the well-being of a server, you need to be able to inspect all logged errors, have a whole raft of performance information, WMI data, and be able to study the history of backups and scheduled jobs. You have to monitor server downtime, low disk space, low physical […]

12 February 2008 5:38 am by
Richard Mitchell

Remoting and common classes

0 comments

I’ve been playing a bit lately with .NET Remoting and I must say that so far I’m deeply un-impressed. The documentation seems to be sparse at best and downright misleading at worst. So I thought I’d put a few of my discoveries here so that people can learn from my mistakes. .NET Remoting is a […]

12 February 2008 3:42 am by
Older posts