Get Space on SQL hardrive
I was recently asked to monitor the Database size on the SQL server, and display the results in a report.
2016-05-05 (first published: 2016-04-16)
785 reads
- Interests: Programming, 3D, Film, Visual Effects
SQL server Agent - Status
As part of the application to monitor SQL health I created.
The procedure returns status of the SQL server Agent
2016-04-29 (first published: 2016-04-16)
602 reads
2016-04-28 (first published: 2016-04-07)
496 reads
Format Date Time Function
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,529 reads
Determine Easter Sunday
Determine what day easter sunday will be based upon the year you pass the function
2016-04-25 (first published: 2016-03-30)
441 reads
Blogs
You should be running on SQL Server 2022
It’s me again with my apparently semi-annual blog post. This time we’re going to...
Removing a PowerShell Array Element–#SQLNewBlogger
By Steve Jones
I saw an article on this and realized I had no idea how to...
PostgreSQL Backup Failure
In this blog post I wrote a tip about fixing the PostgreSQL backup failure...
Forums
SSRS Query Designer - More Measures Exist Than Can Be Shown
Hey all, Currently trying to build a report in SSRS using SSAS cube. Load...
A Partial Count
Comments posted to this topic are about the item A Partial Count
The Stagnant Career
Comments posted to this topic are about the item The Stagnant Career
Ask SSC