# Monday, July 14, 2003

Efficient Data Retrieval?

Is that a good title for an MSDN WebCast? Who knows? But then again, when have I ever did anything normal?

For those of you who did not see this popular session in Dallas at TechEd or can't make it on out to Kuala Lumpur, Malaysia for TechEd in late August, you can catch this session Thursday at 2pm EST via an MSDN WebCast.

When Microsoft asked me to put together this session back in February for TechEd Dallas, I had no idea how to approach it. Target the DBA, TSQL Programmer, or VB/C# programmer? I am not a DBA, not even close. I also don’t think that I am a full time “TSQL Programmer”, even though I spend hours each day writing TSQL. I use to be a full time VB/C# developer, but now as “CTO” of my company, I spend more time architecting and managing than coding, but I still do write a fair amount of C# code each day. (Epically when my developer calls in sick and we have deadlines!)

So I took a radical approach (or what I call the Bill Clinton approach) and tried to be all things to all people. Most small firms in this economic downturn don’t have a full time DBA, SQL Programmer and VB/C# developers on staff. Some times the DBA is the TSQL Programmer and sometimes the VB/C# developer is the TSQL Developer. When I polled the over 700 people who attended this session at TechED, only a handful of the crowd was only one of these jobs, a vast number were all three. This is bad, I am a firm believer in splitting the role of DBA and TSQL programmer as full time positions. But I understand the economic times so this session was born.

So the WebCast? We start with some TSQL code to make data retrieval from SQL Server easier and smarter. (We will talk about the obscure but totally powerful The Rozenshtein Method that my pal Richard Campbell showed me and like being unplugged from the Matrix for the first time I had an epiphany about my relationship with TSQL). After we talk about TSQL we will hit some classic DBA issues, l mostly about indexes and file groups. Then we will move on into taking advantage of this stuff from ADO .NET, all the tips and tricks that the VB/C# developer will enjoy. So there is something for everyone, hope to see you there. You can sign up for it here.

Here is the abstract:

Take a look at how to optimize using Stored Procedures for efficient and secure data retrieval in the middle tier of your Web, Windows, mobile and Web services applications. Learn how to do crosstab queries for reporting that take seconds to execute instead of hours, exploiting sub-queries and taking advantage of self-joining. Explore performance tuning from the perspective of stored procedures used for data retrieval. Look at how to get a higher cache-hit ratio, efficient index creation and utilization and how to guarantee that ADO.NET takes advantage of these optimizations. Focus on squeezing the last bit of performance out of ADO.NET. Look at how to best architect your application to take advantage how ADO.NET was designed to work with data in a disconnected. Look at comparisons between the DataSet and the DataReader, and an explanation of the best use for each of these objects. Look at techniques for using multiple result sets in one DataReader or DataSet for efficient client databinding, using stored procedures for dynamic sorting, proper connection pooling, optimizing connections with the DataAdapter, and ExecuteScalar vs. ExecuteNonQuery comparisons.  

posted on Monday, July 14, 2003 11:53:45 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [15] Trackback
Monday, May 16, 2005 2:29:37 AM (Eastern Daylight Time, UTC-04:00)
You may find it interesting to check the sites dedicated to slot machines http://www.alleghenydist.net/slot-machines.html
Tuesday, May 31, 2005 8:59:57 AM (Eastern Daylight Time, UTC-04:00)
You may find it interesting to visit the sites about loans http://www.racepointfunding.com/loans.html
home loans http://www.racepointfunding.com/home-loans.html
payday loans http://www.racepointfunding.com/payday-loans.html
home equity loan http://www.racepointfunding.com/home-equity-loan.html
payday loan http://www.racepointfunding.com/payday-loan.html
refinance http://www.racepointfunding.com/refinance.html
personal loans http://www.racepointfunding.com/personal-loans.html
debt consolidation loan http://www.racepointfunding.com/debt-consolidation-loan.html
payday advance http://www.racepointfunding.com/payday-advance.html
credit card offers http://www.racepointfunding.com/credit-card-offers.html
Thursday, June 2, 2005 5:01:28 PM (Eastern Daylight Time, UTC-04:00)
In your free time, check out some helpful info dedicated to online poker site http://www.progressiveupdate.net/online-poker.html
poker games http://www.progressiveupdate.net/poker-games.html
party poker http://www.progressiveupdate.net/party-poker.html
pacific poker http://www.progressiveupdate.net/pacific-poker.html
empire poker http://www.progressiveupdate.net/empire-poker.html
poker rules http://www.progressiveupdate.net/poker-rules.html
texas hold em http://www.progressiveupdate.net/texas-hold-em.html
free poker http://www.progressiveupdate.net/free-poker.html
poker http://www.progressiveupdate.net/poker.html
texas holdem http://www.progressiveupdate.net/texas-holdem.html
- Tons of interesdting stuff!!!
Monday, June 6, 2005 6:21:43 PM (Eastern Daylight Time, UTC-04:00)
Please check the sites in the field of online casino gambling http://www.djsdesigns.net/online-casino.html
online casinos http://www.djsdesigns.net/online-casinos.html
slot machines http://www.djsdesigns.net/slot-machines.html
casino on net http://www.djsdesigns.net/casino-on-net.html
casino games http://www.djsdesigns.net/casino-games.html
casino gambling http://www.djsdesigns.net/casino-gambling.html
internet casino http://www.djsdesigns.net/internet-casino.html
online casino gambling http://www.djsdesigns.net/online-casino-gambling.html
casino online http://www.djsdesigns.net/casino-online.html
roulette http://www.djsdesigns.net/roulette.html
Wednesday, June 8, 2005 11:26:50 AM (Eastern Daylight Time, UTC-04:00)
Please check out the sites dedicated to online poker http://www.poker-4-u.com/online-poker.html
... Thanks!!!
Friday, June 10, 2005 8:05:15 AM (Eastern Daylight Time, UTC-04:00)
Please check out the sites dedicated to blackjack http://www.epraha.info/blackjack.html
Friday, June 10, 2005 5:56:50 PM (Eastern Daylight Time, UTC-04:00)
You may find it interesting to visit some relevant pages about payday loans http://www.money-4me.com/payday-loans.html
refinance http://www.money-4me.com/refinance.html
payday advance http://www.money-4me.com/payday-advance.html
credit card offers http://www.money-4me.com/credit-card-offers.html
free credit reportr http://www.money-4me.com/free-credit-reportr.html
mortgage calculator http://www.money-4me.com/mortgage-calculator.html
mortgage http://www.money-4me.com/mortgage.html
mortgage rates http://www.money-4me.com/mortgage-rates.html
mortgage calculators http://www.money-4me.com/mortgage-calculators.html
home equity loans http://www.money-4me.com/home-equity-loans.html
free credit report without a credit card http://www.money-4me.com/free-credit-report-without-a-credit-card.html
credit bureaus http://www.money-4me.com/credit-bureaus.html
mortgage loans http://www.money-4me.com/mortgage-loans.html
refinance mortgage http://www.money-4me.com/refinance-mortgage.html
car loans http://www.money-4me.com/car-loans.html
countrywide mortgage http://www.money-4me.com/countrywide-mortgage.html
home mortgage loan http://www.money-4me.com/home-mortgage-loan.html
free credit check http://www.money-4me.com/free-credit-check.html
student loan consolidation http://www.money-4me.com/student-loan-consolidation.html
consumer credit counseling http://www.money-4me.com/consumer-credit-counseling.html
personal loan http://www.money-4me.com/personal-loan.html
free porn no credit card http://www.money-4me.com/free-porn-no-credit-card.html
discover credit card http://www.money-4me.com/discover-credit-card.html
mortgage rate http://www.money-4me.com/mortgage-rate.html
mortgage lenders http://www.money-4me.com/mortgage-lenders.html
car loan calculator http://www.money-4me.com/car-loan-calculator.html
loan calculators http://www.money-4me.com/loan-calculators.html
bad credit mortgage http://www.money-4me.com/bad-credit-mortgage.html
free copy of credit report http://www.money-4me.com/free-copy-of-credit-report.html
mortgage broker http://www.money-4me.com/mortgage-broker.html
... Thanks!!!
Friday, June 17, 2005 5:06:02 PM (Eastern Daylight Time, UTC-04:00)
Take your time to take a look at some information about online casino http://www.splendid-casino.com/online-casino.html
online casinos http://www.splendid-casino.com/online-casinos.html
slot machines http://www.splendid-casino.com/slot-machines.html
casino on net http://www.splendid-casino.com/casino-on-net.html
casino games http://www.splendid-casino.com/casino-games.html
casino gambling http://www.splendid-casino.com/casino-gambling.html
internet casino http://www.splendid-casino.com/internet-casino.html
online casino gambling http://www.splendid-casino.com/online-casino-gambling.html
casino online http://www.splendid-casino.com/casino-online.html
roulette http://www.splendid-casino.com/roulette.html
Wednesday, June 22, 2005 12:22:10 PM (Eastern Daylight Time, UTC-04:00)
You may find it interesting to take a look at some relevant information about video poker strategy http://www.wow-poker.com/video-poker-strategy.html
poker card game http://www.wow-poker.com/poker-card-game.html
poker web site http://www.wow-poker.com/poker-web-site.html
poker bot http://www.wow-poker.com/poker-bot.html
party poker million http://www.wow-poker.com/party-poker-million.html
free texas holdem game http://www.wow-poker.com/free-texas-holdem-game.html
poker tracker http://www.wow-poker.com/poker-tracker.html
texas hold em download http://www.wow-poker.com/texas-hold-em-download.html
five card stud http://www.wow-poker.com/five-card-stud.html
holdem rule http://www.wow-poker.com/holdem-rule.html
texas holdem tournament rule http://www.wow-poker.com/texas-holdem-tournament-rule.html
free texas hold em download http://www.wow-poker.com/free-texas-hold-em-download.html
omaha hi lo strategy http://www.wow-poker.com/omaha-hi-lo-strategy.html
playing strip poker online http://www.wow-poker.com/playing-strip-poker-online.html
texas hold em sites http://www.wow-poker.com/texas-hold-em-sites.html
texas holdem poker tips http://www.wow-poker.com/texas-holdem-poker-tips.html
texas hold em table tops http://www.wow-poker.com/texas-hold-em-table-tops.html
wsop texas holdem rules http://www.wow-poker.com/wsop-texas-holdem-rules.html
bossier city holdem http://www.wow-poker.com/bossier-city-holdem.html
hold em questions http://www.wow-poker.com/hold-em-questions.html
online free texas hold em no download http://www.wow-poker.com/online-free-texas-hold-em-no-download.html
texas hold em poker game for lg 3100 cell phone http://www.wow-poker.com/texas-hold-em-poker-game-for-lg-3100-cell-phone.html
texas hold emnon profit http://www.wow-poker.com/texas-hold-emnon-profit.html
texas holdem download free http://www.wow-poker.com/texas-holdem-download-free.html
no limt hold em tips http://www.wow-poker.com/no-limt-hold-em-tips.html
omaha hi lo starting hands http://www.wow-poker.com/omaha-hi-lo-starting-hands.html
online poker rooms that use western union http://www.wow-poker.com/online-poker-rooms-that-use-western-union.html
poker online popup ad http://www.wow-poker.com/poker-online-popup-ad.html
6person plug n play texas hold em http://www.wow-poker.com/6person-plug-n-play-texas-hold-em.html
texas hold em probable winning hand http://www.wow-poker.com/texas-hold-em-probable-winning-hand.html
Thursday, June 23, 2005 8:26:40 AM (Eastern Daylight Time, UTC-04:00)
You may find it interesting to visit the sites in the field of play free poker for fun http://www.wow-poker.com/play-free-poker-for-fun.html
poker room http://www.wow-poker.com/poker-room.html
strip poker games http://www.wow-poker.com/strip-poker-games.html
poker table felt http://www.wow-poker.com/poker-table-felt.html
dog playing poker http://www.wow-poker.com/dog-playing-poker.html
texas holdem tips http://www.wow-poker.com/texas-holdem-tips.html
rebel poker http://www.wow-poker.com/rebel-poker.html
play poker game http://www.wow-poker.com/play-poker-game.html
poker pictures http://www.wow-poker.com/poker-pictures.html
poker shirts http://www.wow-poker.com/poker-shirts.html
free poker chips http://www.wow-poker.com/free-poker-chips.html
texas holdem poker set http://www.wow-poker.com/texas-holdem-poker-set.html
poker online no download http://www.wow-poker.com/poker-online-no-download.html
online poker review http://www.wow-poker.com/online-poker-review.html
learning to deal texas hold em http://www.wow-poker.com/learning-to-deal-texas-hold-em.html
cheats and hacks for online poker http://www.wow-poker.com/cheats-and-hacks-for-online-poker.html
how to cheat at texas holdem http://www.wow-poker.com/how-to-cheat-at-texas-holdem.html
how to play nolimit holdem tournament http://www.wow-poker.com/how-to-play-nolimit-holdem-tournament.html
texas hold em omaha http://www.wow-poker.com/texas-hold-em-omaha.html
copenhagen online poker codes http://www.wow-poker.com/copenhagen-online-poker-codes.html
holdem software http://www.wow-poker.com/holdem-software.html
non gambling texas hold em poker sites http://www.wow-poker.com/non-gambling-texas-hold-em-poker-sites.html
texas hold em winning hands http://www.wow-poker.com/texas-hold-em-winning-hands.html
texas holdem poker table tops http://www.wow-poker.com/texas-holdem-poker-table-tops.html
free play online poker http://www.wow-poker.com/free-play-online-poker.html
playing poker online for a living http://www.wow-poker.com/playing-poker-online-for-a-living.html
free poker seven card stud no download http://www.wow-poker.com/free-poker-seven-card-stud-no-download.html
partypoker money hack http://www.wow-poker.com/partypoker-money-hack.html
partypoker scanner cheat hack http://www.wow-poker.com/partypoker-scanner-cheat-hack.html
stud card pics http://www.wow-poker.com/stud-card-pics.html
- Tons of interesdting stuff!!!
Tuesday, July 26, 2005 8:24:13 AM (Eastern Daylight Time, UTC-04:00)
Take your time to check out some information dedicated to party poker cheats http://www.varied-poker.com/party-poker-cheats.html
game party poker http://www.varied-poker.com/game-party-poker.html
poker books http://www.varied-poker.com/poker-books.html
party poker bonus codes http://www.varied-poker.com/party-poker-bonus-codes.html
500 115g texas holdem chip poker set http://www.varied-poker.com/500-115g-texas-holdem-chip-poker-set.html
making money playing poker online http://www.varied-poker.com/making-money-playing-poker-online.html
world poker tour online http://www.varied-poker.com/world-poker-tour-online.html
download texas hold em http://www.varied-poker.com/download-texas-hold-em.html
texas hold em rules poker full house http://www.varied-poker.com/texas-hold-em-rules-poker-full-house.html
holdem poker odds http://www.varied-poker.com/holdem-poker-odds.html
poker strategy texas holdem http://www.varied-poker.com/poker-strategy-texas-holdem.html
texas hold em downloads http://www.varied-poker.com/texas-hold-em-downloads.html
poker online for a living http://www.varied-poker.com/poker-online-for-a-living.html
texas hold em betting rules http://www.varied-poker.com/texas-hold-em-betting-rules.html
history of 7 card stud http://www.varied-poker.com/history-of-7-card-stud.html
how to cheat at texas holdem http://www.varied-poker.com/how-to-cheat-at-texas-holdem.html
online poker games for mac computers http://www.varied-poker.com/online-poker-games-for-mac-computers.html
texas holdem no download http://www.varied-poker.com/texas-holdem-no-download.html
virtual texas holdem http://www.varied-poker.com/virtual-texas-holdem.html
win texas hold em http://www.varied-poker.com/win-texas-hold-em.html
online holdem inspector formulas http://www.varied-poker.com/online-holdem-inspector-formulas.html
online strip poker babes http://www.varied-poker.com/online-strip-poker-babes.html
online texas poker http://www.varied-poker.com/online-texas-poker.html
texas hold em online strategy http://www.varied-poker.com/texas-hold-em-online-strategy.html
texas holdem decision training http://www.varied-poker.com/texas-holdem-decision-training.html
texas hold em tournaments in iowa http://www.varied-poker.com/texas-hold-em-tournaments-in-iowa.html
cardinals professional texas hold em poker set http://www.varied-poker.com/cardinals-professional-texas-hold-em-poker-set.html
free games texas hold em http://www.varied-poker.com/free-games-texas-hold-em.html
free internet poker 7 card stud http://www.varied-poker.com/free-internet-poker-7-card-stud.html
omaha hi lo point count http://www.varied-poker.com/omaha-hi-lo-point-count.html
Thursday, September 22, 2005 2:42:47 AM (Eastern Daylight Time, UTC-04:00)
You may find it interesting to take a look at the pages in the field ofhttp://www.golfshoot.com/texas-holdem.html#-gambling-
- Tons of interesdting stuff!!!
Tuesday, October 18, 2005 6:25:08 AM (Eastern Daylight Time, UTC-04:00)
You may find it interesting to check out the pages dedicated tohttp://www.seniordate.net/#-pill-
- Tons of interesdting stuff!!!
Tuesday, November 22, 2005 11:36:26 PM (Eastern Standard Time, UTC-05:00)
The doctor of the future will give no medication, but will interest his patients in the care of the human frame, diet and in the cause and prevention of disease.
Wednesday, November 23, 2005 2:45:03 AM (Eastern Standard Time, UTC-05:00)
The person who tries to live alone will not succeed as a human being. His heart withers if it does not answer another heart. His mind shrinks away if he hears only the echoes of his own thoughts and finds no other inspiration.
Comments are closed.