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
52 reads
Born SQL with Randolph West
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
100 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
25 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
14 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
320 reads
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 asked: What made you...
2019-12-18
137 reads
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 Wikipedia. This list is...
2019-12-11
32 reads
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 memory by copying the...
2019-12-04
111 reads
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 edit feature, that the...
2019-11-27
2 reads
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 for a Microsoft Press...
2019-11-20
47 reads
Blogs
Scooby Dooing Episode 10: The Case of the Copy-and-Paste Consultant
Every Scooby-Doo episode has one thing in common — there’s always a fake ghost....
Regression Testing: DAX User Defined Functions
User Defined Functions is a new feature in PowerBI currently in public preview. There...
The fundamental requirements of a reporting system
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
Forums
Data > Hype
Comments posted to this topic are about the item Data > Hype
Create and Read the Analysis Services Flight Recorder
Comments posted to this topic are about the item Create and Read the Analysis...
Slipstream parameters
Comments posted to this topic are about the item Slipstream parameters
Question of the Day
Slipstream parameters
What parameters are needed to enable a slipstream installation for setup.exe (SQL Server setup)?
See possible answers