2016-04-28 (first published: 2016-04-07)
546 reads
2016-04-28 (first published: 2016-04-07)
546 reads
An inline table valued function (iTVF) that can be used to calculate age in years.
2016-04-27 (first published: 2016-04-06)
1,132 reads
Function do return common datatime formats of a date.
select dbo.[KDT_FN_FORMATDATETIME]('LASTDAY DDDD',getdate())
2016-04-26 (first published: 2016-03-29)
1,700 reads
Determine what day easter sunday will be based upon the year you pass the function
2016-04-25 (first published: 2016-03-30)
505 reads
If you have job that opens a transaction and hangs too long causing a Prod issue this will be a big help to let you know.
2016-04-22 (first published: 2016-03-30)
745 reads
This is an version independent stored procedure to get the backup date from a backup file.
It's tested for SQL 2005, 2008(R2), 2012 and 2014.
Consider it a template to which you can add more output parameters from the headerinfo to meet your requirements.
2016-04-21 (first published: 2016-03-31)
407 reads
A stored procedure to generate database file moves along with Robocopy script and the attach / detach scripts
2016-04-20 (first published: 2016-04-04)
692 reads
A brand new, high-performing, "GetNumbers" or "fnTallyTable" function that can be used for defeating RBAR.
2016-04-19 (first published: 2016-03-23)
1,495 reads
This stored procedure will show all possible datetime formats when used with the style argument in the CONVERT() function. It also shows sample output from the date part arguments.
2016-04-13 (first published: 2014-10-10)
2,545 reads
2016-04-12 (first published: 2014-03-12)
2,434 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers