Ordering T-SQL Scripts with Git and PowerShell
Learn how you can ensure that scripts are executed in a specific order with Git and PowerShell for use in a Docker container.
2019-05-28
4,991 reads
Containers
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,664 reads
Creating Your First SQL Server Docker Container in macOS
The use of macOS by developers and IT professionals has gained popularity the past few years. Running a sandboxed SQL Server, however, has been difficult. That changed when Microsoft...
2019-05-13
Creating a custom kubectl plugin to connect to SQL Server in Kubernetes
One of the really cool things about kubectl (pronounced cube control) is the ability to extend it’s functionality with custom plugins. These plugins are simply files named kubectl-xxx dropped...
2019-04-17
Getting Started with Docker
Achilleus has a brief primer on Docker: Now that we know, some basic definitions. It’s time we ask the main question! Why do I care? There are many reasons...
2019-04-15
SSIS, Docker, and Windows Containers, Part 3 – Adding the SSIS Catalog, Attempt 1
In this post, Andy Leonard show his first steps at adding an SSIS Catalog to a container. Spoilers: this attempt fails.
2019-04-05
Managing Kubernetes Resources
Vincent-Philippe Lauzon takes us through some thoughts on how to optimize Kubernetes resource allocation.
2019-04-04
2019-02-25
1,432 reads
2019-07-06 (first published: 2019-02-04)
2,762 reads
2019-01-07
917 reads
Blogs
SQL Server Alerts
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
Prompt AI helping with Auditing
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Collation errors...what is best way to deal with it?
Hi I have a SP that occasionally get this error: Cannot resolve the collation...
Was the index created or not?
Hi everyone I am getting an error when I create the index but I...
Question of the Day
Estimated Rows
I have two calls to the GENERATE_SERIES TVF in this code:
SELECT TOP 10 gs.value FROM GENERATE_SERIES(1, 10) AS gs ORDER BY NEWID () OPTION (RECOMPILE); go DECLARE @a int = 10; SELECT TOP (@a) gs.value FROM GENERATE_SERIES(1, @a) AS gs ORDER BY NEWID () OPTION (RECOMPILE);In the actual query plans, what is the estimated number of rows for each batch in SQL Server 2022? See possible answers