Backup Growth Trend Check
-- Backup Growth Trend Check To Understand how much disk space you need in future
2015-06-23 (first published: 2015-06-02)
1,301 reads
Scripts
Disk Free Space Check
IF you have a requirement to check disk free space and want to report to the team using email, can use my script
2015-06-17 (first published: 2015-06-03)
1,669 reads
Standardizing DBMAIL Profile & Account Setup for Notification
If you have a requirement to setup with a default global dbmail profile and account you can use my script.
2015-06-16 (first published: 2015-05-28)
1,088 reads
2015-06-15 (first published: 2015-05-22)
2,438 reads
Count character matches with DATALENGTH function
https://github.com/ktaranov/sqlserver-kit/blob/master/Scripts/Count%20character%20matches.sql
2015-06-08 (first published: 2015-05-18)
1,092 reads
Disk Free Space Check
IF you have a requirement to check disk free space and want to report to the team using email, can use my script
2015-06-03
350 reads
Detach & Attach Procedure
For successful run, Your SQL Server service account should have permission to old location & new location
2015-05-27 (first published: 2015-05-10)
1,061 reads
2015-05-26 (first published: 2015-05-08)
1,151 reads
2015-05-20 (first published: 2015-05-05)
2,347 reads
Taking Backup Of All DBs
Wrote the script to take compressed backup with combining many other features.
2015-05-18 (first published: 2015-04-29)
1,085 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers