|
|
Browse by Tags
All Tags » teched (RSS)
-
I’ve presented this material at three conferences recently, so it’s about time I wrote a blog post on it... As programmers, we love modularisation – even in the SQL space. We make stored procedures, views, and functions to encapsulate our code. This improves Read More...
|
-
I’m just going to list them… This Saturday (July 18th), at Code Camp SA . I’m going to be talking about functions in SQL, particularly those that involve BEGIN and END. At the end of the month, at the ACS Branch Conference . I’m going to be part of a Read More...
|
-
A new Financial Year in Australia, and a bunch of technical events coming up. Of course there’s the usual monthly user groups , but there’s more – particularly if you’re in Adelaide. July sees CodeCampSA in Adelaide on the weekend of July 18/19. I’ve Read More...
|
-
GO is very cool. More so than you might think, and in a couple of interesting ways. This is the 6th tip from my TechEd Australia talk, from which you can see my slides and scripts in other posts. In SQL Server, GO is the traditional batch separator. But Read More...
|
-
When you select data out of a database table, it might seem as if the system will give you data in the order of the clustered index that is on that table (assuming it has one), but this isn't quite right. I showed this in the fifth of my T-SQL tips Read More...
|
-
Indexes are great, but if you don't understand the significance of unique indexes, then you're potentially missing out on some decent performance gains. I've been meaning to write this blog post for a long time. This is material that I've Read More...
|
-
This is another of my tips/techniques that I demonstrated recently. It is not a new SQL Server 2008 feature - it works just fine in older versions - I demonstrated it running on SQL Server 2005 but using SQL Server 2008 Management Studio. When you have Read More...
|
-
The second of my tips from my talk ( slides and scripts available) was about doing the maths to understand why the SQL Server optimiser behaves in the way that it does - particularly in relation to choosing whether to scan an index/heap, or whether to Read More...
|
-
The OUTPUT clause has to be one of the best T-SQL features out there. It was new in SQL Server 2005, but it's still remarkably little known. I guess like many of the features that were introduced in SQL 2005, many people just make do with the way Read More...
|
-
I've given this presentation a couple of times at user-groups now - last week in Adelaide, and this week in Melbourne. I posted the scripts to my blog recently, making them available to people who heard this talk at TechEd Australia at the start of Read More...
|
-
TechEd AU this week. I'm giving a talk on "T-SQL Tips n Techniques: Improving Your T-SQL Arsenal" on Friday morning. The slides are available from CommNet for people registered, but the scripts are here as well. Come along to the talk to Read More...
|
-
It was unfortunate news when I heard that the UNICEF Australia site was hacked a little while ago. An old colleague of mine called me to let me know, and to ask if I knew anyone who could help them out. I used to work at a hosting company with this guy, Read More...
|
-
This panel discussion was recorded at Tech*Ed this week, it is a panel discussion about Visual Studio Team System at large. Participants Brian Harry (Technical Fellow of Team Foundation Server), Neelesh Kamkolkar (Senior Product Manager VSTS Test Edition), Read More...
|
-
Yesterday, during Bill Gates his Tech Ed keynote , Brian Harry had the honor to show the first glimpse of the results of our partnership with IBM, DB2 support inside Visual Studio Team System Database Edition. As you might know or have read in one of Read More...
|
-
In case you are coming to the Developer edition of Tech·Ed next week, we have a lot of exiting things for you. As you can see below there are many sessions, hosted in both the developer and database tracks. Breakout sessions, chalk talks, panel discussions Read More...
|
|
|
|