The Curious Engineer

All blogs / Databases

Dave does Data

learn.microsoft.com/en-us/archive/blogs/davidlean

Tutorials, Performance Tuning, Tips & Techniques on SQL Server & its ecosystem.

DatabasesDev tools / editors / IDEsMicrosoft blogsMSDN archive

’10’15’20’25
Posts
34 from 16 Oct 2008 to 28 Nov 2010
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/davidlean/feed.xml

2010 7

  1. TSQL Tips: Writing more efficient DDL (Data Definition Language) with system functions
  2. Handy Links for SQL 2008 R2 & .NET Development
  3. Apple headline I’d like to see ;-)
  4. SQL 2008 R2 RTM’s check out the free training
  5. Get the Data Mining Add-ins made for you
  6. Geek Australian, N.Z, UK .NET Comedy
  7. Ultimate Resource for File Extensions

2009 17

  1. Review: Programming MS SQL Server 2008 – Holistic coverage for an App Developer
  2. Tip: Avoiding REALLY hard to reproduce bugs in Production
  3. Tip SSMS: How to quickly find the line with the Syntax error
  4. How to get Database Edition Power Tools to work on Visual Studio Team System 2008 Database Edition GDR
  5. TSQL Tips: The correct way to write your Scripts – ALTER PROC, don’t DROP & CREATE PROC
  6. More FREE training for Developers & DBA’s
  7. News: Look at the CTP3 of our upcoming Distributed Cache technology - Velocity
  8. Get SQL Server 2008 for FREE: FREE Database, FREE Reporting Solution, FREE Spatial
  9. SQL Server 2008: April 09 Updates – Handy links
  10. Teach your Kids to Program these school Holidays
  11. SQL Server 2008 Jumpstart Materials – very detailed training, now FREE to download.
  12. SQL Server 2008 SP1 - Released
  13. Tip: Make your Identity Keys go Further
  14. Boost your Bottomline – BI Breakfast with New Horizons
  15. SQL Reporting "How to" - Conditional Color 1/4: The Basics. Report Expressions & Custom Code
  16. SQL Reporting "How to" - Conditional Color 2/4: Functions for Tables & Charts
  17. SQL Reporting "How to" - Conditional Color 3/4: Tint & Shade Functions

2008 10

  1. Resource Recommendations - Data Mining
  2. Steve Ballmer Event SOLD OUT - But you can sneak in, online.
  3. SQL 2008 - Ways to architect Spatial apps
  4. SQL 2008 Spatial Samples, Part 1 of 9 - How to Learn SQL Spatial
  5. SQL 2008 Spatial Samples, Part 2 of 9 - Background on Spatial Types & Well Known Text (WKT)
  6. SQL 2008 Spatial Samples, Part 3 of 9 - SQL Builder API
  7. SQL 2008 Spatial Sample, Part 4 of 9 - Methods for Drawing Spatial Shapes
  8. SQL 2008 Spatial Samples, Part 7 of 9 - STBuffer ... Spatial starts here.
  9. Handy sample Connection Strings
  10. SQL 2008 Spatial Samples, Part 9 of 9 - Handy but Obvious Methods