Browse by Tags
All Tags »
SQL (RSS)
The best thing about working with SQL Server is working with the other people that use it. The SQL server experts who do most for their colleagues in the community are recognised as MVPs, so not only do they know their stuff they are willing to
Read More...
I sat watching Dave the other night and there’s a bit in it where Kevin Kline simply states that he wants to give everyone in America a job that wants one. I’m not sure if our the MD of Microsoft, Gordon Frazer has seen this, but he’s just announced
Read More...
I see Oracle have published a couple of papers recently on how easy it is install, configure and manage Oracle 11g vs SQL Server and DB2. The work was commissioned from the Edison Group and the paper on the Oracle / SQL Server comparison is available
Read More...
When I am not doing the day job I like to draw and paint to relax so I have combined a bit of business & pleasure for the SQL Bits Goes West conference by doing a few cartoons for them… As you can see the event has grown to three days. While
Read More...
One of the fundamental dichotomies in development is the relational world of the database and the object orientated world of services, which sadly spills over into developers and DBA’s not always being the best of friends. Developers don't always
Read More...
I knew that there were a few course on SQL Server 2008 on the Microsoft training site : Course 2778A : Writing Queries Using Microsoft SQL Server 2008 Transact—SQL Course 6231A : Maintaining a Microsoft SQL Server 2008 Database Course 6232A : Implementing
Read More...
Life isn’t fair, Microsoft bring out some new fangled gizmo, but I needed it five years ago. Back then I was working for several utility companies who were managing such things as water quality & half hour electricity meter readings for large customers.
Read More...
I wanted to call out the BI evening on 10th June because they’ve given me a slot to talk about SQL Server 2008 r2 and specifically the BI features you can expect. There’s also sessions on Data Modeling and information architecture from Alex
Read More...
I am presenting in Sofia for a few days at Microsoft Days 09 and I don’t speak any Bulgarian! Fortunately Microsoft and English seem to go hand in hand, and I have been sitting in on sessions about Windows 2008 r2 and SQL Server when I am
Read More...
Speaking at SQL Bits is a cool thing to do but may terrify many of you. Part of this is that you are on stage for an hour and that means a lot of preparation, both content and rehearsal. So one of the organisers, Martin Bell has come up with
Read More...
Security is a thankless task, your best work goes unnoticed and if you let down your guard for a minute you can be front page news, like the Daily Telegraph (interestingly on the Guardian web site ). In this case the method of attack is old chestnut,
Read More...
By a strange quirk of fate I have not really had to do too much with CLR functions in SQL Server until I started hanging out on Twitter. Then I saw this question.. “How do I remove non-numeric characters from a VARCHAR?” Easy I thought until I realised
Read More...
Day 13 of my virtual advent calendar, about stuff I like in SQL Server 2008.. The SQL Group by clause has been around since I can remember, but in SQL Server 2008 we know have grouping sets. Imagine you wanted to sum sales amount from the adventure
Read More...
Day 2 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Following on from my previous post, in some data warehouses there is a separate dimension for time of day, so that demand through a day can be modelled. Storing time in SQL server
Read More...
There is no possible connection between databases and Christmas, so I simply wanted to share 24 my favourite bits and bobs that are in SQL Server 2008…. The new date data types in SQL server crack a problem I have had since I started BI as there is (nearly)
Read More...
Subscribe in a reader" />
