Browse by Tags
All Tags »
SQL Server (
RSS)
Recursion in Common Table Expressions (CTE’s), how does it work? How can I use it with the adjacency list model (parent / child columns)? In this blog entry I show how recursion works, how to use it with the adjacency list model and talk about other aspects...
Say you have an external file you want to load into your SQL Server database; you need to load – verify – cleanse and insert and at the same time keep a cross reference between the original source file records and the inserted database rows. The OUTPUT...
5th June, Thames Valley Park, Reading sees an Operations Day for SQL Server 2008 for Premier customers only. More information: http://sqlblogcasts.com/blogs/thepremiers/archive/2008/04/27/operations-day-for-sql-server-2008-open-for-premier-customers-only...
This week I'm over in Seattle for the MVP Summit, a number of us UK SQL Server MVP's are out here - myself, Simon Sabin, David Portas, Jamie Thomson, Rob Farley and Satya Jantry. We popped over to see Euan yesterday for a BBQ - I knew things started...
Microsoft Data Warehouse in Depth Joy Mundy & Warren Thornthwaite London, 13 – 16 May 2008 Attend Microsoft Data Warehouse in Depth at Crown Plaza London, May 13-16 to discover how to build a successful business intelligence system using Microsoft...
I found this while researching a blog article; very interesting - I always thought code was put in place to prevent this sort of thing from happening. Only seems to work on SQL Server 2005 SP1. set language british set ansi_defaults off set ansi_nulls...
Ever wanted to take a table, permanent or temporary or a view and just email it straight from SQL where the query result sits in the email as a nicely formatted HTML table rather than that ugly text file attachment you get when using sp_send_dbmail? Ever...
Spent a while today upgrading SQLBlogCasts.com from CS2.0 to CS2007.1 - very simple migration, a few things I'd forgotten to do but up and running now. It's resident on one of my own servers down in Docklands running on SQL 2005 Express. While...
"What tastes better, Microsoft® SQL Server® 2005 or Oracle 11g? What do people think? We're taking the taste challenge to the street. Find out what people are saying about their favorite database. Tast-ay!" Very good, very funny. http://www.databasetastechallenge...
So you are using the @query parameter of sp_send_dbmail and all of a sudden you start getting blocks and your connection running sp_send_mail is the cause, your connection running sp_send_mail just sits there in a runnable state with the lastwaittype...
Got round to sorting the bits out, the session I did at SQLBits Birmingham on 1st March I looked at some of the table expressions available in SQL Server 2005 - Derived Tables, Temporary Tables and Common Table Expressions. I look at the basic framework...
As I draw breath from another busy week I take stock on what a great event last Saturday was - 350 people on the day, tons of positive feedback, throughout the day the whole atmosphere was great - can't wait until SQLBits III. The day did start off in...
I was talking with David Hobbs-Mallyon (SQL Server Product Manager here in the UK - a good guy to know for swag and believe me Simon Sabin and I whipped a load away from yesterday's launch event for give aways at SQLBits (thanks Ellie too!), anyway I...
I was lucky enough to receive an invite to the official UK launch of Windows 2008, VS 2008 and SQL 2008 yesterday in London. Some very good case studies demo'd from a number of folk doing some really great things - to name but two EasyJet and Cambridge...
Hi all, it's been a crazy busy year so the user group took a bit of a back burner for a while - and what with SQLBits roaring success it's been difficult. Both Simon Sabin and Martin Bell are now doing a lot to help me steer the group forward again, Martin...
More Posts
Next page »