If you have a requirement where you need to copy all your backup files to any remote shared location from your local folder/drive and after that you need to do a periodic cleanup of the backup files, you can use my script.
2016-10-18 (first published: 2015-06-01)
2,090 reads
2016-10-17 (first published: 2016-10-03)
879 reads
When code is getting stall, sometimes the execution plans are point to the wrong or out dated or old objects. You would need to recompile all the stored procedures
2016-10-14 (first published: 2016-09-26)
4,391 reads
This stored procedure extracts template variable names and values from a SQL result set in order to process the template.
2016-10-13 (first published: 2016-09-14)
368 reads
SQLCMD is one of many methods to export your database data to some text file
2016-10-12 (first published: 2016-09-27)
22,174 reads
DBA many a times need to shrink the log files if that grows very large. Though I am not recommending to do it daily or often but if space is an issue and you want to release space to OS, you may use the script.
2016-10-11 (first published: 2016-09-22)
948 reads
If you have any requirement to extract next 100 sequential date from a present date, you can use the below script. You can change the @datetimeformat value and the output will appear in the same format.
2016-10-10 (first published: 2016-09-26)
522 reads
2016-10-07 (first published: 2016-09-20)
1,570 reads
If you have a requirement to enable email notification to all the SQL Jobs, then you may use my script.
2016-10-06 (first published: 2016-09-20)
1,072 reads
Checks currently running sessions and blocking queries with session information
2016-10-05 (first published: 2016-09-16)
809 reads
How I used AI for this postChatGPT to generate images based on info specifically...
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Comments posted to this topic are about the item Understanding Temp Tables and Table...
Comments posted to this topic are about the item The Data API Builder MCP...
Comments posted to this topic are about the item Collecting Data Is Hard
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers