SQL Injection Is Not Acceptable
An alert from the US government says that SQL Injection isn't an acceptable problem.
2024-06-19
310 reads
Secure Programming
Securing Code Early
Last year I started to get alerts from Microsoft Repos that someone had put a piece of security information in their code that pertained to one of my Azure services. At first I was worried, but then I realized this was the public version of AdventureWorks we maintain in Azure. We've published the login so […]
2019-04-17
200 reads
Best Practices for Credit-Card Software
Visa has developed Payment Applications Best Practices and will begin implementing mandates concerning them
2007-12-07
3,551 reads
Blogs
Speaking at the 2025 PASS Data Community Summit
By Brian Kelley
I will be back in Seattle this year attending the 2025 PASS Data Community...
The Book of Redgate: Motivation
By Steve Jones
Another of our values is this: Motivation isn’t about carrots and sticks. Constant oversight...
A Six Week Break
By Steve Jones
Today is my last day of work for six weeks. I start my sabbatical...
Forums
Three Times a Day
Comments posted to this topic are about the item Three Times a Day
SUM([value]) and highest record type
Given a record mapping table: Id Initial Updated 1 1 2 2 3 4...
should i expect data types in task->export data from ssms?
Hi i recently exported a number of "to be purged resultsets " to .tsv's. ...
Question of the Day
Multiple Defaults
In my SQL Server 2022 database, I run this code:
ALTER TABLE dbo.OrderHeader ADD ModifiedStamp DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOI decide I need to add auditing to another table and run this:
ALTER TABLE dbo.Tracker ADD Created DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOWhat happens with these statements? See possible answers