The Cloud is Better In At Least One Way
Azure SQL Database has a lot of integrity checks. Probably more than your local instance.
2017-10-16
48 reads
Editorials
Timing is Everything
Phil Factor on the wise habit of timing your database routines, to avoid relying on received wisdom about performance.
2017-10-16
86 reads
2017-10-13
67 reads
The Blame Game
Equifax is blaming a single IT person for their data breach. Steve Jones worries this is a sign of things to come.
2017-10-12
283 reads
2017-10-11
61 reads
Citizen Scientists
More and more people are becoming citizen scientists, even in companies. Steve Jones thinks this is helpful, but we still need professionals.
2017-10-10
59 reads
2017-10-09
453 reads
The Achilles Heel
In a long career in IT, Phil Factor cannot recall a 'major incident', where the failure or breach was due to a single 'Achilles Heel', or even a single team of people. They are always due to a whole plethora of slack and ignorant practices.
2017-10-09
102 reads
Why Don't You Unit Test Code?
This Friday Steve Jones wants to know what you think of testing code and why you don't do it.
2017-10-06
68 reads
Teaching Quickly
Steve Jones talks about learning, teaching, and the need to not waste anyone's time.
2017-10-05
65 reads
Blogs
Dry-run xp_delete_file Before Actually Deleting Files?
By SQLPals
Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...
Happy Thanksgiving! (USA Holiday)
By Brian Kelley
In the United States, today is Thanksgiving. The intent behind the holiday is to...
Getting SQL Server 2025 RTM Running in Containers on macOS
SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you...
Forums
Cannot execute SQL cursor in Azure Query Editor (Preview)
Apologies if this is posted in the wrong forum, but I am trying to...
SQl Server 2014 linked server remote server
Hello all, I have a linked server created on an instance which only has...
Find all the tables in a database containing particular column value
Hi, I want to find all the tables name under a database where tables...
Question of the Day
The Ending Substring
In Azure SQL Database and SQL Server 2025, if I run this, what is returned?
SELECT '[' + SUBSTRING('Steve Jones', 7) + ']' See possible answers