Writing more legible SQL
Tips and best practices for writing clean, readable, and maintainable SQL code, including formatting, CTEs, and commenting.
Tips and best practices for writing clean, readable, and maintainable SQL code, including formatting, CTEs, and commenting.
Discusses a bug in XAML Compiled Bindings when using null fallback values, with code examples and a warning for developers.
Argues that all websites must begin with server-side rendered HTML for universal accessibility, even if they later use advanced JavaScript features.
Argues that Python is the best programming language for scientists to learn, highlighting its community, learning resources, and scientific packages.
A developer details implementing Prism.js for syntax highlighting on their blog, focusing on progressive enhancement.
A technical guide on building a real-time Twitter sentiment and hashtag analysis system using Kafka, Storm, and Cassandra.
A guide on using Wireshark to debug and analyze TLS handshakes, helping to decipher cryptic errors and understand network protocol issues.
Explains how HSTS works with Let's Encrypt to secure websites by forcing browsers to use HTTPS, preventing man-in-the-middle attacks.
A technical guide on implementing a Service Worker in WordPress to enhance performance and enable offline functionality, including troubleshooting tips.
Explains how to fix the common Heroku deployment error when pushing a Ruby on Rails app using SQLite3, by switching to PostgreSQL.
A developer shares 10 essential PostgreSQL features and tips for 2016, including CTEs, performance tuning, and configuration.
Tips and tools for iOS developers to improve productivity in Xcode, including user breakpoints, plugins, and hidden settings.
A front-end developer's wishlist for 2016, focusing on container queries, Service Worker adoption, and new CSS selectors.
A guide on fixing a bug in the Convert-WindowsImage script to successfully create a Nano Server TP4 VHD, including updated installation steps.
Analysis of a Microsoft demo showing a Windows NanoServer container base image, discussing its implications for Windows Server 2016 container technology.
A technical guide on manually creating and configuring Windows Server Containers on Nano Server 2016 TP3, covering VM setup and networking.
Overview of new features and the official installer script in Windows Server 2016 Nano Server Technical Preview 3.
An improved implementation of the weak event pattern in C# to prevent memory leaks, focusing on performance and API design.
Overview of SQL Server 2016's key security and performance features, including Always Encrypted, Stretch Database, and real-time analytics.
Microsoft Office 2016 public preview is now available for home and enterprise users with stable performance.