2017-08-03
4,756 reads
William Talada
2014-12-04 (first published: 2014-11-17)
1,396 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,490 reads
2013-07-03 (first published: 2013-06-07)
837 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,520 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,007 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,442 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)
1,117 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
6,518 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)
2,843 reads
Blogs
Running SQL Server containers as non-root
Recently I noticed that Microsoft uploaded a new dockerfile to the mssql-docker repository on...
Interview with Greg Low
By damianwidera
This is the sixth interview we have done. This time our guest is Greg...
Azure SQL Database Types
By Arun Sirpal
I want to do a quick summary post of the many different types of...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
Database in Recovery Pending state
Good Morning, We had an issue yesterday where SQL Alerts were generated from one...
Import data from Kafka
Hi there, I am looking for a way to import kafka event data into...
Ask SSC