Met an eager young volunteer at SQLSatBR over the weekend who inspired me to update a blog post that hadn't been refreshed in a few years. See the [UPDATED] Training...
2023-08-18 (first published: 2023-07-31)
592 reads
As a part of a recent Data Exposed that I was on, there was an ADS update which mentioned Copilot being added. Since I’ve been experimented, I decided to...
2023-08-17
69 reads
Looking to attend a security summit in cooler weather that will benefit students? Applachian State holds an annual cybersecurity summit and this year it is scheduled for September 8,...
2023-08-17
26 reads
A Basic SQL Script to Monitor Long Running SQL Server Agent Jobs
As a SQL Server DBA, especially Production/Operations DBA in a relatively large environment,...
2023-08-16 (first published: 2023-07-31)
816 reads
Inside Redgate Software, someone posted a picture and was asking if anyone knew who the person was. In this case, there had been a conversation at an event, and...
2023-08-16
18 reads
It’s been a bit since I did one of these so let’s go back to the basics. Best practices. We ... Continue reading
2023-08-16 (first published: 2023-08-01)
478 reads
This month I prompted bloggers to talk about what database job titles mean to them. Thank you to all who posted on this topic! Don’t worry; if you still...
2023-08-16 (first published: 2023-08-15)
11 reads
If you’re like me, you sometimes wonder how different other environments are from the one I work in. Well, the ones I used to work in. These days I...
2023-08-15
3 reads
Why should you patch your SQL Server instances? Compliance, stability, security, reliability, functionality, and more. Microsoft regularly releases updates to SQL Server known as Cumulative Updates (CUs). Cumulative updates...
2023-08-15
14 reads
I haven’t touched Docker Swarm for a looooong time but I was asked about running SQL Server in Swarm at a conference a while back…so here’s how it can...
2023-08-14 (first published: 2023-07-26)
320 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers