Free Webcast: DBA vs Memory Settings
Join me in two weeks for a really fun free webcast. Update: watch the recording of the webcast here! DBA vs Memory Settings Tues, April 24, 2018 – 8:30AM...
2018-04-11
5 reads
Remembering Robert Davis, aka @SQLSoldier
I woke up early on Tuesday with a hundred things to do and plenty of energy to match my task list. By noon, I’d made a loaf of bread,...
2018-04-03
28 reads
Adding a Downloadable Calendar Event File to WordPress without a Plugin
Let’s say you’ll be doing an event soon — say a Facebook Live event– and you want to create a calendar reminder for folks to download. Lots of us...
2018-03-19
8 reads
SQL Server 2026: BAGI Edition (#TSQL2SDAY 100!)
It’s T-SQL Tuesday’s 8 year birthday (or close enough), and Adam Machanic has challenged us with the question: what will the world be like when T-SQLTuesday turns 16? Not...
2018-03-13
10 reads
New Free Webinars! Index Tuning, Free Q&A, and Isolation Levels
I’ve got a whole slew of free webcasts and events coming this spring. I’m excited about each and every one of them! My next event is a free session...
2018-03-12
7 reads
Overheard: “I just think there’s not that many women who enjoy coding. And I say that based on my daughter, too.”
Update: Instead of reading this blog post, I suggest you read the article, “The Secret History of Women in Computing: Computer programming once had much better gender balance than...
2018-03-07
8 reads
Using YouTube Captions & Transcript to Find Content in a Long Video
This week, I was pretty pumped to see that PASS published Erin Stellato (twitter) and Dejan Krakovic’s (linked in) excellent session on Query Store to the public. I attended...
2018-02-23
8 reads
How I Accidentally Found a Passion for Plants (#TSQL2sDay 99)
For TSQL Tuesday #99, @AaronBertrand gave us an invitation to write about something we’re passionate about outside of SQL Server. As a community we spend a lot of time digging into nerdy...
2018-02-13
11 reads
Formatting a VTT Caption File into a Transcript with Sublime Text and Multiple Regular Expressions
Do you ever need to use a text editor to apply regular expressions to files? If so, this post is for you! If not, you may wanna skip it...
2018-02-08
8 reads
WordPress: Create a Sidebar List of Parent/Child Pages
Recently, I wanted to create a list of pages for a custom WordPress sidebar. Specifically, I had a “parent” page, sqlworkbooks.com/free-sql-server-quizzes. Under this page, I had more than 30 individual...
2018-01-04
724 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers