2018-08-13 (first published: 2018-07-18)
698 reads
Scripts
2018-08-08 (first published: 2018-07-22)
431 reads
Table Space Used in DB
A quick script that provides the sizes of the tables in your database, including schema and choice of sort method
2018-08-07 (first published: 2018-07-29)
807 reads
2018-07-17 (first published: 2018-06-26)
926 reads
STRING and FIND SQL Functions
SQL Functions that simplify search and operations over strings on SQL Server (starting with 2012)
2018-07-11 (first published: 2018-07-06)
4,908 reads
User Stored Procedure for Backup of user databases
This script is intended to demonstrate how we can create a stored procedure for the user responsible for backing up user databases in a default storage location.
2018-07-10 (first published: 2018-07-05)
512 reads
2018-07-09 (first published: 2018-07-04)
500 reads
Create Database using dynamic SQL
The T-SQL script created a databases using the default file locations from SQL server configuration and prints them in the end.
2018-07-05 (first published: 2018-06-28)
1,957 reads
User access management on DB & object level
It will help to find and manage the users access on DB level
2018-07-05 (first published: 2018-06-26)
421 reads
2018-06-15 (first published: 2018-01-04)
2,099 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers