PASS Summit 2018 brain dump
Much like your paycheck, this post is two weeks after the fact. But also like your paycheck, it’s got a good deal of personal importance. I’ve taken a couple...
2018-11-25
1 reads
The Desert DBA
PASS Summit 2018 brain dump
Much like your paycheck, this post is two weeks after the fact. But also like your paycheck, it’s got a good deal of personal importance. I’ve taken a couple...
2018-11-25
2 reads
Don’t believe the myth TRUNCATE TABLE isn’t logged
Remember the Bill Gates email hoax? The one that claims to be some sort of Microsoft beta test saying Gates is going to pay cash money to anyone who...
2018-10-05
4 reads
How to create a presentation in 30 easy steps
As I mentioned previously, this week I presented my first public SQL Server training session. I’m truly grateful for this opportunity because after all the work I put into...
2018-09-21
3 reads
Batching data manipulation is great as long as you do it correctly
As Sinatra was fond of singing, “regrets, I’ve had a few.” And one of those came this week immediately after my presentation. This isn’t to say the presentation didn’t...
2018-09-15
4 reads
Delayed durability, the TURBO button for your transaction log
As noted in the previous post, this month I got my learn on at Tech Outbound’s SQL Cruise Alaska. Which was awesome in so many ways, but I’m only...
2018-08-29
3 reads
Blogs
Common Issues When Using Change Tracking for Data Warehouse Incremental Loads
I have a few clients that incrementally load tables from a SQL Server source...
Top 5 Advanced SQL Courses for 2025 (Must-Know)
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
Cool AI sites
By James Serra
As I researched and wrote my OpenAI and LLMs blogs (see Introduction to OpenAI...
Forums
Why you should avoid Implicit Measures in your Power BI model
Comments posted to this topic are about the item Why you should avoid Implicit...
JSON in Microsoft SQL Server: A Comprehensive Guide
Comments posted to this topic are about the item JSON in Microsoft SQL Server:...
Question of the Day
Precision and Scale I
I have this number: 456.23 What is the scale of this number?
See possible answers