Failovers can’t serve two masters
As I’m sure you’re aware, the career path for a SQL Server DBA is a wonderful journey of growing your catalog of knowledge through unexpected lessons. For example: Did...
2018-12-02
5 reads
DesertDBA
- Website: https://desertdba.com
Failovers can’t serve two masters
As I’m sure you’re aware, the career path for a SQL Server DBA is a wonderful journey of growing your catalog of knowledge through unexpected lessons. For example: Did...
2018-12-02
6 reads
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
11 reads
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
9 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
14 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
9 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
16 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
9 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
Converting Money
Comments posted to this topic are about the item Converting Money
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers