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)
758 reads
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)
572 reads
2016-04-28 (first published: 2016-04-07)
484 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,122 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)
417 reads
Blogs
SQLSaturday Auckland: Certification Exams Inside Out this Weekend!
By Will Assaf
Looking forward to virtually presenting at SQLSaturday Auckland 2020 this weekend! I'll be presenting...
Data Cleanup for WordPress Tags without a Plugin
By Steve Jones
Over the years I’ve had this blog, I’ve added lots of tags. In 15...
Capturing Queries Can Be a Pain
The moment you decide you want to monitor your SQL Server instance for query...
Forums
Table Variable Deferred Compilation (SQL 2019)
Comments posted to this topic are about the item Table Variable Deferred Compilation (SQL...
Error processing SSAS cube using TMSL via SQL Server Agent Job
Hi, I am trying to automate SSAS cube processing by having an SQL Server...
Beta user call- Google Cloud Platform SQL 2019 solutions
We are looking for SQL developers as beta users for our SaaS solution (...
Ask SSC