2019-06-14
1,477 reads
Junior Galvão - MVP
2019-05-14
622 reads
2019-03-21
683 reads
2019-02-27 (first published: 2019-02-20)
342 reads
Files with larger disk consumption
This script features as we can through the CTE Top10FilesWithLargerDiskConsumption the top ten data files that are showing greater consumption of hard drive related data-reading activities.
2019-01-15 (first published: 2019-01-08)
677 reads
User Stored Procedure for Backup of user databases
This script is intended to demonstrate how we can create a stored procedure for the user responsible for backing up user databases in a default storage location.
2018-07-10 (first published: 2018-07-05)
382 reads
2018-06-22
912 reads
Entering random data into a table
Este bloco de código tem o objetivo de demonstrar como podemos inserir um quantidade de linhas de registro de dados aleatórios de uma tabela no Microsoft SQL Server.
2018-06-14 (first published: 2018-06-12)
402 reads
2018-05-22
803 reads
2018-04-20
678 reads
Blogs
SQL in the City Comes Back to Seattle
By Steve Jones
This year at the PASS Summit, Redgate is holding our SQL in the City...
Backup Techniques for SQL Server on Azure Virtual Machines
By Arun Sirpal
In the previous blog post I did a quick overview building a SQL VM...
SQLCover 0.5 - Fixes, smaller features and an exciting surprise
By Ed Elliott
It has been a little while but I have updated SQLCover to include a...
Forums
Exception handling for backup related errors.
Hi All, Need some help in exception handling. In below code, I want to...
DB Log File Location Error
Hi, I am taking full backup of db on remote location. The issue we...
SQL query help
I have a table like this: Year month col_abc1 col_abc2 col_abc3 col_abc4 col_processing 2019...
Ask SSC