Creating SQL server Databases in AKS – Part 1
So, the point in the previous blog post was to leverage Persistent Volume Claims – PVC for data when using SQL server that it is needed in a stateful...
2021-08-03
20 reads
Blog Posts
Daily Coping 3 Aug 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-08-03
16 reads
Ethics in Modern Data this Saturday with the South Florida Data Geeks
This Saturday Aug 7, Christine and I will present our joint presentation on Ethics in Modern Data.
This session will explore a variety of considerations that modern data scientists and...
2021-08-03
12 reads
Looping Over Values in Power Automate Desktop
In this video Devin continues building on a previously created Power Automate Desktop Flow design and shows how to implement a solution that leverages the
2021-08-03
57 reads
3 Reasons Why Focusing on Tech Is The Worst Way To Deploy a HA/DR Solution
This past Thursday, Edwin Sarmiento presented a session for our Microsoft Data Platform Continuity Virtual Group entitled “3 Reasons Why Focusing on Tech Is The Worst Way To Deploy...
2021-08-02
14 reads
Azure Platform Series – renaming your YAML pipeline in Azure DevOps
This blog post is about YAML pipelines in Azure DevOps. I had a repo called InfrastructureAsCode for a client. I have been transitioning them to use YAML for their...
2021-08-02 (first published: 2021-07-15)
178 reads
Daily Coping 2 Aug 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-08-02
16 reads
Padding a string in SQL Server
I’ve been working on converting a piece of DB2 code into T-SQL and one of the functions I had to ... Continue reading
2021-08-02 (first published: 2021-07-15)
419 reads
The PowerBI Volleyball Report – Organizing Data To Start
One of my goals this year was to build a report that I can present to kids and parents showing the skills progression of their kids. I have attempted...
2021-08-02
17 reads
Estimating Nonclustered Index Size in SQL Server (Powershell)
I recently encountered a requirement to estimate the size of (a lot of) nonclustered indexes on some very large tables due to not having a test box to create...
2021-08-01
20 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers