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,998 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,702 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,436 reads
2019-07-06 (first published: 2019-02-04)
2,768 reads
2019-01-07
924 reads
Blogs
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Forums
How Good Is Pench National Park for First-Time Wildlife Travelers?
Pench National Park is one of the best places to visit for the first...
Azure SQL DBA certification
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Faster Data Engineering with Python Notebooks: The Fabric Modern Data Platform
Comments posted to this topic are about the item Faster Data Engineering with Python...
Question of the Day
Which Result II
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
exec('SELECT ProductName FROM product;')
END;
GO
exec etl.GettheProduct
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers