Professional Experience - Writing
I'm passionate about SQL Server and technology in general. As such, writing provides a great outlet for sharing what I know and love about SQL Server and other technologies.
Blogging
In the past I've maintained two differet blogs at various times:
- Practical SQL Server
- SQL Server Videos
Articles
Links to many (but not all) of the articles I've written as a consultant are listed below.
SQL Server Pro
I've written numerous articles for SQL Server Pro (formerly SQL Server Magazine) over the years, and became a contributing editor in 2010.
- Disappointing News About SQL Server 2014
- Disturbing Problems with the Cloud and Security
- Review: ScaleArc iDB 2.0
- Don't Forget About Backup Compression
- SQL Server 2012 Contained Databases
- Command vs Data in 2nd Order Cross-Site Scripting Attacks
- 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
- The Essential Guide to 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
DevConnectionsPro
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
- Solving a Common .NET Scalability Problem
- The Entity Framework and ORMs: Understand the Trade-offs
- SQL Server Needs to Step Up Its Game
- ASP.NET SignalR: More than Just Chat
- 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
- Reasons to Avoid Triggers
- The SQL Server Security Issue That Wasn't
- Insider Threats and the Role of Auditing
- Free SQL Server Resources for Developers
- The Hidden Costs of SSIS: How to Avoid SQL Server Integration Services Gotchas
- The SQL Server Community: A Welcoming Place for Newbies
- The Cloud isn’t a Magical Panacea
- A Classic Security Challenge: SQL Profiler and "Password" Text
- Test Driving Database and Developer Consultants
- Key Business Considerations for Custom Software Development
- Maximizing Slow Days
- T-SQL Upgrades in SQL Server 2008
- Disturbing Problems with SQL Server 2014
- 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
- NoSQL, Hype, and Lousy Musicians
- Annoyances with Windows Server 2012 R2
- 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
- Back to Basics: Encryption – Past and Future
- Back to Basics: SSL and TLS
- Limitations with Caching in ASP.NET Applications
- Optimizing Use of ASP.NET Cache Functionality
- Troubleshooting Visual Studio 2012 Problems
- The .NET Framework and the Gradual Return of DLL Hell
- ASP.NET MVC 5 and URL Canonicalization
- MVC Routing, IIS, SEO, and Custom Errors – Oh My!
- 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
- Excellent Books for .NET Architects and Developers
- More Great Free Tools for .NET Developers
- A Look Back at My Favorite Developer Tools in 2014
- 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
- .NET Framework Soup
- Hands-Off Coding: Boosting Productivity
- Career Advice from a Developer's Perspective: In Praise of Specialization
- Pros and Cons of a Career as an IT/Developer Consultant
- Career Development Tip: Finding Your Niche
- Good Project Planning: Establishing Project Champions
- An Open Letter to HR Departments
- Leveraging the ASP.NET ReportViewer Control
- Smart Hardware Purchases for Developers
- On the Trail of the Elusive .NET Startup
- 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
- What Microsoft Really Needs in a New CEO
- Windows 10 and Trust – A Missed Opportunity
- Microsoft's Surface RT is Shaping Up to be a Train Wreck
- 2 Big Keys to Amazon's Successful Cloud Services Market
- Amazon's S3 for ASP.NET Web Developers
- ASP.NET MVC Paging Done Perfectly
- Kicking ASP.NET Providers to the Curb
- Predictions on the Future of ASP.NET
- Microsoft's Surface RT is Shaping Up to be a Train Wreck
- Career Advice from a Developer's Perspective: In Praise of Specialization
- The Loss of Net Neutrality
- Putting the NSA Spying Scandal into Perspective
- 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
- Essential Guide: Optimizing OLTP Performance
- The Essential Guide to Mission-Critical SQL Server Environments
- Performance Secrets for SQL Server Developers
- dtSearch 7 Desktop with Spider
SQLTeam.com
ASPAlliance.com
- 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: 157
