The intent of this post is a quick reference guide based on the recommendation made in “Architecting Microsoft SQL Server on VMware vSphere” April 2019 version. The target audience...
2021-09-29
320 reads
This post will walk you through setting file permissions on database files copied into a container. The SQL Server process sqlservr running in containers runs as the non-privileged user...
2021-10-08 (first published: 2021-09-25)
265 reads
Every once in a while when I’m recording a Pluralsight course, I’ll take a photo of my desk to let people see the behind the scenes of the process....
2021-09-17
3 reads
By Argenis Fernandez
This post is archived here. Pleae reach out to me, Anthony Nocentino if you have any questions.
I gotta admit, some of you are really hard to convince....
2021-09-15
30 reads
My updated course “Managing Kubernetes Controllers and Deployments” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to dive right...
2021-09-14
3 reads
In this blog post, we will walk through a few examples of configuring SQL Server in Kubernetes. First, we will create a Deployment for SQL Server, override the container’s...
2021-09-12
8 reads
In this blog post, we will walk through a few examples of how to configure SQL Server in Docker Containers. First, we will configure a container at runtime by...
2021-09-12
141 reads
Centino Systems provides online training though Pluralsight. Access our resources anytime and from anywhere. Pluralsight offers the highest quality online training available with very affordable options. Check it out...
2021-09-06
SQL Server on Kubernetes - Designing and Building a Modern Data Platform Build a modern data platform by deploying SQL Server in Kubernetes. Modern application deployment needs to be...
2021-09-06
1 reads
SQL Server Pure Storage SQL Server Platform Guides Pure Storage SQL Server Best Practices Pure Storage SQL Server Scripts on GitHub Pure Storage ActiveCluster with SQL Server Azure...
2021-08-17
28 reads
I thought I didn’t care about linting, and lately, I haven’t written a lot...
Want to blend your love of marketing with the power of data? Becoming a...
I live for questions and this was an interesting one. Can you see Table...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Hi everyone, I’ve been tasked with migrating a Standalone SQL Server instance to a...
Programmatic advertising offers numerous advantages for insurance businesses advertising looking to enhance their marketing efforts efficiently....
What is returned when I run this code in SQL Server 2022?
CREATE TABLE CatIndex
( indexval VARCHAR(20)
)
GO
INSERT dbo.CatIndex (indexval) VALUES ('1'), ('2'), ('3')
GO
SELECT CHOOSE(indexval, cast('2025-01-01' AS DATE), CAST('2025-02-01' AS DATE), CAST('2025-03-01' AS DATE))
FROM dbo.CatIndex AS ci See possible answers