2018-08-08 (first published: 2018-07-22)
411 reads
Scripts
Table Space Used in DB
A quick script that provides the sizes of the tables in your database, including schema and choice of sort method
2018-08-07 (first published: 2018-07-29)
787 reads
2018-07-17 (first published: 2018-06-26)
905 reads
STRING and FIND SQL Functions
SQL Functions that simplify search and operations over strings on SQL Server (starting with 2012)
2018-07-11 (first published: 2018-07-06)
4,531 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)
494 reads
2018-07-09 (first published: 2018-07-04)
477 reads
Create Database using dynamic SQL
The T-SQL script created a databases using the default file locations from SQL server configuration and prints them in the end.
2018-07-05 (first published: 2018-06-28)
1,874 reads
User access management on DB & object level
It will help to find and manage the users access on DB level
2018-07-05 (first published: 2018-06-26)
411 reads
2018-06-15 (first published: 2018-01-04)
2,078 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)
1,289 reads
Blogs
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Forums
Events of System_health extended event serious or not
I have listed the event names present in my system_health extended event report. Based...
String Variable and sp_executesql
I am not understanding why this command completes "successfully" and it seems correct to...
printing complete path
get-ChildItem C:\ -recurse -erroraction silentlycontinue | sort length -descending | select -first 10 FullName,length...
Question of the Day
Superseded Indexes
Which of these indexes is superseded by another?
See possible answers