Sunday, 22 January 2017
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.
29/07/2016 11:16:46 PM Author: matthewdavis9179
Significance of an Optimized Web Design and Promotion in Digital World
51WEB Australia is a Sydney based digital marketing firm that extends exceptional internet marketing, website promotion(????) and Search Engine Optimization services to its clients
25/08/2016 4:53:49 PM Author: blairsteve44
Avail Hi-Tech 3D Body Measurement and 3D Body Scanning Technology Solutions
We gain point to point measurement and circumference extraction parameters by full body 3D scanner software and also the most advanced way to answer all body scan & needs.
26/08/2016 10:19:29 PM Author: blairsteve44
LandCastle Title| LandCastle Title| LandCastle Title Company: Offering Exceptional Title Insurance Services
LandCastle has number of years of knowledge in this area of field and has the capability of handling serious legal situations
30/08/2016 9:29:03 PM Author: blairsteve44
Get Top-Quality Volvo Parts Miami from a Reliable Online Store
Volvo of North Miami offers a wide selection of new Volvo & used cars in Ft Lauderdale, Miami Beach, Hollywood & areas around
20/09/2016 3:58:53 PM Author: preeceroy1234
Get World Class LED Lighting for your Home and Workplace
VOLKA Lighting is a leading online store that offers a vast range of durable LED products that can reduce your electricity bills. They provide affordable LED lights for kitchen cabinets that add functionality and style to your kitchen.
18/10/2016 5:26:55 PM Author: blairsteve44
Help yourself with the Best Litigation Support Florida
Special investigative and security consulting services are provided by Ashenoff & Associates, an agency full of experts that serves the state of Florida. One of their highly acclaimed services is the excellent Litigation Support Florida service they provide.
20/10/2016 11:03:22 PM Author: blairsteve44
Now Don’t Keep your Buddies and Close relatives patiently waiting for your Gifts!
At Myfloralkart.com, you can find awesome presents that can be sent to most significant locations in India, exactly when you want them to be sent.
25/10/2016 9:29:07 PM Author: blairsteve44
Find the Best Pub to Watch your Favorite Sports in Australia
If you are tired of finding the most happening pub, Game On is the best platform that has joined hands with umpteen sports bars that provide you the eventual destination for watching the sports in Australia.
26/10/2016 12:33:42 AM Author: blairsteve44
Create Unique Patterns with Embroidable Animals for your Kids’ Clothes
Texmac Direct supplies quality embroidery products such as bobbins, needles, 3D puffy foam, scissors and stabilizers too. In addition, they are known for giving full support in regards to the several tools and equipment that are offered.
12/11/2016 12:23:08 AM Author: blairsteve44
Cure your Ankle with Lethbridge Ankle Ligament Brace
Lethbridge Orthotic Prosthetic Services Ltd employs a team of experienced and professional engineers who develop the best Lethbridge Plantar Fasciitis for you.
12/11/2016 7:34:52 PM Author: blairsteve44
Protect your Valuable Devices from Damage with Excellent Covers
Bump Armor has a range of products, specialized for various models of Apple’s iPad and other touch tablets. Their endless range of protective laptop bags has made them one of the top companies for protective cases of gadgets.
16/11/2016 6:26:09 PM Author: blairsteve44
Things to be Considered while Choosing Any Shipping Companies in Jordan
Leen Cargo is a reputable shipping company in Jordan that provides you the facility of shipping your goods locally as well as globally.
19/11/2016 9:41:55 PM Author: blairsteve44
Expand your Business Using Mobile Marketing with Cost-Effectiveness
MobiVisits is a renowned and the most reliable company providing online advertising, marketing and mobile technology services to let your business grow with their exemplary services.
12/12/2016 11:57:02 AM Author: JessyParker
192.168.1.1 Router Login
192.168. 1. 1 is an IP address that belongs to C class of IP address. This IP address is very effective in making any kind of change to your existing router and effectively taking care of the problem that might arise in the future.
13/12/2016 9:11:16 PM Author: blairsteve44
Innovations TV scam || Innovations TV scam || Innovations TV scam
Innovations Television is one such phenomenal TV series based on the information regarding development in the field of medical science and agriculture. These TV series is mainly grounded on the topics like prevalent and rising health issues and their cure, global market and business and also renewable energy.
15/12/2016 5:50:29 PM Author: blairsteve44
10adspay scam ||10adspay scam ||10adspay scam
10adspay is one of the leading digital marketing and advertising agency that provides you the excellent services to protect you against any 10adspay scam.
16/12/2016 8:49:55 PM Author: blairsteve44
Buy Trendy Hipster Sunglasses from Leading Company
Proof Eyewear offer superior and sturdy eye wears such as sunglasses and eyeglasses at competitive prices. So, if you are looking for excellent optical wears then Proof Eyewear is the perfect destination.
16/12/2016 9:12:58 PM Author: blairsteve44
Buy Natural Skin Care Products for Healing Adult Diaper Rash
Diaper rashes can be treated by using the various skin care products which are dermatological-tested and clinical-approved. The usage of water-resistant creams can help you a lot to keep your skin dry for a longer time and also heals your affected part soon.
16/12/2016 9:46:54 PM Author: blairsteve44
Get the Best Cold Chain Solutions for your Perishable Food Products
PakSense provide products such as Autosense Inbound, Ultra wireless, Alert Indicators, AutoSense Facility, AutoSense Yard Monitoring and also absolute accessories for regulating the temperature and sudden changes in the conditions of your items.
19/12/2016 7:52:54 PM Author: blairsteve44
Where to Apply for Bad Credit Loans Canada
Cash Lender can help you in this situation of changed mortgage policies along with your poor credit score. They offer various types of loans including home equity loans, home improvement loans, mobile home loans as well as medical loans and student loans.
21/12/2016 6:00:56 PM Author: blairsteve44
Get Quality Orthodontic Treatments at Lethbridge Dental Clinic
If you are seeking the best Lethbridge dental clinic with a healthy environment where you can get all the dental treatments then All West dental is the name you should take into consideration.
24/12/2016 12:06:08 AM Author: blairsteve44
Avail Family Health Insurance Kansas City Services like Never Before
If you want to take the insurance for your employees then you can go for group health insurance Kansas City. This will cover all your employees insurance and apart from this there are many insurance types as well.
24/12/2016 10:09:34 PM Author: blairsteve44
Get the Fantastic Experience of Central Park Carriage Rides with Cherished Memories
If you are seeking a company in New York City which caters the services to help you to visit all the famous areas of Central Park then VIP Central Park Tours is the name you should take into consideration.
24/12/2016 11:35:59 PM Author: blairsteve44
How Inspection and Quality Control Services are Important for Factory’s Throughput?
The China inspection providers offer a wide range of quality assurance and quality control services. For instance they can pick a random sample from the product manufacturing cycle and send it for testing to their experts.
27/12/2016 5:42:16 PM Author: blairsteve44
Hire Experts for Car Repair Lethbridge Today!
Speedy Paint & Body specialize in quality collision repairs with experience in paint work by performing such techniques that could restore the car as before or make it look like a new one.
27/12/2016 10:18:30 PM Author: blairsteve44
Avail the Best Carpet Cleaning Kenner LA Services Like Never!
In this kind of cleaning services apart from carpet cleaning, it is also included rug cleaning New Orleans, upholstery cleaning, pet odor removal and water damage restoration.D&G Carpet Cleaning offers the best services that can make your carpet cleaner, brighter, free of stains and free from dust particles.
2/01/2017 5:40:02 PM Author: blairsteve44
Get Military Grade Helmets for Enhanced Protection
Hard Head Veterans import all the parts from the best manufacturers in the world and assemble them to make brilliant helmets right here in the United States of America.
3/01/2017 6:08:03 PM Author: blairsteve44
Watch Free Movies Online through Remarkable Web-based Platform.
MovieTube is among the remarkable applications through which you can watch your favorite movies in superior quality. Through MovieTubeonline.net you can also watch your favorite TV shows online or can also download them in case you are busy.
3/01/2017 8:35:57 PM Author: blairsteve44
Middle School STEM Courses California: Creating Pros with Coding Skills
CTE Learning is a leading organization that provides stem education curriculum California to help you motivate and bring best in your child. The organization focuses on education through latest tech powered tools and e-learning courses that are both interactive and easy to grasp.
4/01/2017 4:42:05 PM Author: blairsteve44
Avail Photo Scanning Services for Preserving Your Valuable Memories
Your pictures are the only sources of your sweet memory through them you can relive those precious moments of your life whenever you want. However, these memories, if not preserved in a proper way, can fade away after sometime.
10/01/2017 12:20:20 AM Author: blairsteve44
Know Your Asset’s Worth, Not on Assumptions but on Precise Calculations
2H Engineering is a leading real estate consultancy that excels in providing you all aforementioned solutions with expertise.
14/01/2017 5:01:56 PM Author: blairsteve44
To Make Your Child’s 1st Birthday Special Call Chicago Kids Photographer
The Kidographer offers the best professional photographers and they use the most advanced tools and technologies, to provide the finest special effects to your images.
17/01/2017 12:31:15 AM Author: blairsteve44
Need to Get in Shape? Drink Match Green Tea
If you too want to get advantage of the many benefits of detox tea, then Bondi Beach Tea Co. is the company you should opt for. Their teatox blend slimming tea is available in weekly detox packs.
19/01/2017 8:00:56 PM Author: blairsteve44
Rent a Drone for Any Purpose with UAVLance’s Simple Online Rental Platform
There are some reliable providers that offer UAVS’s for rental purposes. But UAVLance is the first site to consolidate all of these providers, offering better rates and reach for drone consumers and renters.
19/01/2017 8:51:59 PM Author: blairsteve44
Prove Your Mettle in Drone Racing like a Real Pro Pilot
UAVLance is a web portal made just for you. Here you can find lists of the entire ongoing Drone racing events happening in and around your locality! You can connect with many other Drone racers who are just as crazy and passionate about the sport as you are.
19/01/2017 10:48:14 PM Author: blairsteve44
Increase the Usability of Your Website with the Best Web Design Company
If you are looking for a reliable web design company in Toronto, then Trice Web Development Inc is the name you can rely on.
19/01/2017 11:52:13 PM Author: blairsteve44
How Mobile Apps can Induct Police Accountability Amongst its Officers?
The CopCritic app is developed to create and support a cordial relationship between the citizens and the law enforcers. This app shall broadcast Police brutality or abuses while also show the exemplary deeds of fellow cops of the society.
20/01/2017 12:49:08 AM Author: blairsteve44
Restore Your Old Pool with these New Cheap Techniques
One such company famed for restoring and renovating pools is Mid-America Pool Renovation Inc. They offer exceptional renovation services for pools and are known for giving your pool a completely new makeover. Besides this, they also make your pool safe for use.
20/01/2017 4:21:20 PM Author: blairsteve44
Update the Features of Your Pool; Avail Chesterfield Pool Renovation
If you are planning to get your pool renovated for improving its texture and installing the cost-effective equipments then you can opt for leading companies like Mid America Pool Renovation Inc.
20/01/2017 10:37:12 PM Author: blairsteve44
Purchase Euro Cylinder Locks from UK’s Number One Retailer
Max6mum Security provides you wide range of security locks including window and door security, door viewers and letterboxes too. They are well known for offering you the long lasting security products to improve the security system of your home.
21/01/2017 6:05:48 PM Author: blairsteve44
Best Snow Removal New Jersey
With the chance of liability in mind it is more important than ever to have a professional snow removal company in New Jersey remove the snow for you.
21/01/2017 8:19:47 PM Author: blairsteve44
Get Best-in-Class Pool Renovation Services in St. Louis
Mid America Pool Renovation, Inc. is the leading swimming pool restoration and renovation services provider across the St. Louis, Missouri area.
21/01/2017 9:02:10 PM Author: blairsteve44
Residential Renovations New Jersey
Only by bringing in a high quality interior renovations NJ can you ensure the protection of your greatest investment - your home.
22/01/2017 12:40:46 AM Author: blairsteve44
Make Your Pool Weather Proof with the Omaha Pool Renovation Experts
If you’re looking for a trusted and well equipped team of pool restoration experts, you can go for Mid America Pool Renovation Inc and their team of specialists. They are pioneers in the pool renovation business and have been renovating pools for over 30 years.