Sql-Server

Recently, I was working at a client’s site where SQL Server 2000 was still in use. They wanted to upgrade to SQL Server 2005. The only reason they were looking at the Enterprise Edition was for data-driven subscriptions in Reporting Services. The CEO certainly wasn’t interested in paying the sort of dollars required for that, just to be able to automatically email out a set of monthly reports to about 30 or so folk within the company.

2008-08-13

While I was prepping my full-text search session for TechEd Australia today, I decided to modify the thesaurus. I found the discussion in books online a bit confusing regarding the locations of the files involved.

What threw me was it said the default location of the thesaurus files was:

_SQL_Server_install_path_\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\FTDATA\

I went there and couldn’t find anything. I worked out that for ENU language, my file should be called tsENU.xml. I searched for that and found it in:

2008-08-13

I’ve been doing another performance tuning job today and it highlighted to me once again that problem that a lack of indexes on foreign key columns can bring.

By adding indexes on the foreign keys on three tables, we saw a reduction of 87% in total I/O load on the server. There are other aspects of the system that I’m now working on but it really struck me that having SQL Server do this by default would avoid a lot of apparent performance problems. It would have to be one of the most common indexing issues that I see in my work.

2008-07-28

Hi Folks,

SQL Down Under show 38 with guest SQL Server MVP Andy Leonard discussing database testing is now available for download from https://sqldownunder.com .

The show also includes a competition.

Enjoy !

2008-07-19

I caught up with James Luetkehoelter at the PASS Summit in Germany a few months back. He sent me a copy of his new book from APress: Pro SQL Server Disaster Recovery .

I managed to finish reading it while heading back from CodeCampSA in Adelaide today (which was a good solid event again - excellent work Peter Griffiths!). I quite enjoyed the book and I like James’ writing style. It’s quite conversational and I could hear him talking to me as I read it.

2008-07-13

There are a number of key books that I’ve missed reading over the years, in areas that interest me. Recently, I’ve been fixing that. One that is always discussed is The Microsoft Data Warehouse Toolkit by Joy Mundy and Warren Thornthwaite from the Kimball Group.

I would have to say I enjoyed reading it. It is a large book at over 700 pages and a couple of inches thick so it took a while to get through.

2008-07-09

I know this post has the potential for religious-level debate but it’s time to make it anyway.

The more I’ve been working with Analysis Services lately, the more it grates on me that the BI community still seem to be the last ones hanging onto table prefixes. They’re not doing “tblSomeTable” but they are using “dim”, “fact”, etc.

Hasn’t the time for this long gone now?

Most of the argument seems to be about finding tables in a list of tables. You could do that via schemas if you really wanted to. But as Adam Machanic pointed out recently, from 2005 onwards many-to-many dimensions blur these lines anyway.

2008-06-16

I’ve heard a lot of praise for Scott Ambler’s book: Database Refactoring: Evolutionary Database Design over the past few years. It’s another relatively classic book that I’ve been slow to read.

I often mentioned to people that when I was at a software design review meeting for Microsoft around the DataDude product (Visual Studio Team Edition for Database Professionals), I noticed that Sachin Rekhi from the team was walking around with a copy of this book under his arm. As Sachin was responsible for the refactorings to go into the product and there was only one refactoring (rename) at the time, I thought that was a good sign for where the product might head. I wasn’t aware that he had been a contributor to the book. Sachin wrote some of the opening details.

2008-06-07

I haven’t posted up any book reviews recently so it’s time to catch up a bit. For some reason, it had taken me ages to get to read Kalen’s latest book in the Inside SQL Server series: Inside Microsoft SQL Server 2005 - Query Tuning and Optimization .

As expected, it’s a great piece of work. I very much enjoyed the chapters written by other authors as well, particulary those from Adam Machanic and Craig Freedman. Ron Talmage, Sunil Agarwal and Lubor Kollar have also made strong contributions to this work.

2008-06-07

Hi Folks,

I’ve posted show 36 for SQL Down Under with guest SQL CAT team leader Lubor Kollar up at the site ( https://sqldownunder.com ). In the show, Lubor discusses the SQL CAT team and some SQL Server 2008 features such as the resource governor and compression.

Enjoy!

2008-06-07