Archives: August 2015
Following my last post about using Power Bi with my DBA Database I have been asked if I would share the PowerShell scripts which I use to populate my database. They are the secondary part to my DBADatabase which I also use to automate the installation and upgrade of all… Read more
Every good DBA should have a DBA database. A place to store information about all of their instances and databases.
I have an InstanceList table which looks like this
CREATE TABLE [dbo].[InstanceList]( [InstanceID] [int] IDENTITY(1,1) NOT NULL, [ServerName] [nvarchar](50) NOT NULL, [InstanceName] [nvarchar](50) NOT NULL, [Port] [int] NOT NULL, [AG]…