2017-08-03
13,046 reads
William Talada
- Interests: non-dualism
2014-12-04 (first published: 2014-11-17)
1,405 reads
Context Is Everything - Check Your Settings
Check 96 server and database settings to make sure they match your expectations in your databases with this script.
2014-05-06
4,540 reads
2013-07-03 (first published: 2013-06-07)
845 reads
Objects, Relationships, Systems, And Processes
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,524 reads
ASCII Character Groups in String
Powerful function to find strings containing or excluding classes of ASCII characters.
2012-09-10 (first published: 2012-08-28)
1,019 reads
Find botched constraints, idxs, fks
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,449 reads
IsNumber fails cast while IsBigInt passes cast
IsNumber does weak checking and fails cast to BigInt so I wrote IsBigInt to replace it.
2010-06-11 (first published: 2010-05-05)
2,279 reads
Get Your ANSI_NULLs Settings Consistent
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,308 reads
Display Rows Vertically or Alphabetically
Display a row vertically when a table has hundreds of columns to avoid scrolling.
2010-01-21 (first published: 2009-12-30)
3,055 reads
Blogs
Daily Coping 24 Sept 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Using environment variable files for SQL Server in containers
There are a whole bunch of environment variables that can be used to configure...
How to Design Backups in SQL Server?
By nelsonaloor
The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...
Forums
Have a total by Entity instead of Line total
How could I turn this into a total by Entity rather that just having...
latency sql server
Hello everyone I have big problem of slowness on a SQL instance in azure...
Load 2 files to SQL on 1 connection
I have 2 files I'm importing and have 2 different SQL tables from the...
Ask SSC