This post is not about a unique body of work, it is just a list of links to materials I’ve found useful. I hope it may make it easier for me to point people here rather than have them write down or remember URL’s
If you are looking for SQL Add-in’s, Utilities, Sample Code & education, perhaps you will find this useful to you too.
SQL 2008 R2 Links
Microsoft SQL Server – Official Microsoft SQL server Site Resources for 2008 R2 – Handy Resources (Marketing, Pricing & Technical)
Microsoft® SQL Server® 2008 R2 Feature Pack (7th Jun 10) includes :-
Microsoft Report Viewer 2010 Redistributable Package Lets you embed SQL Reports into your Windows Forms & Web applications. Brian Hartman's Report Viewer Blog – Nice value add on adding reports into your application.
Sample Databases for Microsoft SQL Server 2008 R2 (RTM) – Updated Adventure Works, Northwind etc.
SQL 2008 Performance Tools
Not a comple list but a few of my favourites
Replay Mark-up Language (RML) Utilities RML Utilities for SQL Server (x86) RML Utilities for SQL Server (x64) RML is an awesome utility for analysing load on SQL Server & for creating a load.
SQL Load Test – This is a handy utility for creating Visual Studio Load Tests from a SQL Profiler Trace. While far from a complete solution (as it doesn’t handle a lot of SQL Syntax) it does speed the process somewhat. I hope to enhance it in time.
NodeXL: Network Overview, Discovery and Exploration for Excel – I find this handy to visualise the SQL Object Dependence within a database. ie: Quickly seeing that this SP calls 2 others & they call a function or two that reference views & tables. OR how many objects touch this table & how many reference them all.
I see huge potential in using Visual Studio to perform Load tests, Stress Tests & to ensure quality when you are rewriting TSQL code. Unfortunately it is missing a small number of features &/or hooks that make the whole exercise marginal value. One day, soon I hope to have coded up extensions to fix those feature gaps.
Using Visual Studio 2005 to Perform Load Testing on a SQL Server 2005 Reporting Services Report Server – Old article but helps setup Web Testing on SQL RS
Introducing New Features In The VSTS Database Edition GDR
Apply Test-Driven Development to your Database Projects – This article shows how to write the 2 custom tests that make DB tests kinda useful. (Without them, don’t bother)
Database Unit Testing with Team Edition for Database Professionals – Walk thru on creating a DB Unit Test.
Microsoft® Visual Studio Team System 2008 Database Edition Power Tools – Tantalisingly nice add-in, likely to not work on your system as the GDR release broke much of it.
How to get Database Edition Power Tools to work on Visual Studio Team System 2008 Database Edition GDR
SQL 2008 Samples, Training, Whitepapers
Microsoft SQL Server Community Projects & Samples - Loads of great Code Samples
SQL Server Customer Advisory Team - SQL Server Best Practices – Whitepapers from the SQL Dev Team tasked with tuning the largest SQL Customer implementations. SQLCAT Community Projects and Code Samples – Nice set of handy add-ins
SQL Server 2008 R2 Update for Developers Training Kit (June 2010 Update) Videos, Presentations, Demo’s & Hands-On-Labs to get you up to speed on using the new capability of SQL Server 2008 R2. Includes the 2008 stuff too.
General Dev Resources
Tech-Ed Online Great technically deep Webcasts on a vast number of topics.
MSDN Magazine – Good articles on new technologies that all developers should scan.
Development Samples, Training, Whitepapers
All-In-One Code Framework! - framework and skeleton of Microsoft development techniques through typical sample codes in three popular programming languages (Visual C#, VB.NET, Visual C++).
Visual Studio 2010 and .NET Framework 4 Training Kit – Presentations, Hands-On Labs, Demos on; Entiry Framework, C#, VB.NET, F#, ADO.NET Data Services, WPF, WCF, Parallel Extensions, Windows Workflow, ASP.NET, VS Team System & More.
ADO.NET Entity Framework & LINQ to Relational Data – Samples for EF & Link
Microsoft Patterns & Practices - Enterprise Library - The Microsoft Enterprise Library is a collection of reusable software components (application blocks) designed to assist software developers with common enterprise development challenges. Enterprise Library Contribution Project – Extensions people have added to make it even easier.
Microsoft Silverlight – The Official Microsoft Silverlight Site. Good Tutorials, SDK, Downloads, Samples. etc
Silverlight 4 Training – Detailed Whitepapers & Labs to guide you to build business level applications
Microsoft XAML Toolkit CTP - July 2010 - Microsoft XAML Toolkit is a set of libraries enabling easier manipulation and analysis of XAML for .NET 4.0 and Silverlight.
Blacklight - Controls for Designers! Blacklight is a UX focused code sharing project. collection of controls, samples, visual assets and ideas that has been put together by User Experience designers and developers to both show you what the technology is capable of (from a UX point of view),
ASP.NET AJAX Control Toolkit rich set of 40+ controls that you can use to build highly responsive and interactive Ajax-enabled Web applications.
ASP.NET QuickStart – Sample ASP Apps for Web folks
WindowsClient.NET – The Official Microsoft Site for Windows Forms & Windows Presentation Foundation
Windows Presentation Foundation (WPF) - WPF Toolkit and the WPF Futures releases.
Expresso 3.0 – Brilliant tool to assist anyone writing Regular Expressions (REGEX). Essential for Data Cleansing, Screen Scraping & a variety of SSIS uses. (free tool from Jim Hollenhorst of Ultrapico)
VBA for Excel (Macros) – Nice set of 33 lessons that cover how to get VBA Macros working in Excel.
Excel VBA Macro Codes Tips & Tricks
Julian's Excel Macro (VBA) Tips for Beginners
---< END >---
Thought for the post: If a Bedding Store is having a 50% off sale, & you buy a Double bed, will they deliver a Single bed? If you buy a single bed with a “2 for 1” coupon & they deliver a Double bed, did you get what you paid for?