SQL Server agent jobs without notification using T-SQL
This article will describe how to get a list of SQL Server agent jobs without notifications using T-SQL . Read more here
2022-01-28
164 reads
DBBlogger
Azure Cosmos DB introduction
Azure Cosmos DB is the next-generation database that offers the highest performance, availability, and scale, built for globally distributed
2022-01-27
109 reads
Display dates between two input dates using SQL DATEDIFF function in SQL Server
SQL Server has a very useful function called DATEDIFF. This function is used to calculate the difference between the two dates. Read more he
2022-01-27
296 reads
T-SQL query to change the job owners for all jobs owned by a specific login
Many SQL Server DBAs manage jobs through the SSMS GUI and do not know about the underlying T-SQL scripts being run. This blog shows how to u
2022-01-25
305 reads
Identify When your SQL Database Was Last Used
Database servers are used for storing vast amounts of data. It is essential to know when any user last used the database. This blog will cov
2022-02-07 (first published: 2022-01-24)
1,442 reads
T-SQL Query to find Supported Compatibility Level Values in SQL Server
The question came up on the forum - how do I find all the possible values for a specific compatibility_level in SQL Server? Let's check .
2022-01-19
52 reads
T-SQL Query to find Orphan data and log files of SQL Databases
Are you a DBA? Then you'll love this free T-SQL script. This script helps you find orphaned data and log files of SQL Databases.
2022-01-19
23 reads
T-SQL Query to find SQL database age and number of tables in SQL Server
SQL Server - The following T-SQL statement helps find the SQL Database age based on the created date and number of tables.
2022-01-18
18 reads
Export Windows applications logs in CSV format using SQL Server query
The Windows application logs are used by various applications to write new events. This blog exporting these logs into CSV format
2022-01-18
27 reads
T-SQL script to Backup database SQL Server with TimeStamp
The T-SQL script takes a full backup of all databases(System databases and user databases) in the format of DataaseName-YYYY-MM-DD-HH-MM-...
2022-01-18
43 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers