Presentation: What I Wish Developers Knew About SQL Server

By Bill Graziano on 17 November 2005 | 18 Comments | Tags: Application Design, Presentations

My apologies for taking so long to post this. I've finally uploaded the PowerPoint slides from "What I Wish Developers Knew About SQL Server." I presented this at PASS 2005 in Dallas, the Kansas City SQL Server Users Group, the Kansas City .NET SIG, a couple of clients and any other group I could find that would listen to it. All the deliveries really helped make the PASS presentation smooth and polished. Thanks to all that attended.

Discuss this article: 18 Comments so far. Print this Article. This page has been read 12,133 times.

If you like this article you can sign up for our newsletter. We send it out each week that we post a new article. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Email This • Subscribe to this feed • Kick it • Save to del.icio.us • View blog reactions

Application Locks (or Mutexes) in SQL Server 2005 (7 January 2008)

What I Wish Developers Knew About SQL Server (Presentation) (11 October 2007)

Speaking in Jacksonville and Orlando on October 8th & 9th, 2007 (4 October 2007)

Multiple Active Result Sets (MARS) – Transactions and Debugging (17 June 2007)

Multiple Active Result Sets (MARS) (3 April 2007)

SQL Server Express 2005 Tips and Tricks Presentation (6 March 2007)

SQL Server 2005 Express Tips and Tricks Web Cast (26 February 2007)

PASS 2006 Presentation: What I Wish Developers Knew About SQL Server 2005 (15 December 2006)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email:

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

- Sponsor's Message -

SQLShare.com Videos

Renaming a Database

You won't do it often, but it's nice to know how, and you're not still using sp_renamedb are you? Join us for a quick look at how to use the alter syntax to change the db name along with a tip on how to quickly disconnect any remaining users from the database.

File Share Subscriptions in Reporting Services

Whether you want to generate PDF invoices for customers or do a daily export that will get processed by one of your vendors, the ability to deliver reports to a file share is a useful and simple feature baked in to Reporting Services. In this lesson Devin will show you how to do it and how to set most of the common options.

File Share Subscriptions in Reporting Services

Using DB_ID and DB_Name Functions

Simple but effective, DB_ID and DB_Name give you a concise way to look up the id of a database from a name, or look up the name of a database from an id. There are times when you'll need to write the join to sys.sysdatabases, but when all you need is a quick conversion, these functions get it done.

Using @@Total_Read and @@Total_Write

Ever wondered how many physical reads and writes your SQL service is doing? Yes, it may seek a bit geeky, but it's often useful to have an idea if a server is read or write heavy. @@Total_Read and @@Total_Write show you the number of physical (not logical) reads since the last service restart, and from there we can easily calculate a percentage of reads if needed.