Born SQL@BornSQL
7 Mar 2022
Replying to @BornSQL
I did explicitly reply to the original question though.
Question: Do you know how I would be able to run the container with the root user by default? My reply: Yes I do. Don’t do it. It’s not a good security practice.
1
0
0
Born SQL@BornSQL
29 Apr 2020
PASS Summit 2020 pre-con time bornsql.ca/blog/pass-summ…
0
0
0
Born SQL@BornSQL
22 Apr 2020
How SQL Server stores data types: DATETIME, DATE, TIME, and DATETIME2 bornsql.ca/blog/how-sql-s…
1
4
2
Born SQL@BornSQL
15 Apr 2020
Remember this if you want to use sp_ bornsql.ca/blog/remember-…
0
1
1
Born SQL@BornSQL
8 Apr 2020
Join me (virtually) in Adelaide! bornsql.ca/blog/join-me-v…
0
0
0
Born SQL@BornSQL
1 Apr 2020
Picking up the pieces after the DBA has left: taking ownership of a SQL Server instance bornsql.ca/blog/picking-u…
0
0
1
Born SQL@BornSQL
25 Mar 2020
sql2xls goes cross-platform bornsql.ca/blog/sql2xls-g…
0
0
0
Born SQL@BornSQL
18 Mar 2020
On the continuity of business bornsql.ca/blog/on-the-co…
0
0
0
Born SQL@BornSQL
4 Mar 2020
Deprecated and discontinued features in SQL Server bornsql.ca/blog/deprecate…
0
0
0
Born SQL@BornSQL
19 Feb 2020
Disaster recovery, tools edition bornsql.ca/blog/disaster-…
0
0
0
Born SQL@BornSQL
12 Feb 2020
Dealing with rejection bornsql.ca/blog/dealing-w…
0
0
0
Born SQL@BornSQL
5 Feb 2020
I’m a DBA. Do I really need to know Kubernetes? bornsql.ca/blog/im-a-dba-…
0
0
0
Born SQL@BornSQL
29 Jan 2020
What is a strong password anyway? bornsql.ca/blog/what-is-a…
0
0
0
Born SQL@BornSQL
22 Jan 2020
My home office setup bornsql.ca/blog/my-home-o…
0
0
0
Born SQL@BornSQL
15 Jan 2020
Don’t install SQL Server from a mounted ISO bornsql.ca/blog/dont-inst…
1
0
0
Born SQL@BornSQL
8 Jan 2020
The curious case of the sqlcmd password bornsql.ca/blog/the-curio…
0
0
4
Born SQL@BornSQL
2 Jan 2020
Looking ahead to 2020 bornsql.ca/blog/looking-a…
0
0
0
Born SQL@BornSQL
25 Dec 2019
Temporal Tables, and how to deal with computed columns bornsql.ca/blog/temporal-…
0
0
1
Born SQL@BornSQL
18 Dec 2019
Compression in SQL Server: COMPRESS and DECOMPRESS bornsql.ca/blog/compressi…
0
0
0
Born SQL@BornSQL
17 Dec 2019
How I prepared for my first ever SQLSaturday session

(Originally posted on 1 July 2015)

bornsql.ca/blog/how-i-pre…
turned on LED projector on table
0
0
2
Born SQL@BornSQL
11 Dec 2019
A guide to acronyms, abbreviations, and other technical terms bornsql.ca/blog/the-guide/
0
0
0
Born SQL@BornSQL
10 Dec 2019
Announcing Azure Blob Storage Sync and Restore

(Originally posted on 28 June 2015)

bornsql.ca/blog/announcin…
0
0
0
Born SQL@BornSQL
4 Dec 2019
The XML data type is not immutable bornsql.ca/blog/the-xml-d…
0
0
1
Born SQL@BornSQL
3 Dec 2019
Database Corruption Challenge

(Originally posted on 2 May 2015)

bornsql.ca/blog/database-…

/cc @SqlEmt
Western Digital WD Red internal HDD sliced in half on pink surface
0
0
0
Born SQL@BornSQL
27 Nov 2019
Is it true that editing a single row in Management Studio empties and reloads the entire table? bornsql.ca/blog/is-it-tru…
0
0
0
Born SQL@BornSQL
26 Nov 2019
Loyalty can be bought

(Originally posted on 1 May 2015)

bornsql.ca/blog/loyalty-c…
0
0
0
Born SQL@BornSQL
20 Nov 2019
Installing SQL Server on Windows? Don’t forget these two useful switches bornsql.ca/blog/installin…
0
0
0
Born SQL@BornSQL
19 Nov 2019
Total recall

(Originally posted on 28 April 2015)

bornsql.ca/blog/total-rec…
Two people writing on paper at a desk with an open computer
0
0
0
Born SQL@BornSQL
13 Nov 2019
Did you know we have another SQL Server book coming out? bornsql.ca/blog/did-you-k…
0
0
1
Born SQL@BornSQL
12 Nov 2019
Do it now: Date and Number (Tally) tables

(Originally posted on 16 December 2014)

bornsql.ca/blog/now-date-…
0
0
0
Born SQL@BornSQL
6 Nov 2019
SQL Server 2019 is here bornsql.ca/blog/sql-serve…
0
2
6
Born SQL@BornSQL
5 Nov 2019
Assumption sandwich

(Originally posted on 21 November 2014)

bornsql.ca/blog/assumptio…
0
0
0
Born SQL@BornSQL
30 Oct 2019
When security and news collide bornsql.ca/blog/when-secu…
0
0
0
Born SQL@BornSQL
29 Oct 2019
SQL Server Storage Engine: Bit Columns

(Originally posted on 23 October 2013)

bornsql.ca/blog/bit-colum…
0
0
0
Born SQL@BornSQL
22 Oct 2019
The curious case of RESOURCE_SEMAPHORE

(Originally posted on 25 April 2013)

bornsql.ca/blog/the-curio…
0
0
1
Born SQL@BornSQL
16 Oct 2019
Using indexed views? What is an imprecise or non-deterministic convert? bornsql.ca/blog/using-ind…
0
1
0
Born SQL@BornSQL
15 Oct 2019
Where Do I Start With A Run Book?

(Originally posted on 15 January 2013)

bornsql.ca/blog/where-do-…
sharpened pencil resting on a notebook
0
0
1
Born SQL@BornSQL
9 Oct 2019
Using indexed views? Don’t forget this important tip. bornsql.ca/blog/using-ind…
0
0
0
Born SQL@BornSQL
9 Oct 2019
On the importance of good backups

(Originally posted on 19 May 2012)

bornsql.ca/blog/on-the-im…
0
0
0
Born SQL@BornSQL
2 Oct 2019
How to read documentation bornsql.ca/blog/how-to-re…
0
1
1
Born SQL@BornSQL
1 Oct 2019
Adventures in BlobEater, sp_WhoIsActive and DBCC CHECKDB

(Originally posted on 30 March 2012)

bornsql.ca/blog/adventure…
0
0
0
Born SQL@BornSQL
25 Sep 2019
Gatekeeping and Accessibility bornsql.ca/blog/gatekeepi…
0
0
0
Born SQL@BornSQL
24 Sep 2019
Remove duplicate indexes in SQL Server 2000

(Originally posted on 8 March 2012)

bornsql.ca/blog/remove-du…
0
0
0
Born SQL@BornSQL
18 Sep 2019
SQL Server 2019 on Docker no longer runs as root by default bornsql.ca/blog/sql-serve…
0
0
0
Born SQL@BornSQL
17 Sep 2019
My brain hurts

(Originally posted on 4 March 2012)

bornsql.ca/blog/my-brain-…
0
0
0
Born SQL@BornSQL
11 Sep 2019
Gatekeeping and the lack of diversity in the workplace bornsql.ca/blog/gatekeepi…
0
0
1
Born SQL@BornSQL
10 Sep 2019
Increasing the number of SQL Server Error Logs

(Originally posted on 3 January 2012)

bornsql.ca/blog/increasin…
0
0
0
Born SQL@BornSQL
4 Sep 2019
Convert legacy password storage without aggravating your users bornsql.ca/blog/convert-l…
0
0
0
Born SQL@BornSQL
3 Sep 2019
What I did today

(Originally posted on 16 December 2011)

bornsql.ca/blog/what-i-di…
0
0
0
Born SQL@BornSQL
28 Aug 2019
Using AzCopy with Batch Files and Task Scheduler bornsql.ca/blog/using-azc…
0
0
1
Born SQL@BornSQL
27 Aug 2019
Link 64-bit SQL Server 2005 to 32-bit SQL Server 2000

(Originally posted on 23 August 2007)

bornsql.ca/blog/link-64-b…
0
0
0
Born SQL@BornSQL
21 Aug 2019
Accelerated Database Recovery in SQL Server 2019: Choose your own filegroup for the version store bornsql.ca/blog/accelerat…
2
1
1
Born SQL@BornSQL
14 Aug 2019
How to really store a password in a database bornsql.ca/blog/how-to-re…
1
2
4
Born SQL@BornSQL
7 Aug 2019
Gatekeeping and why language matters bornsql.ca/blog/gatekeepi…
0
0
1
Born SQL@BornSQL
31 Jul 2019
How to store a password in a database bornsql.ca/blog/how-to-st…
0
4
1
Born SQL@BornSQL
24 Jul 2019
The importance of backups bornsql.ca/blog/the-impor…
0
2
0
Born SQL@BornSQL
10 Jul 2019
Better SQL Server memory defaults in 2019 bornsql.ca/blog/better-sq…
0
0
1
Born SQL@BornSQL
3 Jul 2019
Better SQL Server CPU defaults in 2019 bornsql.ca/blog/better-sq…
0
0
0
Born SQL@BornSQL
3 Jul 2019
The third time’s the charm bornsql.ca/blog/the-third…
0
0
8
Born SQL@BornSQL
26 Jun 2019
SQL Server 2008 and 2008 R2 is end of life on 9 July 2019 bornsql.ca/blog/sql-serve…
0
0
0
Born SQL@BornSQL
19 Jun 2019
What is a container anyway? bornsql.ca/blog/what-is-a…
0
1
2
Born SQL@BornSQL
12 Jun 2019
Containers and data: you gotta keep ’em separated bornsql.ca/blog/container…
0
0
0
Born SQL@BornSQL
5 Jun 2019
My IT department installed an antivirus with SQL Server bornsql.ca/blog/my-it-dep…
0
0
0
Born SQL@BornSQL
29 May 2019
SQL Server containers no longer being updated in the Docker registry bornsql.ca/blog/sql-serve…
0
1
0
Born SQL@BornSQL
22 May 2019
Speaking at PASS Summit 2019 bornsql.ca/blog/speaking-…
0
0
2
Born SQL@BornSQL
15 May 2019
Proposed SQL Server defaults: max server memory bornsql.ca/blog/proposed-…
0
1
0
Born SQL@BornSQL
8 May 2019
The easy way to handle UTF-8 in a .NET application when dealing with SQL Server 2019 bornsql.ca/blog/the-easy-…
0
0
1
Born SQL@BornSQL
3 May 2019
A short Azure SQL Database Edge explainer bornsql.ca/blog/a-short-a…
0
2
2
Born SQL@BornSQL
1 May 2019
The case of scalar UDF inlining, where context is everything bornsql.ca/blog/the-case-…
0
0
1
Born SQL@BornSQL
24 Apr 2019
Proposed SQL Server defaults: optimize for ad hoc workloads bornsql.ca/blog/proposed-…
0
0
0
Born SQL@BornSQL
10 Apr 2019
Using a home-grown Azure Blob Storage solution for SQL Server backups bornsql.ca/blog/using-a-h…
0
1
1
Born SQL@BornSQL
3 Apr 2019
It’s a UNIX system. I know this. bornsql.ca/blog/its-a-uni…
0
0
0
Born SQL@BornSQL
27 Mar 2019
SQL Server on Linux – feature change in Pacemaker 1.1.18 bornsql.ca/blog/sql-serve…
0
1
0
Born SQL@BornSQL
20 Mar 2019
The free SQL to Excel Export tool bornsql.ca/blog/the-free-…
0
0
0
Born SQL@BornSQL
13 Mar 2019
Does SQL Server 2019 run on Ubuntu 18.04 LTS? bornsql.ca/blog/does-sql-…
1
2
2
Born SQL@BornSQL
27 Feb 2019
Proposed SQL Server defaults: disable priority boost bornsql.ca/blog/proposed-…
0
0
0
Born SQL@BornSQL
20 Feb 2019
Proposed SQL Server defaults: disable lightweight pooling bornsql.ca/blog/proposed-…
0
0
0
Born SQL@BornSQL
13 Feb 2019
Proposed SQL Server defaults: cost threshold for parallelism bornsql.ca/blog/proposed-…
0
0
1
Born SQL@BornSQL
6 Feb 2019
When the buffer pool isn’t just in memory bornsql.ca/blog/when-the-…
0
0
0
Born SQL@BornSQL
23 Jan 2019
How does the buffer pool work? bornsql.ca/blog/how-does-…
0
0
0
Born SQL@BornSQL
16 Jan 2019
Database modelling in a post-SSMS world: dbForge Studio bornsql.ca/blog/database-…
0
0
0
Born SQL@BornSQL
9 Jan 2019
Back to the future bornsql.ca/blog/back-to-t…
0
0
0
Born SQL@BornSQL
2 Jan 2019
AzCopy finally gets a sync option, and all the world rejoices bornsql.ca/blog/azcopy-fi…
0
0
1
Born SQL@BornSQL
19 Dec 2018
Infrastructure matters, even in the Cloud bornsql.ca/blog/infrastru…
0
1
0
Born SQL@BornSQL
12 Dec 2018
Some databases may show a NULL collation in the sys.databases DMV bornsql.ca/blog/some-data…
0
1
1
Load more