2026-05-08
1,064 reads
Linux
How Much Linux Do You Need?
With SQL Server on Linux becoming more popular, Steve asks if you think you need to know much about that OS.
2025-02-14
143 reads
If You Build It, Will They Use Linux?
Microsoft built SQL Server on Linux. Are people coming to use it? Are you?
2023-09-22
185 reads
Configure SQL Server on Ubuntu 16.04 to use Active Directory Authentication
Learn how to get Windows Authentication working on an Ubuntu SQL Server on Linux instance.
2020-09-08
4,019 reads
2020-02-11
21,644 reads
More Linux than Windows
Microsoft announced that Linux runs on more machines in Azure than Windows. Steve isn't surprised and thinks that Linux use will continue to grow.
2025-05-26 (first published: 2019-07-06)
377 reads
Creating Aliases for Docker Commands in Linux
In this article you will learn how to create and use alias commands for Docker, to make Docker's command line experience easier and more productive.
2019-05-20
20,792 reads
Import flat files to SQL Server on Linux using Azure Data Studio
Have you ever wonder how to import flat files to SQL Server on Linux? In this article, I will share my experience loading data to a Linux SQL Server instance using the new Azure Data Studio data import extension from macOS.
2021-01-22 (first published: 2018-11-05)
4,002 reads
Stairway to SQL Server on Linux
SQL Server 2017 is the first SQL Server version that can be installed on Windows, Linux and inside a Docker container. This stairway series serves as a guide for the experienced SQL Server DBA to acquire skills and knowledge on this platform. This is an introductory series to installing Linux and SQL Server on Linux.
2018-08-09
3,053 reads
7 Things Every SQL Server DBA Should Know About Linux
In this tip John Grover will help you make the transition to SQL Server on Linux by explaining the things you need to know.
2017-07-19
4,274 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Alamat BCA KCP Cilandak KKO I Telp/Wa:0821-8200-233
Telp/Wa 62 821-8200-233 Jl. Raya Cilandak KKO No.9, RT.1/RW.5, Ragunan, Ps. Minggu, Kota Jakarta...
Alamat BCA KCP Arkadia Telp/Wa:0821-8200-203
Telp/Wa 62 821-8200-203 Gedung Perkantoran Hijau Arkadia, Tower C - Ground Floor, unit C103,...
BCA KCU KUNINGAN Telp/Wa:0821-8200-174
Telp/Wa 62 821-8200-174 Menara Karya, Jl. H. R. Rasuna Said Ground floor, RT.1/RW.2, Kuningan,...
Question of the Day
Adding new column with DEFAULT
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers
