SIMON FRAZER
MASTERING MICROSOFT SQL SERVER AND AZURE, ONE BLOG POST AT A TIME
SimonFrazer.com is a free resource for mastering Microsoft SQL Server and Azure.
Find insights, practical guides and resources to help you navigate and optimise these powerful technologies.
LATEST ARTICLES
At some point, every SQL developer or DBA will need to debug T-SQL scripts, either to verify that they behave as expected or to track down the root cause of a problem. Whether you’re...
If you’ve been working with T-SQL scripts for a while, you’ve likely encountered variables. These are essential for writing scripts that go beyond basic SELECT, INSERT,...
When starting out with SQL Server, it’s important to focus on learning the basics to avoid getting bogged down with detail but there comes a time when knowing about the internals...
SQLBits is undoubtedly one of the best events for the Data Community. Whether you’re looking to deepen your knowledge, expand your professional network, or simply have a great time...
Take Your SQL Server Skills to the Next Level with Brent Ozar’s Black Friday Sale!
Brent Ozar is running his annual Black Friday sale all November, and I’m excited to offer you an additional...
When working with SQL Server, there are times when we need to insert a large number of rows into a table. This might be to populate test data in a non-production environment or to pre-load...
I'D LOVE TO HEAR FROM YOU
Need advice? Have something to share?
Head to the contact page for various options. I try to answer as many questions as possible.
