Data Bits – Episode 6 – Peter Shore
SQL DBA Peter Shore (t) and I had a great time recording this. Quotables: “Vehemently OK”, “Intentional Accidental DBA”, “Professional Nerd”, “Senior DBA as defined by AARP” I cut...
2020-04-13
26 reads
Blog Posts
Develop Resiliency
We are all going through some tough times. It’s tougher for some more than others. Now is the time when you have to work on being resilient, and it...
2020-04-13
17 reads
Learning Postgres:Installation
I had the opportunity of working on a project converting a postgres database to a sql server based one at work. I used this opportunity to learn more of...
2020-04-13 (first published: 2020-04-06)
319 reads
Upcoming Webinar: Learning from Data Breaches
Recently I partnered up with Kevin Kline (SentryOne blog | twitter) and SentryOne to record a webinar on learning from data breaches. We start by talking about Mitre’s ATT&CK...
2020-04-13
28 reads
Design patterns (short description)
Here is some short description of GoF design patterns. It is just to remind the explanations. so first you have to understand each design pattern separately.Adapter Pattern: Convert the interface...
2020-04-11
22 reads
Design patterns (short description)
Here is some short description of GoF design patterns. It is just to remind the explanations. so first you have to understand each design pattern separately.Adapter Pattern: Convert the interface...
2020-04-11
92 reads
Charting in Azure Data Studio
The March 2020 release of Azure Data Studio (ADS) includes a charting feature for SQL queries. This is a quick look at the feature, which I think will have...
2020-04-10 (first published: 2020-03-30)
554 reads
Daily Coping 10 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-10
22 reads
Diversity & Inclusivity – a personal journey
This article is about my own experiences in making my user group and community events more inclusive for people from diverse backgrounds. I am going to use growing my...
2020-04-10 (first published: 2020-03-31)
861 reads
The Car Game
I started this on Facebook, privately with friends. I heard about it from one of them and liked it. I didn’t get many guesses, so I took a chance...
2020-04-10
257 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