2017-08-03
15,086 reads
2017-08-03
15,086 reads
2014-12-04 (first published: 2014-11-17)
1,410 reads
Check 96 server and database settings to make sure they match your expectations in your databases with this script.
2014-05-06
4,630 reads
2013-07-03 (first published: 2013-06-07)
851 reads
What is the difference between an expert DBA and a Master DBA? This piece from William Talada talks about Objects, Relationships, Systems, and Processes and how they may relate to your job as a DBA.
2012-09-11
2,531 reads
Powerful function to find strings containing or excluding classes of ASCII characters.
2012-09-10 (first published: 2012-08-28)
1,033 reads
Shows awesome view of columns with constraints and indexes and foreign keys to spot errors fast.
2010-08-04 (first published: 2009-12-03)
1,450 reads
IsNumber does weak checking and fails cast to BigInt so I wrote IsBigInt to replace it.
2010-06-11 (first published: 2010-05-05)
3,139 reads
William Talada brings us a short article to help you check your ANSI NULL settings and gives you a few reasons why you might want to make them consistent.
2010-01-27
7,871 reads
Display a row vertically when a table has hundreds of columns to avoid scrolling.
2010-01-21 (first published: 2009-12-30)
3,225 reads
In the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers