Subscribe in a reader" />
Welcome to TechNet Blogs Sign in | Join | Help

Andrew Fryer's Blog

Insufficient Data

News

Browse by Tags

All Tags » SQL   (RSS)
SQL Server MVPs
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...
Britain Works
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...
SQL Server, Lies Damn Lies and Statistics
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...
SQLBits Goes West 19-21 November, Newport
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...
No SQL
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...
Free stuff SQL Server Courses & Software
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...
Complex Event Processing
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...
SQL Server BI Community Evening, 10th June, Reading
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...
Learning Bulgarian SQL
  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...
Five Minutes of Fame
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...
SQL Injection, still there after all these years
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...
I didn’t really get the SQL Server 2008 CLR until today.
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...
SQL Server Advent Calendar 13 – Grouping Sets
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...
SQL Server Advent Calendar 2 – Time
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...
SQL Server Advent Calendar 1 – Dates
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...
More Posts Next page »
Page view tracker