2017-01-10 (first published: 2017-01-05)
939 reads
Scripts
Extracting string after and before a Character/Pattern
Finding characters/string before and after some character or pattern
2017-01-06 (first published: 2015-11-09)
264,420 reads
View Autogrowth on a daily basis
Sends an HTML formatted Email with autogrowth Information for the last 24 hours.
2017-01-03 (first published: 2016-12-20)
1,070 reads
Read SQL Server Logs with TSQL
This is a small script designed to read the Contents of the SQL Server log based on None or more criteria.
2016-12-30 (first published: 2016-12-13)
898 reads
T-SQL implementation of FizzBuzz
A T-SQL implementation of FizzBuzz consisting of a single SELECT statement.
2016-12-28 (first published: 2016-12-15)
952 reads
Query Performance comparison between instances
Execute at source, and will generate an output with TSQL commands to create temp tables filled with top 50 long lasting queries from all databases.
Then execute output at destination and will do the same and show comparison of matching queries!!
2016-12-19 (first published: 2016-12-06)
850 reads
Check constraint to prevent insertion of invalid characters.
A column level check constraint may be used to prevent insertion of data containing characters within a specific ASCII range.
2016-12-12 (first published: 2016-11-30)
2,323 reads
Dynamic sql for convert SQL statement to txt/csv file
Github link: https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_bcpUnloadSelect.sql
Quick export to flat file.
Before use please enable xp_cmdshell.
2016-12-09 (first published: 2015-05-12)
2,350 reads
Unpivot SQL Select Data
Stored procedure to transform a 'select' result set such that each column value is presented on a separate row.
2016-12-08 (first published: 2015-01-26)
2,406 reads
Keyboard shortcut to select top 1000
select top * from table by highlighting the fully qualified, including database, table, using a keyboard shortcut.
2016-12-07 (first published: 2015-05-07)
2,887 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
100 % Falschgeld verfügbar. £, $, €. WhatsApp: +1 (530) 590-5928
Wir liefern perfekt reproduziertes Falschgeld mit Hologrammen und allen verfügbaren Sicherheitsmerkmalen, das weder optisch...
100% FOLSKA SEDLAR TILLGÄNGLIGA. £,$,€ Whatsapp:+1(530)590-5928
Vi levererar perfekt reproducerade förfalskade pengar med hologram och alla tillgängliga säkerhetsfunktioner som är...
NCONOTE CONTRAFFATTE 100% DISPONIBILI. £, $, €. WhatsApp: +1(530)590-5928
Forniamo banconote contraffatte perfettamente riprodotte con ologrammi e tutte le caratteristiche di sicurezza disponibili,...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers