| |
| What I like about SQL 2005
|
|
|
Location: Blogs Henri Koppen - Developer |
 |
| Posted by: Henri Koppen |
15-1-2007 10:58 |
Recently our website got a new look and feel (DNN based). However, old blogs where so static that migrating them to the new website was a cumbersome task. Some post where outdated and so I start all over again. Just to get familiar with the new look & feel I'm just writing a short post.
Recently our website got a new look and feel (DNN based). However, old blogs where so static that migrating them to the new website was a cumbersome task. Some post where outdated and so I start all over again. Just to get familiar with the new look & feel I'm just writing a short post: Things I like most off MS SQL 2005.
If you are a database programmer: Get to know CTE's (Common Table Expression). Working with CTE's is heaven of your data is hierachy-based. (e.g. get a list of employees falling directly and indirectly under a specific manager). Usualy you needed a loop or a smart cross join to solve this issue, with a good written CTE is childplay.
Databases are for data, applications for user interface, but what if you needed application code (e.g. VB.NET) to solve business issues like sending automatic generated generic mailmerges? Doing this in the datalayer is nearly impossible. Running an app at night? Not very reliable. Use CLR Integration. Yes! Writing your favourite language at store them in the database assemblies! I wrote some articles to do this manually, but working with visual studio (at least with professional) it can be fairly easy. It's powerfull, lightning fast and very robust!
To conclude this, here's a last thing about SQL2005 what strikes my fancy: Restoring databases, migrate them from SQL2000 is really easy with the new SQL managing studio. In some aspects I like the old one more than the new one, but some tasks are really made easy. And migrating and restoring data is one of them! The new interface is more genericly build and I'm still discovering more and more functionality. Now, I'd never go back to SQL2000. |
| Copyright ©2007 Henri Koppen |
| Permalink |
Trackback |
Comments (7)
Add Comment
|
Coach Handbags |
By Coach Handbags on
16-7-2010 7:29 |
utopia
With Coach Handbags of styles and colors to choose from you really can’t go wrong.The heels collection provides everything from the big hit of the season ankle boots, to strappy Nike Air Jordan.After hitting the market in 2004, Tory Burch Cheap Gucci Shoes have become a fashion essential for those looking for the latest in style and surprisingly comfort. Michael Jordan Shoescome in a wide range of variety and styles. The big portion of their market and nike dunk appeal comes from their collection of flats that not only is trendy but is known for their wear ability and comfort.With a wide range of designers and Nike Air Jordan on the market, these fashionista savvy Cheap MBT Shoes can come off the cover of Elle magazine without breaking the bank. |
|
|
nothing is impossible··· |
By anlia on
26-7-2010 3:10 |
Thanks for your sharing, good job!
If you are the fans of gucci outlet series, the topguccishoes.com website will be the best and right place that you have come to. A full collection of gucci sneakers products are proud of supplying for you, such as Gucci clothing, gucci jeans, ugg bailey button boots, Gucci skirt, Gucci bikini, Gucci spicy underwear, UGG Classic Tall|UGG Classic Short as well as you can find the discount gucci shoes, stylish Gucci shoes for women with high and low performance, discount gucci handbags for male and female, gucci hats for sale, bailey button ugg boots|ugg boots bailey button, gucci accessories and so on. In a word, the Gucci products ugg classic |ugg kids online can well meet the different requirement from numerous people. |
|
|
Betr: What I like about SQL 2005 |
By vdg on
3-8-2010 9:21 |
As the sun set over the Timberland Shoes at this year's Cannes Timberland Boots Festival, Timberland shoes us one Timberland Shoes on sale was being talked about Wholesale Timberland Shoes in the glamorous Timberland Shoes Outlet and watering places - and the Discount Timberland shoes hasn't even Discount Vibram FiveFingers been made Timberland Boots on sale yet. Fought Discount Vibram Five Fingers over by three Wholesale Timberland Boots rival companies, the Vibram FiveFingers hottest property is the Timberland Boots Outlet life story Vibram FiveFingers on Sale of a Vibram Five Fingers long-dead couturiere Discount Timberland Boots.
Born out of MBT Shoes, brought up MBT Shoes us a church Wholesale MBT Shoes, hers was an Discount MBT Shoes astonishing achievement. She MBT Sandals designed the world's most celebrated MBT Shoes on Sale perfume - famously Vibram Five Fingers Shoes worn by Marilyn Monroe (with nothing else) MBT Shoes Outlet in bed - and Vibram Five Fingers little pink Vibram Five Fingers on sale suit worn by visvim slippersJackie Kennedy Gucci Shoes on the day her MBT Sandals on sale President husband was Gucci Shoes on sale assassinated. She Vibram FiveFingers outlet invented those Prada Shoes prerequisites of modern Birkenstock Slippers style: costume jewelry Prada Shoes on sale, the Little Black Dress, the shoulder Discount Gucci Shoes and even MBT Sandals outlet the suntan. Discount Vibram Five Fingers The first of Discount Prada Shoes the must-have designers, she has Gucci Shoes Outlet also had the most Vibram Five Fingers outlet staying power. She dressed Prada Shoes Outlet the aristocracy in the 1920s, discount MBT Sandals film stars in the Thirties and Vibram FiveFingers Shoes debutantes in the Fifties.
And now waiting to Replica Chanel Bags snap up her Chanel Bags signature quilted handbags, chain belts Coach Bags and two-tone Louis Vuitton Bags. She is Gabrielle Chanel Wallets, better known Replica Coach Bags as Coco Coach Wallets, and she had Replica Gucci Bags the most fertile Louis Vuitton Wallets imagination ever to Prada Bags inhabit the world of fashion Jimmy Choo Bags. Her rags-to-riches story Gucci Bags has it all: Replica Prada Bags glamour, money, Tous Bags, aristocratic suitors, Chanel Handbags even a treacherous Replica Louis Vuitton Bags liaison with a German Nazi Coach Handbags officer in occupied Paris. Coco Louis Vuitton Handbags, one of the Fake Chanel Bags most beautiful girls Prada Handbags in France, Fake Coach Bags was notoriously Jimmy Choo Handbags and a determined Gucci Handbags. She initially made her Tous Handbags in the world as a Chanel Bags on sale and, even when she was established as a formidable Coach Bags on sale, she was Coach outlet happy Louis Vuitton Bags on sale to be the Fake Gucci Bags mistress of the Chanel Wallets on sale Duke of Coach outlet us, the richest Coach Wallets on sale in England.
Even Louis Vuitton Wallets on sale today, you can Prada Bags on sale still see her Fake Prada Bags famous entwined CC logo painted Jimmy Choo Bags on sale in gold on the lampposts of the Gucci Bags on sale current Duke's estate Tous Bags on sale in Mayfair, London - in memory Chanel Bags outlet of her legendary Fake Louis Vuitton Bags romance with his Coach Bags outlet besotted predecessor. It all Louis Vuitton Bags outlet started in Saumur in France's Chanel Wallets outlet Valley, where Gabrielle Bonheur Coach Wallets outlet was born to a sickly Louis Vuitton Wallets outlet in 1883 and given Prada Bags outlet the name of the nun who Jimmy Choo Bags outlet delivered her. Her mother Gucci Bags outlet died when she was Tous Bags outlet six, and when her wine merchant Discount Chanel Bags father walked out on the Discount Coach Bags family, she was sent to an Discount Louis Vuitton Bags orphanage. Gabrielle Discount Chanel Wallets proved a rebellious Discount Coach Wallets child who spent most Discount Louis Vuitton Wallets of her time with her nose Discount Prada Bags in romantic novels Discount Jimmy Choo Bags, planning to escape the Discount Gucci Bags drudgery of her peasant Discount Tous Bags background. But she was Wholesale Branded Bags also taught to sew and Wholesale Branded Wallets make hats. At 17, she became a shop Wholesale Branded Handbags assistant in a ladies' outfitters.
She was already a remarkable UGG Boots on sale beauty with a swan Black UGG Boots neck and an insouciance that Sage UGG Boots made her stand out from the Tomato Red UGG Boots crowd. Tall and tomboyish, UGG Sandals she was determined to Navy blue UGG Boots succeed - at anything Baked Clay UGG Boots - and, for a while, she sang UGG Boots 5815 in the Trocadero nightclub UGG Boots 5825 where she earned UGG Boots 5879 her nickname from UGG Classic Short Boots one of her favourite UGG Classic Tall Boots songs, Coco. She was UGG Argyle Knit Boots nearly 20 when she caught UGG Bailey Button Boots the eye of a dashing UGG Classic Cardy Boots cavalry officer from the local UGG Classic Mini Boots garrison who seduced UGG Hazel Sandals her and took her under the wing Wholesale UGG Boots of his older mistress in Paris.
If Coco was ghd Straighteners compliant in her new Discount ghd Straighteners role, she ghd Pretty in Pink was far from ghd Straighteners on sale subservient. She always ghd Precious Gift Set justified this ghd Straighteners outlet louche period by ghd Purple Gift Set declaring she found ghd Hair Straighteners society women Discount ghd Hair Straighteners boring and ghd Radiance Set courtesans much more ghd Hair Straighteners on sale dramatic with ghd Hair Straighteners outlet their heavy ghd IV Stylers make-up and Discount ghd IV Stylers hour-glass figures.
But Coco ghd IV Stylers on sale herself refused to ghd IV Stylers outlet dress like these ladies ghd outlet of the night ghd IV Salon Styler in their ghd on sale long, over-embellished frocks Wholesale ghd Straighteners that dragged in the Ray Ban Sunglasses and Armani Sunglasses lover, Arthur Capel, lent Oakley Sunglasses her the money to Chanel Sunglasses open her Dior Sunglasses first Paris Gucci Sunglasses shop near the Ritz, where Chanel still has its glamorous Police Sunglasses headquarters. By D&G Sunglasses 1916
So she bought cheap MBT VOI Shoes from department stores and Chanel Jewelry made plain dresses out of Tiffany Jewelry material, which, at the time Juicy Jewelry, was used only Cartier Jewelry for men's underclothes. Predictably, her Louis Vuitton Jewelry work was considered BVLGARI Jewelry scandalous. Even her short Chanel Jewelry on sale hairstyle was in response to necessity. One Tiffany Jewelry on sale night, her Juicy Jewelry on sale gas heater blew up, singeing Cartier Jewelry on sale her long locks Louis Vuitton Jewelry on sale. Her first thought BVLGARI Jewelry on sale was to cancel Chanel Jewelry outlet her evening's engagement Tiffany Jewelry outlet. But then she took a Juicy Jewelry outlet pair of scissors and gamely lopped Cartier Jewelry outlet a foot off her Louis Vuitton Jewelry outlet damaged tresses BVLGARI Jewelry outlet; she put a hat Chanel Bangles on and went with her Tiffany Bangles beau to the opera. Hats Juicy Bangles were to be Coco's Cartier Bangles stepping stone Louis Vuitton Bangles to sartorial greatness BVLGARI Bangles. Soon, she persuaded her rich lover Chanel Bracelets to set her up with a Tiffany Bracelets hat shop in the Juicy Bracelets provinces. Then, when he introduced her Cartier Bracelets to a powerful English Louis Vuitton Bracelets industrialist with dashing BVLGARI Bracelets film star looks called Chanel Earrings Arthur "Boy" Capel, she Tiffany Earrings spotted her opportunity. Chanel, now 26, threw Juicy Earrings herself at him, following him to Cartier Earrings Paris on the night sleeper. When he Louis Vuitton Earrings succumbed, she shamelessly played off her BVLGARI Earrings two lovers against each other Chanel Necklaces - even convincing one to buy her Tiffany Necklaces a Paris flat, Juicy Necklaces while the other Cartier Necklaces was persuaded to Louis Vuitton Necklaces open a bank account for her BVLGARI Necklaces. And all the while she Chanel Key Chains was inventing new Coach Key Chains fashions. One day it Gucci Key Chains was so cold at Louis Vuitton Key Chains the Deauville races Chanel Sweater Necklaces that she put on D&G Sweater Necklaces her Englishman Juicy Sweater Necklaces lover's sweater, tying it Wholesale Branded Jewelry at the waist.
Coco was Timberland Schuhe in her element. Timberland ブーツ She started Coach Taschen Twenties' flapper Coach バッグ fashion with its Chanel Taschen swinging pearls, Chanel バッグ short skirts and Louis Vuitton Taschen sleeveless dresses, Louis Vuitton バッグ all Prada Taschen perfect Prada バッグ for the UGG Stiefel modern woman UGG ブーツl with an ghd Haarglätter active lifestyle. And she MBT Schuhe designed the Little Black Chanel Schmuck Dress, livening Chanel ジュエリー it up with Tiffany Schmuck costume jewelry Tiffany ジュエリー - another Ray Ban Sonnenbrillen first. Soon, she Ray Ban サングラス began to attract jealous Timberland обувь criticism. Denouncing the Little Black Coach CYMKN Dress, New York society Chanel CYMKN hostess Elsa Maxwell Louis Vuitton CYMKN snarled: "She can't be Prada CYMKN in mourning for "Boy" UGG Сапоги Capel, she wasn't married to ghd для выпрямления волос him. So she's making MBT обувь the whole world wear Chanel ювелирные изделия black instead."
Coco ignored Tiffany ювелирные изделия the taunt and Ray Ban Солнцезащитные очки, in 1923, came up Timberland chaussures with one of her Coach Sacs biggest triumphs Chanel Sacs: Chanel No. 5. By now Coco Louis Vuitton Sacs was so famous Prada Sacs that the richest men UGG bottes in the world ghd défrisage des cheveux were vying MBT chaussures for her favours Chanel bijoux and, although Tiffany bijoux wealthy in her Ray Ban Lunettes de soleil own right, she Timberland zapatos vowed to make Coach bolsas life complete by marrying Chanel bolsas the second Duke of Louis Vuitton bolsas Westminster - known as Bend'Or after Prada bolsas his grandfather's chestnut UGG botas Derby winner which ghd alisadores de pelo he was said to MBT zapatos resemble. She had Chanel joyería met him on a trip Tiffany joyería to Monte Carlo Ray Ban gafas de sol. The twice-divorced Duke Timberland sapatos - a gambler and womanizer Coach Sacos - was enchanted. Coco Chanel Sacos, who was one of Louis Vuitton Sacos the first to popularise Prada Sacos the Riviera as a holiday UGG botas destination and ghd alisadores de cabelo to revel in a suntan MBT sapatos as a symbol of the Chanel jóias leisured life, Tiffany jóias entertained him at her Ray Ban óculos de sol villa in Monaco Timberland scarpe. She wore Timberland 구두 her Coach Borse new invention: Coach 가방 white Chanel Borse satin pyjamas. Chanel가방 In return, he Louis Vuitton Borse took Louis Vuitton 가방 her Prada Borse to his Prada가방 English UGG stivali country UGG 부츠 estate ghd Stiranti per capelli, where MBT 구두 he grew MBT scarpe orchids and Chanel gioielli daisies Chanel보석류 for her Tiffany gioielli. Riding with hounds Tiffany 보석류 and demonstrating a talent Ray Ban Occhiali da sole for fly-fishing Ray Ban색안경 and tennis.
|
|
|
If you want tougg classic tall boot pewter equivalent ugg classic tall sunflowera undefeated web
By ugg boots outlet on
19-8-2010 7:55 |
| If you want tougg classic tall boot pewter equivalent ugg classic tall sunflowera undefeated web ugg classic tall chestnut,designer, you exigency go into,usable, functionalugg classic tall black,,interface designs at the ugg classic tall chocolate,crux of your work. , ugg classic tall bomber boot This will contribute ,to the fleshingugg classic tall grey , out of ,not humle , ,ugg classic tall navy, your convoy ugg classic short sand, (or whatever vigor you design for),ugg classic short chestnut,,but moreoverugg classic short ultramarine,mini ugg boots, ugg classic short spiced coral ,besides,ugg classic short chocolate, furthermore,ugg classic short sale, further yourself.ugg classic short fancy,A popularugg classic short metallic, interconfront designugg classic cardy boots grey,is crucialugg classic cardy grey ,you can takeugg classic cardy black,pride in ugg classic cardy oatmeal,and leave getugg classic cardy boots black,you futureugg classic cardy fig,contracts.ugg classic cardy tall ,Clickable ugg classic cardy sale,Wireframes, ugg bailey button triplet,Usability ugg bailey boots, Testing andugg bailey button bomber,Digital Paper ugg bailey button side boots,Prototyping.ugg bailey button uk, Fast wireframeugg bailey button bomber boots,creation andugg bailey button grey,remote website ugg bailey button sale,usability testing lead to anugg bailey button boots,larger conversion! . |
|
|
|
|
replica watches |
By lfclhy13709394 on
6-9-2010 9:20 |
clothing supplier from Lincoln, said when buying tag heuer replica watches
clothing from yesteryear, shoppers needed to keep an eye out for quality and individualityShe said: "tag heuer grand carrera replica watches
Investing in a piece of vintage clothing is exciting and will inevitably pay off in the long run"But you need to keep your eyes peeled for the real quality buys There's viwc replica watches
a lot out there and not all of it is in the best conditionhe winter is arctic and the economy is a long way from spring, tag heuer grand carrera replica watches
but commodities are hot again. Gold, the doomsters' favourite,
|
|
|
|
|
|
|
|
|
|