My Six Month Plan, Post Brent Ozar Unlimited
Category:
database-administration
It’s a big week for me! I’m moving on from Brent Ozar Unlimited.
Does OPTION (RECOMPILE) Prevent Query Store from Saving an Execution Plan?
Category:
query-performance
Recompile hints have been tough to love in SQL Server for a long time. Sometimes it’s very tempting to use these hints to tell the optimizer to generate a fresh execution plan for a query, but there can be downsides.
My SQLPASS 2015 Session Evaluations
Category:
indexing
I recently gave a day long session at the SQLPASS Summit called “SQL Server Index Therapy Session”. 61 people attended, and let me tell you I was thrilled with that number. I’ve co-presented lots of day and week long sessions, but this was the first day long session that I’d ever done solo at a conference and 61 people was a terrific number.
Telemetry_xevents, NT SERVICE\SQLTELEMETRY, and XE_LIVE_TARGET_TVF in SQL Server 2016
Category:
database-administration
Update, Feb 2017:
Here’s Microsoft’s overview of what the telemetry collects: https://www.microsoft.com/EN-US/privacystatement/SQLServer/Default.aspx
Did My Query Eliminate Table Partitions in SQL Server?
Category:
query-performance
Working with table partitioning can be puzzling. Table partitioning isn’t always a slam dunk for performance: heavy testing is needed. But even getting started with the testing can be a bit tricky!
Here’s a (relatively) simple example that walks you through setting up a partitioned table, running a query, and checking if it was able to get partition elimination.
Resources for Learning Python
Category:
python
I’ve been thinking about taking up a new programming language as a hobby for a little while. There’s a vibrant software community here in Portland, and working in more languages than TSQL opens up lots more opportunities for fun. I have no intention of becoming a full-time Python programmer, I just believe it’s fun to code and good to challenge your brain in new ways.
Are You a Woman in Tech Working with SQL Server? Join the SQLWIT Slack Channel!
Category:
database-administration
Update Nov 2021: This slack channel has been inactive for a bit of time now.
Are you a woman in technology that works with SQL Server or other databases? You might like to join our new slack channel - sqlwit.slack.com.