So, in general, what information (Scripts, configuration information, lists and documents) ought DBAs to retain about the databases and servers they are responsible for?
2018-05-31 (first published: 2014-11-10)
202 reads
In this second level of the Stairway, Phil looks at where we go to find information about objects, using triggers as the example.
2018-05-30 (first published: 2016-09-07)
3,144 reads
In this first level, we look at the overview of what metadata is contained in each database, gain some understanding of the different types of information, and examine a few basic examples.
2018-05-09 (first published: 2016-08-03)
6,168 reads
Phil Factor on a journey that started with a decision to introduce a new IT platform, and ended in a disaster that left TSB customers locked out of their accounts, experiencing problems such as zero balances, incorrect currencies, and massively inflated mortgage amounts.
2018-05-07
312 reads
Phil Factor argues that the ability to write simply and expressively is a much under-valued skill in IT, and explains the main traps to avoid.
2018-04-09
115 reads
Building a name-and-address database sounds a disarmingly simple task, but if your name happens to be D'Arcy Join, then you probably know, from painful experience, that most programmers don't get it right.
2018-03-12
336 reads
Sometimes a database can seem to be as willful as a colt. Taming it requires an iron nerve, and unflinching eye contact. Occasionally though, you need to know when to jump the fence and regroup.
2018-02-12
77 reads
Phil Factor on a tale of how dodgy mock data derailed an otherwise-convincing prototype.
2018-01-15
203 reads
After many barren years, Phil Factor is pleased to see the first signs of Spring in SSMS.
2017-12-04
91 reads
Databases, like sheep, get get into some surprising scrapes. However, as long as you've planned for all the common mishaps, your conscience should be clear to take a well-earned holiday.
2017-11-27
73 reads
Say you need outside help. You’ve exhausted all the things that you could do...
I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...
By Arun Sirpal
Until now, a CRITICAL finding did the right internal routing, but the last mile...
WA:08218154393 Citraland, Gateway Junction, Jl. Ruko No.1&2 Blok TL06, Lidah Kulon, Kec. Lakarsantri, Surabaya,...
WA:08218154393 Jl. Raya Prapen No.38, Sidosermo, Kec. Wonocolo, Surabaya, Jawa Timur 60299
I installed a new SQL server 2025 Enterprise developer edition for our development environment....
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers