I’m a DBA. Do I really need to know Kubernetes?
Welcome to February 2020. It’s the second month of the year 2020! I remember sitting at a server with SQL Server 6.5 installed on it, worrying about the Y2K...
2020-02-05
402 reads
#PowershellBasics: Get input using Read-Host
Conditions are the life blood of programming. This condition is met so now I need to do this task. That ... Continue reading
2020-02-11 (first published: 2020-02-05)
555 reads
Allow users to start/stop Azure VMs
Today I wanted to cover how you can grant the least privilege required to stop, start or restart an Azure VM. This is also a fun great example of...
2020-02-04
10 reads
Allow users to start/stop Azure VMs
Today I wanted to cover how you can grant the least privilege required to stop, start or restart an Azure VM. This is also a fun great example of...
2020-02-10 (first published: 2020-02-04)
3,177 reads
Azure Databricks Performance Notes
(2020-Feb-04) I didn't name this blog post as "Performance Tips" since I'm just creating the list of helpful notes for myself for tuning the performance of my workload with delta...
2020-02-14 (first published: 2020-02-04)
2,324 reads
SQL Server Identity Skipping
My Pluralsight course for new SQL Server DBAs SQL Server may skip 1000 numbers on an Identity column if the server crashes. Here’s why: Too long, didn’t watch version:...
2020-02-04
25 reads
Introduction to StudyYourServer
I made a video (in Spanish) on how to use and which features offer my open-source project StudyYourServer
You are free to collaborate, fix it and add new functionalities!
The...
2020-02-04
35 reads
Introduction to StudyYourServer
I made a video (in Spanish) on how to use and which features offer my open-source project StudyYourServer
You are free to collaborate, fix it and add new functionalities!
The...
2020-02-04
141 reads
The State of Database DevOps 2020
I’ve been an advocate for database DevOps since before DevOps was a thing. When I first switched from being a developer full-time to being a DBA full-time, the first...
2020-02-10 (first published: 2020-02-04)
335 reads
Demystifying STUFF() function
This article will talk about myth with Stuff() function that it can be only used for concatenation. We'll do the reality check to demystify the Stuff() function.
2020-02-04
571 reads
Blogs
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers