TIL: Get-DbaLastBackup
(This post comes from one of our Junior DBAs – @SQLDork) I’ve been learning dbatools over the past week or so, you can read the previous blog posts here...
2020-05-06
23 reads
Dallas DBAs
TIL: Restore-DbaDatabase
(This post comes from one of our Junior DBAs – @SQLDork) If you haven’t read it already, i recently wrote a blogpost where i go over Backup-DbaDatabase, you can...
2020-04-29
22 reads
TIL: Backup-DbaDatabase
(This post comes from one of our Junior DBAs – @SQLDork) I’m learning how to use dbatools. Today’s command: Backup-DbaDatabase I’m using the 64-bit PowerShell ISE (running as administrator),...
2021-04-26 (first published: 2020-04-27)
532 reads
Data Bits – Episode 7 – Mary Elizabeth McNeely
20+ year Oracle DBA Mary Elizabeth stopped by the Data Bits virtual studio today! Quotables: “Corona Curls”, “rolling around in the food” and “Capitalist Pirate” You can reach Mary...
2020-04-24
17 reads
IRL #7: Test Restores and CheckDB
My Pluralsight course for new SQL Server DBAs Problem: My client asked me for a way to automate test restores and CheckDB either ad hoc or on a schedule,...
2020-04-29 (first published: 2020-04-23)
507 reads
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
15 reads
Data Bits – Episode 5 – Louis Davidson
The one and only – Dr. SQL – Louis Davidson (b|t|t|t) stopped by for a chat! Relational Algebra, Disney, Dollywood and a SQL Dump Truck ??
The post Data Bits...
2020-04-17 (first published: 2020-04-08)
271 reads
Data Bits – Episode 4 – Jules Behrens
SQL Server DBA Jules joins us on the show to talk DBA work, Chickens, Charity work, Mentoring and Shepherding (actual sheep!) See more at Jules’ site Edit: Honorable mentions: Minionware,...
2020-04-02
12 reads
Data BIts – Episode 3 – Ginger Grant
Trainer and Consultant extraordinaire Ginger Grant stops by to talk Machine Learning, Data Bricks, Certifications, Norwegian pastries and proper chocolate frosting Find Ginger at Desert Isle SQL or on Twitter
The post Data BIts...
2020-04-01 (first published: 2020-03-26)
207 reads
SQL Server HADR overview
My Pluralsight course for new SQL Server DBAs Image credit to Jeff (t) Back in June of 2019, I published this YouTube video covering the highlights of the various...
2020-03-25
57 reads
Blogs
Measuring What Matters: Operationalizing Data Trust for CDOs
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
A Small LLM Fail
By Steve Jones
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...
SQL Server Versions: Out With the Old, In With the Supported
By Kevin3NF
If your production SQL Servers are still running 2016 (or older) you’re basically banking...
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...
ETL Framework In Production
Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through...
SQL Server Ghosts
Comments posted to this topic are about the item SQL Server Ghosts