2018-08-13 (first published: 2018-07-18)
698 reads
Scripts
2018-08-08 (first published: 2018-07-22)
428 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)
806 reads
2018-07-17 (first published: 2018-06-26)
925 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,887 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)
511 reads
2018-07-09 (first published: 2018-07-04)
499 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,098 reads
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
BCA KCU TANGERANG CITY Telpon/WA:083179431313
WhatsApp:083179431313 Komp. Tangerang City Ruko Skandinavia Blok H 6-8 & 18-20, Jl. Jenderal Sudirman...
BCA Finance Cabang Kupang Layanan Mobil & Motor No.Telpon 087781685647
Whatsapp 087781685647 Sebelah kios kaos, Fatululi, Kec. Oebobo, Kota Kupang, Nusa Tenggara Tim.
BCA KCU TANGERANG Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Kisamaun No.57, RT.001/RW.006, Sukasari, Kec. Tangerang, Kota Tangerang, Banten 15118
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers