One of the finest songs of the sixties had the following lines … "Sitting one day by myself, And I'm thinking, "What could be wrong?" When this funny little Hedgehog comes running up to me, And it starts up to sing me this song. Oh, you know all the words, and you sung all the […]
2020-08-22
338 reads
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)
4,692 reads
2020-06-27
176 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)
684 reads
2020-05-30
174 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
153 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)
3,490 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)
401 reads
By kleegeek
We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...
By Steve Jones
Today’s coping tip is to connect with someone from a different generation. This tip...
By Arun Sirpal
This blog post is not about which User Interface is better, Classic or Snowsight...
Comments posted to this topic are about the item DML Trigger Limits
Comments posted to this topic are about the item A week in Seattle in...
Comments posted to this topic are about the item Being Agile - A Success...
Ask SSC