TIL: Get-DbaErrorLog
Ed: SQLDork is a Junior DBA on the team here, learning the DBATools in addition to normal DBA stuff™ Today’s dbatools command is Get-DbaErrorLog, which is very similar to...
2020-05-29
21 reads
Kevin3NF
- Interests: Cycling, family, sci-fi, DBA stuff
Data Bits – Episode 8 – Chrissy LeMaire
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)
319 reads
TIL: Measure-DbaBackupThroughput
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
17 reads
TIL: Get-DbaAgentJobHistory
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
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
21 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)
500 reads
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
15 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
14 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)
270 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
13 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
Cannot install development version.
A while into install I get a Microsoft OLE DB Driver for SQL Server....
More Funny SELECTs
Comments posted to this topic are about the item More Funny SELECTs
Reducing the Cycle Time
Comments posted to this topic are about the item Reducing the Cycle Time
Question of the Day
More Funny SELECTs
What does this code return?
SELECT
( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2011'
AND soh.OrderDate < '01/01/2012') AS OrdersIn2000
, ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2012'
AND soh.OrderDate < '01/01/2013') AS OrdersIn2001
, ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2013'
AND soh.OrderDate < '01/01/2014') AS OrdersIn2002;
GO See possible answers