2015-05-01 (first published: 2013-08-13)
3,748 reads
2015-05-01 (first published: 2013-08-13)
3,748 reads
Found this lovely T-SQL script to display the SELECT statement for any table.
2013-08-22 (first published: 2013-08-06)
3,213 reads
A simple T-SQL script to display the number of days since the last database backup.
2013-08-07 (first published: 2013-07-29)
1,576 reads
ADD SQL OBJECTS(TABLES, VIEWS, SPS, UDFS ET AL) TO ALL THE DATABASES ON THE SERVER.
2011-11-14 (first published: 2011-09-19)
652 reads
2011-09-15 (first published: 2011-09-05)
2,898 reads
2011-08-05 (first published: 2011-07-23)
2,185 reads
A quick and simple SysProcess query which will display most of the common parameters of interest.
2011-07-28 (first published: 2011-07-23)
1,370 reads
By SQLBalls
Hello Dear Reader! After a weekend with a lot of activities, it was a...
By Steve Jones
In order to generate migrations, we need to configure Flyway to use a shadow...
By Steve Jones
Today’s coping tip is to get back in contact with an old friend. This...
I would like to know what certifications or paths to choose in order to...
Hi all, I created Extended Events session to capture sql_batch_completed for duration>5 sec sending...
Hello everyone!! I have this SQL statement: SELECT dateadd(year,(2023 - year(DH.DOC_DATE)),DH.DOC_DATE) AS 'Date', DD.STORE_CODE...