SQL Server on Physical Machine Best Practices
The intent of this post is a quick reference guide based on the recommendation made on Pure Storage Support page in the Microsoft Platform Guide . The target audience...
2021-10-08
47 reads
Anthony Nocentino Blog
Measuring SQL Server File Latency
This post is a reference post for retrieving IO statistics for data and log files in SQL Server. We’ll look at where we can find IO statistics in SQL...
2021-11-29 (first published: 2021-10-06)
576 reads
Best Practices for SQL Server on VMware - Distilled
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
333 reads
Setting Permissions on Files Inside a Container for SQL Server
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)
273 reads
My Desktop Setup - Updated
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
7 reads
Pure Storage Flasharray SQL Server Snapshot Torture...You Kinda Asked for This
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
33 reads
Updated Pluralsight Course – Managing Kubernetes Controllers and Deployments
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
9 reads
Setting Trace Flags and Configuring SQL Server in Kubernetes
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
15 reads
Setting Trace Flags and Configuring SQL Server Containers
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
159 reads
Training
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
3 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers