Goal Progress for Jan 2023
The grade for January is a D. Details below, but just not making a lot of progress in these areas. I set goals at the beginning of the year,...
2023-02-01
12 reads
The Voice of the DBA
Context Info Across Databases–#SQLNewBlogger
Does Context Info work across databases? This post shows it does. Another post for me that is simple and hopefully serves as an example for people trying to get...
2023-02-15 (first published: 2023-02-01)
203 reads
Daily Coping 1 Feb 2023
Today’s coping tip is to decide to lift people up rather than put them down. This is something I am trying to practice more as a coach, pointing out...
2023-02-01
9 reads
Daily Coping 31 Jan 2023
Today’s coping tip is to take a small step towards and important goal. One of my goals this year was to work on a way to score myself with...
2023-01-31
5 reads
Flyway Desktop Projects for My PoC
In a previous post, I set up the basic databases for the PoC project I’m working on. In this next post, we’ll get the Flyway Desktop projects set up...
2023-01-31 (first published: 2023-01-30)
30 reads
Daily Coping 30 Jan 2023
Today’s coping tip is to plan something fun and invite others to join you. The fun thing is actually skiing today. My wife and I wanted to get some...
2023-01-30
10 reads
Daily Coping 27 Jan 2023
Today’s coping tip is to try something new to get out of your comfort zone. I did two things here. First, I’ve been participating in a Jan American Cancer...
2023-01-27
11 reads
Daily Coping 26 Jan 2023
Today’s coping tip is to focus on what’s good, even if today feels tough. Yesterday was a tough day. I got busy, distracted, had some bad news come up,...
2023-01-26
13 reads
Using SQL Data Compare from the Command Line with a Project
SQL Data Compare (SDC) is a great way to sync data among tables. It’s a software utility analogous to SQL Compare, but working with data rather than schema. I...
2023-02-17 (first published: 2023-01-25)
733 reads
Daily Coping 25 Jan 2023
Today’s coping tip is to be gentle with yourself when you make mistakes. I forgot about a commitment. I had agreed to do a webinar and prepare some content....
2023-01-25
5 reads
Blogs
Build a Snapshot Backup Catalog in Pure Storage - The SQL Server 2022 Edition
In my previous post, I showed you how to build a snapshot backup catalog...
Advice I Like: Training Employees
By Steve Jones
Train employees well enough that they could get another job but treat them well...
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Why Data Modelling Still Matters - More Than Ever
Comments posted to this topic are about the item Why Data Modelling Still Matters...
hops from sql server to mysql to s4 hana - possible?
Hi when i think of server hops , i think of how kerberos assists...
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers