The Bit Bucket

At a meeting I was at a few months back, it was noted that in a future version of SQL Server, the intention was to disallow results being returned from triggers. That surprised me somewhat.

My main concern with this was about my ability to debug triggers. I often seem to end up working on systems where people have layers of nested triggers. (Perhaps I’m just lucky that way). Usually I have to end up using a combination of PRINT statements and writing values into tables to work out what’s going on in the triggers. And given that the action of the triggers may well be rolled-back, writing to a table is often not a simple option if you want the values to still be there later.

2009-02-05

Just had our Canberra mate Jeff Wharton confirm that he’s organised a SQL user group meeting while I’m there next week. I’ll be doing the session “Answering the queries your users really want to ask” which covers full-text indexes in SQL Server 2008. I find three categories of people in these sessions:

* those that have never used full-text indexing in SQL Server

* those that have old pain associated with trying to use it

2009-02-02

Some time back I posted about Logins and SIDs and I’ve had a number of people ask me for examples. So I’ve updated the post here.

A very common issue that’s raised in the newsgroups relates to SQL Server logins that need to be moved between servers. When you recreate a SQL Server login (ie: not a Windows one), by default you get a new security ID (SID), even though you have the same user name and password.

2009-02-02

I’m really proud of the work my colleagues did on the SQL Server 2008 System Views poster in conjunction with our partners. Ron Talmage led our team. But the best news is that it’s now available for download for free:

http://www.microsoft.com/downloads/details.aspx?FamilyID=531c53e7-8a2a-4375-8f2f-5d799aa67b5c&displaylang=en

2009-01-30

Victor Isakov has decided to spin up a new SQL Server user group that will be meeting on the 1st Wednesday of each month, at Westpac Place in the city. He describes the group as focussing on best practices, optimisation, design and implementation and is aiming directly at the local corporate market.

Access to Westpac Place will be quickest if you have pre-registered so Victor is asking you to let him know you’re coming by sending him an email to [email protected] .

2009-01-29

Ken Tanner recently reminded me of the link showing current certification status.

(no longer available)

The SQL Server related entries from this list are:

MCDBA	SQL 2000	152086
MCTS	SQL 2005	41665
	SQL 2005 BI	2600
	SQL 2008 Dev	336
	SQL 2008 BI	134
MCITP	SQL 2005 DBA	6695
	SQL 2005 Dev	2925
	SQL 2005 BI	1088
	SQL 2008 DBA	92
	SQL 2008 BI	50
MCM	SQL 2005	18
	SQL 2008	2

The 18 SQL 2005 Certified Masters folk have been brought across from the earlier SQL Ranger program. The list doesn’t include the SQL 2008 DBA TS certification for some reason. I’d be interested in hearing your thoughts on why there was such a big drop in numbers from the 2000 versions to the 2005 versions. I suspect that part of it has to do with the 2000 exams being much easier and that they were a relatively easy option for those pursuing a variety of certifications, including the developer certifications.

2009-01-29

I’m also locked in to present a one day “SQL 2k8 for Developers” preconference session and three conference sessions for DevWeek in London in March, along with a number of my colleagues from Solid Quality: Itzik Ben-Gan and Javier Loria. I’m really looking forward to it and would love to catch up with any SQL locals while there. Details are at the DevWeek site.

2009-01-27

Got the email today to say I had a session accepted for TechEd US. I’ll be doing the “Answering the queries your users really want to ask” session on full text indexing in SQL Server 2008. It’s an update of the session that I did at TechEd EMEA in Barcelona recently.

I’m really pleased to get to present again this year, given the vastly reduced number of data track sessions.

2009-01-26

Kevin Kline recently posted, wondering about the directions for LINQ.

When people refer to LINQ, they’re often referring to “LINQ to SQL” instead.

LINQ as a language enhancement is pretty cool. It provides a way to easy navigate enumerable objects. The only thing that puzzles me is why they picked SQL-like syntax for this instead of something more appropriate for objects.

On the other hand, LINQ to SQL I can’t get excited about. The main issues are that it’s tied to SQL Server and only gives you a one-to-one mapping of tables to objects. That leaves you with either a lousy database design or a lousy object model.

2008-12-24

Some time back, I posted about how to do this. Well by the time we got to RTM, this had changed.

There isn’t a “create placeholder” option when you right-click a cell any more.

When you drag a field into a cell, it creates a placeholder that contains the field. If you right-click the placeholder that was added, you’ll see an option to edit the Placeholder Properties. What threw me for a while was that if you right-click the cell, you won’t see this option. Turns out you have to right-click the field-name within the cell, not the blank area beside the name within the cell. Thanks to my colleague Jessica Moss for helping me find it.

2008-12-19