Telemetry_xevents, NT SERVICE\SQLTELEMETRY, and XE_LIVE_TARGET_TVF in SQL Server 2016
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?
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
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!
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.
Taking the time to write about something makes you learn more
You know how sometimes you learn something, then you start to see it everywhere you look?
How I learned to write TSQL
I primarily work with SQL Server, but my favorite book on TSQL is the one that I learned with: The Transact SQL Cookbook.
SQL Server Filtered Indexes: The Third Index Dimension
One perk to filtered indexes that may not be obvious at first is that you get an extra “dimension”– almost an extra kind of key column. This can be useful for some queries that can be tricky to index.
The new ApprenticeshipInEducation.com, and How You Can Learn about Life in Haiti
Like anyone else, I easily get wrapped up in my own life: my family and friends, my work, my local community, my technical community. Facebook, Twitter, cat pictures. When I took time off from work recently, I got a glimpse outside of my normal, narrow world.
Public Speaking Is Not Only Helpful for Your Audience
It’s also for you, the speaker. Speaking takes up your time and energy. It teaches you to express concepts, to listen well, and it even teaches you a lot about how you think.
DBCC USEROPTIONS: See Your Session Settings in SQL Server
This is a super old command, but it still comes in handy when working with SQL Server.