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
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
8 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
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
2 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
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
3 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
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
5 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
1 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
598 reads
Blogs
SQL Server Distributed Availability Groups and Kubernetes
A while back I wrote about how to use a Cross Platform (or Clusterless)...
Webcast Tomorrow on SQL Server Disaster Recovery
By Brian Kelley
Tomorrow, November 19, 2024, at 1 PM EST, I'm giving a webcast on SQL...
SQL Server Quickie #48 – Azure SQL Managed Instance
Today I have uploaded SQL Server Quickie #48 to YouTube. This time I’m talking...
Forums
Azure elastic job issue authenticating to Azure SQL database
Azure elastic agent jobs: I’m getting this error “The server principal “ac1971e9-381b-449b-9e1a-9cc276fc2985@b5313c9d-fb0d-47af-bc87-7c050bffbdc3” is not...
Converting job_id to join to another table.
I need help, please! I have a monitoring table that pulls in information about...
SSMS 20.2 on Windows11 not able to connect to SQL 2005 ??
We still have a couple of dino's. What should I check to re-enable access...
Question of the Day
What's the Ceiling?
What do I get as the results from this code?
SELECT CEILING (999.999), CEILING (-999.999);See possible answers