If you’d told me three years ago that I’d be organising my own data conference, I’d probably have laughed at you. Yet here I am, spending my evenings and weekends organising venues, talking to sponsors, finding speakers, building websites, and working through a seemingly endless list of things that need doing. And the strange thing
Why I Created Data Pulse Read More »
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 building something new or investigating a production issue, debugging is an essential part of the process. There are several techniques available
Debugging T-SQL Scripts Read More »
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, UPDATE, or DELETE statements. Variables can serve multiple purposes: they can act as parameters passed into stored procedures, hold the results of one query to use in another, or
Variables Are Tougher Than You Think Read More »
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 of a database page can be useful. Lets have a look at how SQL Server groups database pages and what they actually contain. What
What’s inside a database page? Read More »
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 away from the office, SQLBits is an event you won’t want to miss.
Why You Should Attend SQLBits 2025 Read More »
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 10% discount on top of his sale prices. To get the discount, you’ll need to use the links and coupon code
10% off Brent Ozar’s Black Friday Sale! Read More »
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 a new table with data from another system. There are several methods to achieve this, but in this article, we’ll focus on the impact of using multiple INSERT statements.
Insert rows faster using explicit transactions Read More »
SQL Server has been around for many years and does a pretty good job of optimising queries. While there are ways we can help enhance performance, there are also plenty to inadvertently degrade it. A common issue I often encounter occurs in queries across date ranges.
Tuning Date Range Queries Read More »
Explore possible causes of slow deletes in SQL Server
Why are my deletes so slow? Read More »
Discovering new faces in the Data Community has never been more enjoyable, thanks to the Finding Data Friends podcast. Hosted on YouTube at Finding Data Friends, this engaging podcast introduces viewers to a diverse array of personalities from the Data Community. You’ll encounter familiar names like Erin Stellato and Kendra Little, as well as emerging
Finding Data Friends: A Community Podcast Read More »
You must be logged in to post a comment.