Get the Last date of the month for the given month and year In response to a post By: Anonymous - Posted: 2/16/2004 3:31:12 AM (Stored Procedure).... Thought that there should be a more efficient / functional way of doing this. And here it is. Of course, a function would probably be more efficient, and […]
2006-11-16 (first published: 2004-09-30)
100 reads
Given SQL text (@sql_txt) that will return XML data, run that XML data against an XSL template (@xsl_file_nm), and save the output to the specified outputfile (@out_file_nm). If @xsl_file_nm is not specified, then output is just saved as XML.This script is very usefull, but not secure. One could easily overload any of the script input […]
2004-09-17
280 reads
By Steve Jones
I wrote a post recently about pruning branches in git. That’s part of the...
By James Serra
I talked about Microsoft Fabric shortcuts in my blog post Microsoft Fabric – the...
By Brian Kelley
he rollback plan... what to do when things go wrong to get back to...
Hi all, We have a SSIS package that does 2 things in parallel: moves...
We have pretty big tables very sensitive to stats with many updates. Our systems...
I backup the Resource database from my SQL Server 2022 instance. I then install CUs 1, 2, 3, and 4. I have an issue and need to restore my Resource database from backup. Is there anything I need to do after restoring this database?
See possible answers