SQL Indexing and Tuning eBook

sql performance explained - SQL Indexing and Tuning eBook

It’s the free web-edition of SQL Performance Explained, regarding SQL indexing and tuning for DB2, MySQL, Oracle, PostgreSQL, and SQL Server. SQL indexing is the most effective tuning method—yet it is often neglected during development. Use The Index, Luke explains SQL indexing from grounds up and doesn’t stop at ORM tools like Hibernate. Use The Index, Luke is the free […]

Free Azure Training Resources

windows azure cloud - Free Azure Training Resources

For anyone interested in diving deep in Azure’s world. Microsoft Training and Certification Azure Essentials – the best place to get started with Azure and learn new skills Pluralsight – free self-paced courses Hands-on Labs – an array of self-paced labs, instructor-led classes, and challenging exercises to practice the skills Certifications – boost your career with a Microsoft certification It’s a […]

Document SQL Server with Database Note Taker

Database Note Taker - Document SQL Server with Database Note Taker

Database Note Taker is a free note-taking app made specifically for SQL databases. It makes a database schema and structures a lot easier to capture and document, and definitely simplifies the database documentation and takes the guesswork out of everyday development with databases. How does it work? More specifically, Connect to your database. Refresh with the current structure of your database. […]

Names of Large Numbers

Paperclip game result - Names of Large Numbers

I’ve been wasting time on this free AI-powered game called Paperclip for a few days now. Got to the end a couple of times and extremely satisfied when seeing the numbers quickly pilling up. But what’s really blown my mind was how large the number grows. It quickly passes thousand, million, billion, trillion, fast forward to a point where the names […]

What’s in a Boarding Pass Barcode?

deltabp 580x250 - What's in a Boarding Pass Barcode?

Next time when you are throwing away a used boarding pass with a barcode on it, please consider tossing it into a shredder instead. Why? Two-dimensional barcodes and QR codes can hold a great deal of information, and the codes printed on airline boarding passes may allow someone to discover more about you, your future travel plans, and your frequent […]

Stack Overflow Public Database Available (2017-06)

qHF2K - Stack Overflow Public Database Available (2017-06)

Need a huge SQL database for your data project? Here is one for you. Nick Craver and the kind folks at Stack Overflow publish their data export periodically with your questions, answers, comments, user info, and more. It’s available as an XML data dump. Then, Brent Ozar took the data and imported into SQL Server for his teaching performance tuning needs, and generously published it […]