Avoiding Stored Procedures
This week Steve Jones argues against stored procedures. Is it a good argument or do want to stick with your stored procedures.
2016-08-30 (first published: 2012-08-13)
1,072 reads
Editorials
Separate Accounts
Security is a complex process, one that is becoming more and more important to DBAs all the time. This week Steve Jones wants to know how security is handled for your service accounts.
2016-08-29 (first published: 2012-08-10)
259 reads
SQL Server docks in Linux
The Database Engine on the Data Platform departs for Linux. A late arrival but worthwhile, says Phil Factor.
2016-08-29
60 reads
2016-08-26
79 reads
Better Coding
The Australian Census was a mess, and supposedly some university students build a better version. Steve Jones comments on better coding practices.
2016-08-25
124 reads
The Future for Database Administrators
Today Steve Jones talks about the job changes and prospects for those that manage IT systems.
2016-08-24
203 reads
Security Leaks from Websites
No matter what we do to secure our databases, we need to be sure our applications are well written, both with secure coding, but also good information handling.
2016-08-23
108 reads
Is Rollback Feasible for Database Changes?
Many of us would like to be sure we could rollback changes made during a deployment if they caused issues. Steve Jones notes that it might not be worth actually building those scripts in advance.
2016-08-22
488 reads
2016-08-22
90 reads
What's Your Smoke Test?
A smoke test can be a good way to ensure complex systems are working as expected after maintenance or changes.
2016-08-19
941 reads
Blogs
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...
The PASS Data Community Summit 2025 Recap
By Steve Jones
It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m...
Microsoft Post-Quantum Crypto APIs Are Now Generally Available
By Brian Kelley
I mentioned this in my talk on Quantum Computing at the PASS Data Community...
Forums
The Ending Substring
Comments posted to this topic are about the item The Ending Substring
Done is Better than Good
Comments posted to this topic are about the item Done is Better than Good,...
Configuring the On-Premises Data Gateway: The Fabric Modern Data Platform
Comments posted to this topic are about the item Configuring the On-Premises Data Gateway:...
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