This level of the Stairway to Exploring Database Metadata focuses on indexes and all the information you can gather about them.
2020-08-05 (first published: 2016-09-28)
3,617 reads
2020-06-27
135 reads
There's a saying about what it says about a person to assume something. However it's something we all do every day. Phil Factor brings us a guest editorial about assumptions in SQL code.
2020-06-25 (first published: 2009-04-08)
342 reads
2020-05-30
113 reads
The Covid-19 pandemic has provided examples of how uncertain data can eventually be presented to the public as certainty. How, as data people, should we represent uncertainty in our data?
2020-05-02
144 reads
Idempotence is the property of certain operations in mathematics and computer science, that can be applied multiple times without changing the result beyond the first time they are run. When you are making changes to a database to deploy a new version, you need to be sure that certain changes aren’t made twice, or in the wrong order.
2020-04-15 (first published: 2016-12-21)
9,008 reads
Phil Factor provides a powerful DOS batch script which, when coupled with SQL Compare CLI, allows you to build databases from source, during development, and fill them with the specific datasets required for testing.
2020-03-19
437 reads
In this level, I’ll introduce Extended Properties. As with the previous levels, I want to illustrate as much as possible with practical and immediately useful code.
2020-03-18 (first published: 2017-02-22)
2,908 reads
There is a lot of information held in SQL Server metadata about your SQL Server procedures, triggers, views and functions. Some of it is valuable, other nuggets are useful and a few are rather dull but worthy. It really all needs to be tied together to tell the full story, especially if you are not able to, or do not want to, query the metadata directly.
2020-03-17
With progress thwarted by a committee of panjandrums, will T-SQL forever remain in the doldrums? So wonders Phil Factor.
2020-03-09 (first published: 2017-07-10)
337 reads
By Steve Jones
In a previous post, I set up the SQL Clone server. This is really...
Learn how to use the SQL Server Agent Alerting system to capture Availability Group...
Learn how to use the SQL Server Agent Alerting system to capture Availability Group...
You've heard of "the accidental DBA", right? Well, I'm the accidental TFS admin. I...
In table tUSERI primary key was added in the column [Email]. I deleted a...
Hi all. I'm in a bit of a quandary with one of our Analysis...
Ask SSC