Tell the Judge You Have No Backup
The NYPD is claiming there isn't a backup for one of their databases.
2017-10-23
121 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
95 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
87 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
52 reads
2017-10-13
69 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
287 reads
2017-10-11
63 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
62 reads
2017-10-09
459 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
105 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers