Introduction A popular joke about DBAs and database backups goes like this. There are two types of DBAs: DBAs that do backups DBAs that will do backups The joke is only stating the obvious – lack of database backups might be the end of a DBA career and/or the supported business. Unfortunately, that joke fails […]
2020-01-07
9,705 reads
Introduction The SSISDB database (a.k.a. the SSISDB catalog) was introduced back in SQL Server 2012 to de-clutter the MSDB database and provide an in-house logging and reporting infrastructure. In a nutshell, SSISDB is an SSIS framework making SQL Server Integration Services more robust and enterprise-friendly by providing the following features: Database backup Database encryption Support […]
2019-12-26
6,055 reads
By Steve Jones
I had been meaning to post this, so as I finished a piece that...
By Steve Jones
fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through...
The post Lukáš Karlovský: I got the green light from management and built Fabric...
Comments posted to this topic are about the item The Pervasive Nature of Open...
Has anyone done a migration from sharepoint integrated ssrs to native? I'm not finding...
What is wrong (if anything) with this code?
SELECT *
FROM Sales.SalesOrderHeader AS soh
WHERE customerid IN (SELECT soh.CustomerID
FROM Sales.Customer AS C
WHERE soh.CurrencyRateID = 1
ORDER BY c.ModifiedDate)
See possible answers