Useful Sql'y stuff that I've picked up over the years

This session is for your average .NET Developer who does SQL rather than those who are dedicated SQL Developers (that's not to say you won't pick up interesting tips). This is some of the stuff that I have learned over the years which you might find useful. This session is completely from a .NET developers perspective and the things that have helped me out when working with SQL Server. We will be looking at T-SQL, parts of the SQL Server Toolset, SQL Server commands etc. Hopefully by the end of this session you will come away with some useful stuff that you will be able to use in your day to day life. I will try and skip theory and best practice, and go with loose observations as much as possible.

Chris Hay

Chris is regularly caught by his wife browsing internet sites at 2.00am in the morning. Sadly he is always looking at .NET sites rather than the haunts frequented by his peers. Chris has worked on various large projects and is specialised in C#, ASP.NET, AJAX, SQL and various other acronymns. Having always tried to keep at the front of the technology curve, i guess it is time to share that knowledge around a little. Simple tip, never mention Silverlight infront of him (if you are in a hurry). You can catch him on his blog http://silverlightuk.blogspot.com

Chris Hay's blog http://silverlightuk.blogspot.com

---

Downloads

File Type Ext ContentName Zip File .zip Samples Presentation .pptx Slide Deck

<< 1 >>

---

Other sessions from this conference

A Testing Time...

A walk down memory lane

Advanced T-SQL (2005 and 2008)

Choices, Choices - Loading and Modelling Slowly Changing Dimensions in the SQL Server 2008 Suite

Data Vizualisation - Make your reports useful to business - No more "Speed Dials"

Does your cube support your users reporting needs?

Don't try this at work !

End to End Report Creation and Management using Microsoft SQL Server 2008

Getting more value from your data through data mining.

Head in the Cloud...

How to approach zero downtime database upgrades

Indexes Basically

Microsoft's integrated end-to-end BI offering.

Performance Monitoring Using SQL Server Management Studio - power of Management Data Warehouse

Small Problem - Simple Solution: Lookup Tables

SQL Server – Under New Management

SQL Server 2008 for Developers

Understanding Query Cache and Query Plans

Where’s my data? An introduction to Spatial Queries in SQL Server 2008