Join me at SQLBits 2020
The SQLBits conference is taking place in London again this year, between March 31st and April 4th, and I’ll be there. I will not be presenting this year, but...
2020-02-26
10 reads
Randolph West
- Twitter: @_randolph_west
- Website: https://bornsql.ca/blog/
- LinkedIn: https://linkedin.com/in/rabryst/
Disaster recovery, tools edition
I just completed a chapter for another book where I spoke about the Recovery Point Objective (how much data you are prepared to lose) and Recovery Time Objective (how...
2020-02-19
38 reads
Dealing with rejection
“Dear speaker This serves as notice that your session submission was not selected for our upcoming event. We had a lot of sessions to sort through, and unfortunately there...
2020-02-12
32 reads
I’m a DBA. Do I really need to know Kubernetes?
Welcome to February 2020. It’s the second month of the year 2020! I remember sitting at a server with SQL Server 6.5 installed on it, worrying about the Y2K...
2020-02-05
401 reads
What is a strong password anyway?
Background Fellow Microsoft MVP Troy Hunt (blog | Twitter) has been operating the website Have I Been Pwned (HIBP) for a number of years now. For the record, “pwned” is...
2020-01-29
188 reads
My home office setup
That aging hippie (he likes Apple products and has a goatee) known as Brent Ozar wrote a post recently about his home office studio setup, with a big focus...
2020-01-22
56 reads
Don’t install SQL Server from a mounted ISO
Here’s something that seems to keep coming up, but not frequently enough for me to write a blog post about until now: You should not install SQL Server from...
2020-01-15
104 reads
The curious case of the sqlcmd password
In August last year I posted about a command line parser problem I ran into with AzCopy, which I eventually resolved by writing a batch file and escaping a...
2020-01-08
31 reads
Looking ahead to 2020
This week all I want to say is Happy New Year, and may 2020 be the start of a successful decade for you. Live, love, learn. Remember to take...
2020-01-01
19 reads
Temporal Tables, and how to deal with computed columns
Long time readers will know I’m a big fan of Temporal Tables since their introduction in SQL Server 2016. Thanks to my friend Erik Darling (blog | Twitter), I...
2019-12-25
323 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Ambasador Telpon/WA:08137887595
BCA KCP Ambasador Telpon/WA:08137887595.Mal & Apartemen Ambasador, Jl. Prof. DR. Satrio No.R.18 Lantai Dasar,...
BCA KCU MENARA BIDAKARA Telpon/WA:08137887595
BCA KCU MENARA BIDAKARA Telpon/WA:08137887595.Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt....
BCA KCU KELAPA GADING Tlpn/Wa 0853.7373.7551
Menara Satu Sentra Klp. Gading, Jl. Boulevard Bar. Raya No.1 Lt. Dasar, 1, 9...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers