Detecting SQL code smells using code analysis
Watch out, watch out, there's a NOLOCK hint about. And probably a few other SQL code smells.
2018-07-02
321 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
One law for me, another for EU
Phil Factor notes that the EU's approach to the GDPR seems to be "do as I say, not as I do".
2018-06-04
50 reads
An Unlikely Taste for Documentation and Archiving
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)
193 reads
The Technology Journey to Disaster
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
285 reads
Stumbling over Words
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
100 reads
Troublesome Names
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
283 reads
Database Taming
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
66 reads
Data-driven Prototypes
Phil Factor on a tale of how dodgy mock data derailed an otherwise-convincing prototype.
2018-01-15
188 reads
The Appearance of the Flat File Wizard.
After many barren years, Phil Factor is pleased to see the first signs of Spring in SSMS.
2017-12-04
83 reads
A well-earned break from the database
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
58 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers