The Bit Bucket (Greg Low)

Book: Refactoring SQL Applications - Stephane Faroult

2009-07-03T04:58:00Z

I've had a number of people tell me over the years that they aren't surprised when I say "Recommended" at the end of any book review I write, as I never seem to say "Not Recommended". I suppose that comes under the heading of "if you can't say anything good about something, don't say anything". So, I'm going to temporarily change tack with this book. For a long time, I've wished there were more books tackling the thorny topic of refactoring databases. Most people would consider Scott Ambler's book...(read more)

Book: SharePoint 2007 How-To - Ishai Sagi

2009-07-03T04:53:00Z

If you're working with SQL Server, chances are pretty high that you already realise that your future involves SharePoint as well. Fellow Australian MVP Ishai Sagai recently sent me a copy of his new book SharePoint 2007 How-To . I have to say I really enjoyed it. It does exactly what the title suggests. I haven't read any other books in the "How-To" series before but I liked the format. Ishai spends a little time with SharePoint basics and then presents a series of chapters on the main aspects of...(read more)

CodeCampSA (Adelaide) is on again this year

2009-07-01T03:47:00Z

One of the smaller events I try to get to each year is the Code Camp that happens in Adelaide ( www.codecampsa.com ). It might be smaller but I always enjoy it and I'm sure that Peter Griffiths and David Gardiner will be putting on a good show again this year. I'd love to see as many of you there as possible. It's July 18th and 19th in Adelaide. Details are at the site: www.codecampsa.com . Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!...(read more)

Only a few days left to qualify for the "Best things I learned at the PASS summit" competition

2009-06-19T11:18:00Z

I'm really looking forward to the upcoming PASS summit in Seattle. I know it's a tough year for funds and training, etc. but (particularly for those that travel from a distance), this is likely to be the year offering the lowest cost travel options for a very, very long time. It's a tough year in the airline business too. One of my colleagues Pinal Dave has just described why he thinks you should attend: http://blog.sqlauthority.com/2009/06/19/sql-server-why-you-should-attend-pass-summit-unite-2009-seattle/...(read more)

Writing code with speech recognition

2009-06-09T00:39:00Z

Speech recognition technology has intrigued me for years but never seemed to live up to its promise. It always seemed to me to have more potential where a very limited grammar was involved, rather than attempting complex work like writing freeform prose. For example, the number of commands you can give to a television set is quite limited and much more likely to be successful.

Writing code in programming languages also seems to fit this quite well as it has a constrained grammar. I've often wondered what on earth I'd do if I couldn't type for some reason and figured that speech recognition might provide the answer (while hoping not to be in that situation in the first place).

I was impressed today to see a video from the folk at Renaissance in Israel (including fellow RD Jackie Goldstein) who have tried to tackle the use of speech recognition within Visual Studio. It's a work in progress but definitely worth a look:

http://www.renaissance.co.il/VSSpeech.aspx

Catching up with SQL Server Girl

2009-06-07T20:47:00Z

While we were at TechEd in LA, Mai and I got to catch up with an old friend:

SQL Server 2008 Full Text Indexing - Working out how many documents still need to be processed

2009-06-03T08:35:00Z

I had a query from an attendee of my full-text indexing session at TechEd US. He asked how he can find out which documents (or how many) still need to be processed. I did a little investigation on this and here's my best guess:

<WARNING: Undocumented and potentially just a guess!>

1. Query for the objectid of your full-text index. You can do this by:

select * from sys.fulltext_indexes

2. Open an admin connection to your system ie: connect to admin:SERVER instead of SERVER.

3. Query as follows:

select * from sys.fulltext_index_docidstatus_2105058535

(the number on the end needs to be your full text index's object id not mine :-))

From what I can see, this table seems to hold details of documents not yet processed and it gets cleaned up as documents are processed. This is an internal table that you can see via:

select * from sys.internal_tables

</WARNING: Undocumented and potentially just a guess!>

Hope that helps someone.

Jacob Sebastian is a writing machine: free eBook on XML Schemas in SQL Server

2009-05-26T12:56:00Z

One of the members of our Asian regional development team for PASS is Jacob Sebastian. A week or so back he told me he'd written an eBook for the Red-Gate folk on XML Schemas in SQL Server. I downloaded it expecting it to be fifty to a hundred pages. It was 483 pages. What can I say: Jacob is a writing machine. You can download it here:

http://beyondrelational.com/blogs/jacob/archive/2009/04/26/my-latest-book-the-art-of-xsd-sql-server-xml-schema-collections-available-for-free-download.aspx

SQL Server 2008 May Books Online Available

2009-05-24T10:53:00Z

The title pretty much says it all. The May 2009 version of SQL Server Books Online is now available for download from:

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=765433f7-0983-4d7a-b628-0a98145bcb97

Farewell Steve and thanks for all the fish

2009-05-07T15:47:00Z

Microsoft lost a lot of good people this week. I have to say this change has me dumbfounded. Steve has become a friend over many years of presenting at the same events. I've usually found him to be one of the most interesting people at any of these events. He's also usually the one of top presenters (if not the top) at most of these events.

Good luck Steve.

Why don't the headlines say "Developer glitch" or "Design glitch" instead of "Database glitch"

2009-05-06T15:06:00Z

Most people are aware that a "database" glitch caused the download servers for Windows 7 RC to fail the other day. What annoys me though is that the headlines always say "Database glitch" or "SQL Server glitch". Based on what Paul Randall was posting today, it seems like a pretty simple "Design glitch" or a "Developer glitch".

Every month, I find myself at sites with issues caused by the lack of database-related skills in developer teams. SQL Server does such a good job and is so easy to work with that it seems like many developer teams think they don't need database-related skills, particularly at the design stage. How can that message get changed? Or is that a lost cause and the product needs to simply become:

even easier to use or
more accomodating of design issues or
clearly identify design issues?

Perhaps the headlines should say "Project Management Glitch".

Another Microsoft Certified Master for SQL Server 2008

2009-05-04T09:54:00Z

I'm really pleased to hear that our Colombian friend Jaime Tarquino (who is a Microsoft premier field engineer) has completed his Microsoft Certified Masters for SQL Server 2008.

A very big congratulations Jaime !

Timely reminder to avoid early filtering on resource usage when profiling SQL

2009-04-22T00:45:00Z

I'm back in Melbourne doing some performance-tuning work this week.

Yesterday's issue ended up being a caching problem in middle-tier code. These issues are surprisingly common.

The symptoms were hundreds of thousands of calls to a particular stored proc over a period of half an hour. It's a timely reminder that when you're tracing using SQL Trace calls or Profiler, it's important to avoid filtering out calls that aren't using too many resources, until you've looked at the bigger picture. For example, the logical reads, CPU, duration, etc. on each call were close to zero. No call on its own was a problem but the overall effect of the calls was staggering.

In the end, the problem was a cache timeout value set to 60 instead of 3600. The cache was meant to be flushed each hour, not each minute and the developer responsible thought the value was meant to be in minutes, not seconds.

How important is extensibility for SQL Server?

2009-04-17T23:07:00Z

One of the things that has always surprised me with SQL Server is the lack of extensibility points. In fact, the team seems to go out of their way to remove or avoid them. SQL Server Management Studio is an obvious example but I see it as a much deeper problem.

Taking SQL Server 2008 as a recent example, there is a fixed list of facets. Why? Surely there must be a well-defined interface that all the supplied ones adhere to. Why isn't that interface exposed?

I find that every time I'm in a software review or similar meeting, I'm the one in the room saying "how do I build one of those?".

I think the product would be so much richer if an ecosystem was permitted to be created around it. For example, I saw Klaus Aschenbrenner demonstrating a nice plug in for SSMS a while back that provided a class model style view of service broker objects. Why do such things have to be hacked into the product without having them integrated via supported interfaces?

The product team isn't the only source of ideas for extending the product and it also doesn't have limitless funds available for development. Why should the growth of the product be stunted by an inability to let other people expand it?

How important do you feel extensibility is for the product?

No Microsoft BI Conference this year, SQL PASS Summit is the place to be, Call for speakers extended

2009-04-09T21:28:00Z

Microsoft have announced that they won't be running a BI conference as a separate event this year and that they will be supporting the SQL PASS summit as one of their key BI events for the year.

Because of that, PASS has extended the call for speakers (that originally was to close at April 10th), to allow for those that might now want to consider speaking at the summit.

Regardless, this means that the SQL PASS Summit will truly be the place to be for SQL Server and BI professionals this year. I hope to see you there.

Details are at: http://summit2009.sqlpass.org/