Microsoft Data Platform and PowerShell MVP, Chrissy Lemaire (b|t) sat down with us in the virtual studio Saturday, and we had a blast getting to know her! Quotables: “This...
2020-05-28 (first published: 2020-05-18)
316 reads
Today’s dbatools command: Measure-DbaBackupThroughput This one’s a smaller command, but that doesn’t mean it’s without use. If you need information on backup speeds (throughput) or early warning of possible...
2020-05-26
16 reads
Another blog post, another dbatools command. Today’s command: Get-DbaAgentJobHistory Basic command, gets all the job history info and pipes it to gridview, because there’s a LOT of info here....
2020-05-14
51 reads
(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
20 reads
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)
496 reads
(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
14 reads
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
12 reads
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)
268 reads
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
13 reads
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
6 reads
By Brian Kelley
When I look at a system and think about its security model, the first...
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
Dears, Hope this message finds you well We have a log table which is...
Comments posted to this topic are about the item The Backup File Extension
Comments posted to this topic are about the item Ingest and Retrieve data from...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers