Friday, 31 October 2014
Task Pane 
Login
username:
password:
Remember Me
|Signup
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?







[show results]
Category
SQL Server Programming
Programming techniques and tips etc

Jump to:

Articles
25/02/2005 11:19:21 PM Author: philcart
Database Standards and Conventions
Having a good set of naming conventions for your SQL Server objects is one of the most vital things to a company. In the long duration of a business, it saves money and time as programmers are transferred internally and don't need to relearn object names. As learning curves lower, cost lowers. This article covers some of the conventions that Brian Knight uses and why he uses them.
26/02/2005 12:44:38 PM Author: greglow
Security Summit 2005 SQL Server 2005 Presentations
Greg Low's 3 security summit session powerpoints are available.
3/03/2005 5:38:56 PM Author: philcart
Recursive Queries in SQL Server 2005
Part 2 of new T-SQL enhancements from Srinivas Sampath. SQL Server 2005 contains a number of enhancements designed to allow you to write more powerful queries while keeping the code structured in a way that makes development and understanding it easier. Building on his first look at Common Table Expressions, Srinivas now looks at recursive queries with CTEs.
25/03/2005 2:15:26 PM Author: greglow
Greg Low's March Sydney, Brisbane and PASS Powerpoints now available
The powerpoints from Greg's Sydney, Brisbane and PASS sessions on "A SQL Server DBA's Guide to the .NET Framework and CLR Integration" are now available.
25/05/2005 5:54:35 PM Author: greglow
SQL Server Podcast now available
A new SQL Server Podcast (downloadable audio show) is now available at www.sqldownunder.com. 1st episode features Kalen Delaney. Enjoy!
18/07/2005 5:43:11 PM Author: greglow
Two more podcasts available
Two more SQLDownUnder podcasts are now available from www.sqldownunder.com. Show 2 features Hilary Cotter on replication and show 3 features Kent Tegels on SQLXML.
15/08/2005 10:36:28 AM Author: greglow
SQL Down Under Podcasts - Niels Berglund - Service Broker & Bob Beauchemin - CLR Integration
SQL Down Under Podcast #5 with Niels Berglund discussing SQL Server 2005 Service Broker and #5 with Bob Beauchemin discussing CLR Integration in SQL Server 2005 are now available for download from www.sqldownunder.com.
8/09/2005 3:42:39 PM Author: greglow
SQL Down Under Podcast #6 with Itzik Ben-Gan on T-SQL
SQL Down Under Podcast #6 with Itzik Ben-Gan discusses solving problems using T-SQL and upcoming enhancements to T-SQL in SQL Server 2005 is now available for download from www.sqldownunder.com.
8/09/2005 3:43:58 PM Author: greglow
ADO.NET and SQLCLR TechEd Session Materials
Materials from Greg Low's ADO.NET and SQLCLR sessions at TechEd 2005 are now available from the Previous Meetings tab on www.qmsdnug.org.
17/10/2005 4:45:50 PM Author: wallismark
SQL Coding Standards
There is a distinct advantage in following a community wide set of common coding standards. This article presents suggested standards as taken directly from the UK user group site (i.e. people smarter than me have put together their suggestions)
25/11/2005 4:36:18 PM Author: greglow
3 more podcasts available including Jim Gray
3 more podcasts (Roger Wolter on SQL Express, Adam Machanic on stored procedures as API's and legend Jim Gray on the future of SQL Server) can be downloaded from www.sqldownunder.com now.
22/12/2005 3:39:29 PM Author: greglow
SDU Podcast #10 - Graeme Simsion - Data Modelling
SQL Down Under podcast #10 with guest Graeme Simsion discussing data modelling is now available at www.sqldownunder.com.
18/01/2006 11:20:15 AM Author: greglow
SDU Podcast #11: Tom Moreau
SQL Down Under podcast #11 featuring SQL Server MVP Dr Tom Moreau is now available for download from www.sqldownunder.com.
3/02/2006 3:39:09 PM Author: greglow
SQL Down Under Podcast #12 - Louis Davidson
SQL Down Under Podcast #12 featuring guest SQL Server MVP Louis Davidson is now available for download from www.sqldownunder.com.
1/04/2006 12:02:27 AM Author: greglow
SQL Down Under Show 13 - Bill Graziano
SQL Down Under show 13 with guest SQL Server MVP Bill Graziano is now available for download from www.sqldownunder.com.
19/04/2006 9:33:35 PM Author: greglow
SQL Down Under Show 14 - Adam Cogan - SQL Reporting
SQL Down Under Show 14 featuring MSDN Regional Director Adam Cogan discussing his "rules" for better SQL Reporting Services is now available for download from www.sqldownunder.com.
6/05/2006 8:40:48 PM Author: yeehaa2
Canberra IT Survey
Check out http://canberra-it-survey.blogspot.com/ for a great survey on IT contracting in Canberra!
7/05/2006 1:00:42 PM Author: greglow
SQL Down Under show 15 - Kim Tripp - SQL Indexing
SQL Down Under show 15 with guest RD & MVP Kim Tripp is now available for download from www.sqldownunder.com.
8/06/2006 5:13:34 PM Author: greglow
SQL Down Under Show 17 - Gert Drapers - DataDude
SQL Down Under show 17 with guest Microsoft Architect and Development Manager Gert Drapers discussing the upcoming Visual Studio Team Edition for Database Professionals is now available for download from www.sqldownunder.com.
28/08/2006 11:48:26 PM Author: greglow
SQL Down Under Show 18 with guest Don Vilen
SQL Down Under Show 18 with guest Don Vilen is now available for download from www.sqldownunder.com.
21/09/2006 11:42:20 PM Author: casperleon
T-SQL Coding Standard
A proposal for a simple T-SQL Coding Standard
30/11/2006 10:48:24 AM Author: KyleBloom84
Create Stored Procedure Wizard
Where have all the wizards gone?
12/01/2007 1:24:19 PM Author: greglow
SQL Down Under shows 19 & 20 - Peter Myers and Richard Waymire
SDU podcast 20 with guest Richard Waymire is now available for download from www.sqldownunder.com. Show 19 with local guest Peter Myers is also available.
17/02/2007 5:00:51 PM Author: greglow
SQL Down Under Show 21
SQL Down Under show 21 with guest Joe Celko is now available for download from www.sqldownunder.com
25/04/2007 3:34:24 PM Author: greglow
SQL Down Under show 22 with guest Kevin Kline
SDU Show 22 with guest SQL Server MVP and PASS President Kevin Kline is now available for download from www.sqldownunder.com.
19/10/2007 11:03:56 AM Author: greglow
SQL Down Under show 24 - Paul Randal
SQL Down Under show 24 with guest Paul Randal is now available for download from www.sqldownunder.com. In it, Paul discusses DBCC CHECKDB for 2005 and improvements in 2008 for database mirroring and partitioned tables.
5/01/2008 11:29:12 AM Author: greglow
SQL Down Under shows 25 and 26 (Matthew Roche and Chris Randall)
SQL Down Under shows 25 (Matthew Roche and SSIS) and 26 (Chris Randall and SQL Certification) are available for download from www.sqldownunder.com.
11/01/2008 5:11:42 PM Author: greglow
SDU Show 27 - SQL Legend David Campbell
SQL Down Under show 27 with SQL Server product group legend David Campbell discussing the process of building SQL Server 2008 (and what he’s most looking forward to in it) is now available from www.sqldownunder.com.
18/01/2008 2:30:52 AM Author: greglow
SDU show 28 - Ed Lehman - SQL community
SQL Down Under show 28 with guest Ed Lehman discussing the SQL community including the MVP program, the Connect feedback site, the Newsgroups, the Forums and CodePlex is now available for download from www.sqldownunder.com.
24/01/2008 2:12:50 PM Author: greglow
SQL Down Under show 29 - Richard Tkachuk - Analysis Services and SQL CAT team
SQL Down Under show 29 with SQL CAT team member Richard Tkachuk discussing the CAT team, working with Analysis Services and what's coming for Analysis Services in 2008 is now available for download from www.sqldownunder.com.
5/02/2008 8:06:16 AM Author: greglow
SQL Down Under show 30 - Pablo Castro
SQL Down Under show 30 with Pablo Castro discussing LINQ, Entity Framework and ADO.NET Data Services for the DBA and database developer is available for download from www.sqldownunder.com.
14/02/2008 1:42:25 PM Author: greglow
SQL Down Under show 31 - Craig Utley
SQL Down Under show 31 with guest Craig Utley is now available for download from www.sqldownunder.com. In the show, Craig provides some tips on SSRS 2005 and some insights into what’s coming in 2008.
23/02/2008 5:31:27 PM Author: greglow
SQL Down Under show 32 - Dr Michael Rys - SQL Server and XML
SQL Down Under show 32 with SQL Server product group member Dr Michael Rys is now available for download from www.sqldownunder.com. In this show, Michael discusses why XML matters in SQL Server, provides an overview and tips on the support provided in earlier versions and discusses the changes upcoming in SQL Server 2008.
29/02/2008 3:36:21 PM Author: greglow
SDU Show 33 - Allen White - Automating SQL admin with SMO and Powershell
SQL Down Under show 33 with SQL Server MVP Allen White discussing the automating of administration using SMO and Powershell is available for download from www.sqldownunder.com.
14/03/2008 10:09:46 AM Author: greglow
SQL Down Under show 35 - Roger Doherty - SQL 2k8 for Database Developers
SQL Down Under show 35 with guest SQL Server DPE Evangelist Roger Doherty is now available for download from www.sqldownunder.com.

In the show, Roger discusses what developers are looking forward to in SQL Server 2008.
19/07/2008 3:05:14 PM Author: greglow
Recent SQL Down Under Shows - Lubor Kollar, Chris Webb, Andy Leonard
SQL Down Under shows 36, 37, 38 with guests Lubor Kollar, Chris Webb and Andy Leonard are available for download from www.sqldownunder.com.