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,… Read More »My home office setup
Home » Archives for Randolph »
Randolph
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… Read More »Don’t install SQL Server from a mounted ISO
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… Read More »The curious case of the sqlcmd password
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,… Read More »Looking ahead to 2020
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… Read More »Temporal Tables, and how to deal with computed columns
Compression in SQL Server: COMPRESS and DECOMPRESS
On Twitter recently, I asked: Does anyone I know use the COMPRESS and DECOMPRESS features in T-SQL? To those who replied in the affirmative, I… Read More »Compression in SQL Server: COMPRESS and DECOMPRESS
A guide to acronyms, abbreviations, and other technical terms
Here’s a list of some technical terms, acronyms, and abbreviations you may have heard, and what they mean. Some of the definitions are taken from… Read More »A guide to acronyms, abbreviations, and other technical terms
The XML data type is not immutable
Immutability In many programming languages, strings of text are immutable, meaning they don’t change. When you modify a string, a new string is created in… Read More »The XML data type is not immutable
Is it true that editing a single row in Management Studio empties and reloads the entire table?
TL;DR: No. A customer recently brought up an interesting thesis, that if you edit a table’s values using SQL Server Management Studio (SSMS) using the… Read More »Is it true that editing a single row in Management Studio empties and reloads the entire table?
Installing SQL Server on Windows? Don’t forget these two useful switches
A few days ago on Twitter I wrote: Couldn’t connect to new SQL Server install because I forgot to enable TCP/IP. I’m the lead author… Read More »Installing SQL Server on Windows? Don’t forget these two useful switches
Did you know we have another SQL Server book coming out?
SQL Server 2017 Administration Inside Out was the first technical book I contributed to, and all its authors were very happy with how it turned… Read More »Did you know we have another SQL Server book coming out?
SQL Server 2019 is here
With the release of SQL Server 2019, I wanted to highlight in a single place some things that I’m excited about. Drawing on sessions I… Read More »SQL Server 2019 is here
When security and news collide
Behold! There’s a scary monster called skip‑2.0, announced by ESET: This backdoor targets MSSQL Server 11 and 12, allowing the attacker to connect stealthily to… Read More »When security and news collide
Speaking at SQL Saturday Oregon
SQL Saturday Oregon — in the city of Portland — is taking place next weekend on Saturday November 2nd, 2019, and I’ll be presenting a… Read More »Speaking at SQL Saturday Oregon
Using indexed views? What is an imprecise or non-deterministic convert?
After last week’s post about using WITH (NOEXPAND) to query indexed views even on SQL Server Enterprise Edition, this week is a short but interesting… Read More »Using indexed views? What is an imprecise or non-deterministic convert?