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
36 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
92 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
16 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
10 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
209 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
126 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
28 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
100 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
45 reads
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 out. All the content...
2019-11-13
34 reads
Blogs
Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)
Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...
ANSI_WARNINGS = OFF can break update statements with some SQL features
By Will Assaf
Working on a SQL 2017 database where an external, non-Microsoft application has direct access...
Bring Your Own Key to Azure SQL Database Managed Instance TDE
Last year Azure SQL Database Managed Instance saw the introduction of bring your own...
Forums
https://probowl-bowl.com/
https://the-grammyawards.com/ https://the-grammyawards.com/2020/ https://the-grammyawards.com/live/ https://grammyawards-grammy.com/ https://grammyawards-grammy.com/2020/ https://grammyawards-grammy.com/live/ https://probowl-bowl.com/ https://probowl-bowl.com/2020/ https://probowl-bowl.com/live/ https://probowl-bowl.com/nfc-vs-afc/ https://the-grammyawards.com/ https://the-grammyawards.com/2020/ https://the-grammyawards.com/live/...
https://grammyawards-grammy.com/
https://the-grammyawards.com/ https://the-grammyawards.com/2020/ https://the-grammyawards.com/live/ https://grammyawards-grammy.com/ https://grammyawards-grammy.com/2020/ https://grammyawards-grammy.com/live/ https://probowl-bowl.com/ https://probowl-bowl.com/2020/ https://probowl-bowl.com/live/ https://probowl-bowl.com/nfc-vs-afc/
How to update status with conflict data where chemical temp table have same chem
How to update status with conflict data where chemical temp table have same chemical...
Ask SSC