Professional Experience - Articles
Writing provides a great outlet for sharing what I know and love about SQL Server.
Blogs
I currently maintain two blogs:
- Practical SQL Server - with SQL Server Magazine.
- SSV Updates - at www.sqlservervideos.com.
Articles
Links to many (but not all) of the articles I've written as a consultant are listed below:
SQL Server Pro (Author Index)
I've written numerous articles for SQL Server Pro (formerly SQL Server Magazine) over the years, and became a contributing editor in 2010.
- Review: ScaleArc iDB 2.0
- Don't Forget About Backup Compression
- SQL Server 2012 Contained Databases
- SQL Injection - Beyond the Basics
- 12 Part Blog Series on SQL Server Corruption
- Troubleshooting Common SQL Server Problems
- Troubleshooting Performance Problems in Entity Framework Applications
- Review: SQL Source Control 2.2
- Review: SQL Prompt 5.1
- Essential Resources for DBAs
- Performance Advisor for SQL Server 5.5 (Exclusive / Print-Only)
- Review: Toad for SQL Server 5.0 Professional Edition
- Confusing High Availability with Disaster Preparedness
- The Essential Guide to Mission-Critical SQL Server Environments
- Starting My Wish List for Visual Studio Next
- Review: Altova DatabaseSpy 2010
- Review: ComponentOne LiveLinq
- Quoted In: SQL Server Backup and Recovery Software
- SQL Server Comparison and Synchronization Tools
- Review: SQL defrag manager 2.5
- Review: Toad for SQL Server
- Maximize Storage Performance
- Using SQL Server 2008 FILESTREAM Storage
- Review: Miner3D 7.1
- Review: SQL Data Generator
- Optimizing OLTP Performance
- Review: SQL Compare 6.2
- Performance Secrets for SQL Server Developers
- Review: Spotlight on SQL Server 5.7
- Review: Hit Software's DBMoto 5.0
- When SQL Server Tool Vendors Compete, DBAs Win
- Editing T-SQL: The Road to Perfection
- Shrink-Wrapped DBAs
- BMC's SmartDBA
DevConnectionsPro (Author Index)
The following list of articles is non-complete - but includes some of my SQL Server focused articles along with some other development-focused articles as well.
- SQL Server Performance Tip: Favoring TCP/IP over Named Pipes
- SQL Server 2012: Top New Features for .NET Developers
- SQL Server Denali for Developers: Part I
- SQL Server Denali for Developers: Part II
- New Features in SQL Server Denali CTP3 for Developers
- A Look Ahead at "Denali" - The Upcomming Release of SQL Server
- Enabling SQL Server AWE Memory
- Generating High-Performance SQL Server Query Results
- The Entity Framework and ORMs: Understand the Trade-offs
- Keep Your Eyes on Microsoft's SQL Azure
- SQL Server High Availability for Developers - Part 1
- SQL Server High Availability for Developers - Part 2
- SQL Server High Availability for Developers - Part 3
- SQL Server High Availability for Developers - Part 4
- The SQL Server Security Issue That Wasn't
- Free SQL Server Resources for Developers
- The SQL Server Community: A Welcoming Place for Newbies
- A Classic Security Challenge: SQL Profiler and "Password" Text
- Test Driving Database and Developer Consultants
- T-SQL Upgrades in SQL Server 2008
- Why Can't SQL Server and Visual Studio Get Along?
- Microsoft has a Public Relations Problem
- Microsoft Azure and the Allure of 100 Percent Application Availability
- PLINQO: Keeping LINQ-to-SQL Viable
- Examining the Hype around NoSQL
- Windows 8 For Luddites
- Microsoft Windows 8 Metro UI: One Size Does Not Fit All
- Boost Your Coding Productivity
- Back to Basics: The Key to Mastering Software Development
- Optimizing Use of ASP.NET Cache Functionality
- ASP.NET MVC, SEO, and NotFoundResults: A Better Way to Handle Missing Content
- Making the Most of ELMAH ASP.NET Error Logging
- A Perfect Storm: LINQ to SQL, Dependency Injection, and ASP.NET Providers
- App Stores and the Rise of Mobile Development
- More Great Free Tools for .NET Developers
- Visual Studio 2010 SP1 and IIS Express
- The Law of Abominable Abstractions
- Microsoft Windows 8: What it Means for .NET and Silverlight Developers
- Windows Azure and the Future of .NET Development
- Improve Your Dev UX: Disable Visual Studio Toolbars
- Visual Studio 2010 SP1 and IIS Express
- Using IoC with Structure Map 2.6 and MVC 3.0
- Security Changes in ASP.NET MVC V2: Good News for Developers?
- Protecting Legacy Web Applications with AntiXSS
- .NET Framework Administration Woes
- Hands-Off Coding: Boosting Productivity
- Good Project Planning: Establishing Project Champions
- Leveraging the ASP.NET ReportViewer Control
- Smart Hardware Purchases for Developers
- Design By Committee and Other Bad Ways to Plan Development Projects
- ASP.NET MVC Official Release
- ASP.NET MVC and Search Engine Optimization
- Developing Web 2.0 Websites that Engage your Community
- Microsoft Visual Studio 2008 Improvements
- Visual Studio LightSwitch and WebMatrix: Are They Good for Professional Developers?
- Microsoft Web Matrix: What's In It for Dev Professionals?
- Visual Studio vNext: My Wish List
- Thumbs Up on Visual Studio 2010
- Amazon's S3 for ASP.NET Web Developers
- Add Paging Functionality to your ASP.NET MVC Site
- Kick ASP.NET Providers to the Curb
- Predictions on the Future of ASP.NET
- Seamlessly Localizing ASP.NET MVC Views
- Customizing ASP.NET MVC View Results
- ASP.NET MVC Localization
- Take the Plunge with ASP.NET MVC
- IE9: A Leap in the Wrong Direction
WindowsIT Pro Magazine (Author Index)
- Essential Guide: Optimizing OLTP Performance
- Performance Secrets for SQL Server Developers
- dtSearch 7 Desktop with Spider
- DeviceShield
SQLTeam.com
ASPAlliance.com (Author Index)
- Using SoftArtisans OfficeWriter with SQL Server Reporting Services 2005
- Book Review: The Rational Guide to SQL Server Reporting Services
- Book Review: HitchHiker's Guide to SQL Server 2000 Reporting Services
Idera's WhitePapers and Other Resources
I've also written a couple of white-papers and 'Tips' for Idera.
- Essential Performance Tools for SQL Server DBAs
- Increase SQL Server Performance With the Hardware You Already Own
- Managing Complex Database Changes
- Surviving Database Disasters
- Migrating SQL Server Logins
- Tips for Auditing Merge Replication
Microsoft Developer Network (MSDN - Coding4Fun)
- Building an XSL Transform Tool
- Harnessing the BackPack API - Part I
- Harnessing the BackPack API - Part II
- Harnessing the BackPack API - Part III
- Harnessing the BackPack API - Part IV
Total Articles/Resources Listed: 120
