Tell the Judge You Have No Backup
The NYPD is claiming there isn't a backup for one of their databases.
2017-10-23
117 reads
Editorial
Don’t Underestimate the Importance of Good Co-workers
It is important to have people that do good work and are good to work with.
2017-10-17
90 reads
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
85 reads
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
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
282 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
56 reads
2017-10-09
452 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
101 reads
Blogs
Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
The Book of Redgate: Don’t be an a**hole
By Steve Jones
This was one of the original values: The facing page has this text: No...
Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
I Love Editorials
Comments posted to this topic are about the item I Love Editorials
Line number in error message doesn't match up with line number in code
Hi everyone I have a 1000 plus line query and I am getting an...
Question of the Day
A Common Split
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers