On October 2, 2018 at 11PM EDT, I’ll be joined by John Q. Martin (blog|twitter) for a webinar on Azure SQL Database Managed Instance. To sign up, register here. You can access the recording of the session here. Follow-up Q & A from the live … [Read More]
On August 28, 2018 at 2PM EDT, I’ll be joining Melissa Connors (blog|twitter), Kevin Kline (blog|twitter), and Rob Sewell (blog|twitter) for a webinar on advanced SQL Server features. The webinar centers around a real-life case study of technology SentryOne is using in it’s own database. … [Read More]
I was recently doing a training session when a developer commented that it was OK to run an expensive query twice because on the second execution, SQL Server would use the “results cache” and be “practically free”. It’s not the first time I’ve heard someone refer to a “results cache” in SQL Server. If you don’t know better, you might think SQL Server has a “results cache” because the second execution of a query is often faster.
I’m headed to SQLSaturdays in Louisville and Columbus for my first community events as Product Manager at SentryOne. While I’m there, I’m interested in talking with SentryOne users.
The number of people who really love having their code [quoted] with [square brackets] is pretty small. The vast majority of people who I meet really hate them, and promptly remove them.
It’s been a little bit since the last T-SQL Tuesday I joined, when I blogged about religion & politics. This month, I answer Bert Wagner’s call to blog about code I would hate to live without
I’m no accidental DBA. Very shortly after I started working in tech, I realized that I wanted to be a DBA when I grew up. Eventually, I landed that DBA job, and have been a DBA ever since. A couple of weeks ago, I told my manager I was leaving and gave my notice. That night, my husband and I celebrated with a champagne moment.
I recently presented for the PASS Professional Development virtual group with my session “How to get your dream job: resume & job hunting tips.” When I’m speaking at SQLSaturdays and User Groups, I frequently meet people looking to advance their career, make a career change, … [Read More]
I was recently asked: For testing, I need to generate artificial CPU load on the server, outside of SQL Server. Do you have any ideas? Maybe something with PowerShell? I quickly replied: Heck yea, PowerShell can do that. I mean, I knew PowerShell could do … [Read More]
In case you’ve missed it (though, if you’re a data professional or other IT pro, you must live under a rock if you’ve missed it), SMBv1 should never ever be used. Alas, some shares out there still exist & use it. Recent Windows updates have … [Read More]