SQL – Backup Report
The simple query to find the database backup status
The select statment consists of
ServerNamedbnameBackupStartDateBackupFinishDateBackupAgeSizestatusTypeThe query will only run from sql 2005...
2014-03-05
767 reads
Prashanth Jayaram
INVENTORY – SQL- SSAS – SSRS – Excel Output – Email
Inventory
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2014-03-03
1,396 reads
INVENTORY – SQL- SSAS – SSRS – Excel Output – Email
Inventory
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2014-03-03
610 reads
PowerShell – Export SQL Data to Excel with Powershell
SQL Server Export to Excel with Powershell is very useful for all sorts of activities – ETL and reporting are some...
2014-02-28 (first published: 2014-02-24)
5,037 reads
PowerShell – SSRS Inventory – Automatic – Excel File – EMAIL
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2014-02-27
2,028 reads
PowerShellGUI Tools – Disk,Memory and Process – Modules
I’ve created a script which gives details of Disk, Memory and Process and its represented graphically.
Here, the scripts are enclosed in...
2014-02-20
1,716 reads
Top 10 Process Listing By Memory Consumption – GUI Tool
This Powershell GUI tool is used to list Top 10 memory consumption process of a given computer[local /Remote]. In the...
2014-02-07
951 reads
PowerShell – SQL Inventory – Automatic – Excel File – EMAIL
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2014-02-04
2,058 reads
PowerShell – Memory Details GUI Tool
This Powershell Memory GUI tool is used to fetch memory information from a computer. In the screen that follows, enter...
2014-01-31 (first published: 2014-01-27)
2,657 reads
PowerShell – Program List – 32/64 Bit – Local/Remote Machies
This Powershell script list all the installed application on both 32 and 64 bit applications, particularly useful for people managing...
2014-01-20
1,052 reads
Blogs
Azure SQL offerings
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
T-SQL Tuesday #183 Roundup
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
A Little Brainstorming with an AI
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Forums
Moving Database Files
I just learned that my database was created on my C:\ drive in the...
Migrate MSSQL to MYSQL - Different Servers
I am needing to migrate a MSSQL db to MySQL, on a different server...
how do you manage new columns in a tabular table
Hi we run 2019 ssas std. Yesterday i imported my tabular project to vs...
Question of the Day
Mixed Backups
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers