myLittleAdmin for MS SQL Server 2005
A short review from the perspective of a web hoster on this handy software utility.
SQL Server Script to Create Windows Directories
An interesting script to handle file tasks from within SQL Server.
Lesson Learned from Contracting, Revisited
A few notes from a consulting engagement that might get you to think about what to expect from your next contractors.
Designing Tables for Audit Data in SQL Server
My company is just starting to look at adding functionality to retain historical data for key tables and columns for auditing purposes in many of our SQL Server databases. I have seen some of your recent tips related to triggers (Forcing Trigger Firing Order in SQL Server and Trigger Alternatives in SQL Server - OUTPUT Clause). Based on using triggers or a similar technology, what is the best way to store the historical data?
Giving Permissions through Stored Procedures
QL 2005 adds two new methods – signing with certificates and impersonation with EXECUTE AS – that can manage cases where the classic method of ownership chaining fails. I explain the two new methods, as well as the old one, and warns you about the pitfalls.
Sun Invests, IBM Invests, MS ??
The other major database vendors have been making investments by purchasing database related companies, but what has Microsoft done?
Sun Invests, IBM Invests, MS ??
The other major database vendors have been making investments by purchasing database related companies, but what has Microsoft done?
Sun Invests, IBM Invests, MS ??
The other major database vendors have been making investments by purchasing database related companies, but what has Microsoft done?
Behind the Curtain
Commentary on the database related news of the past week. SQL Server 2008 Certification, deep inside SQL Server and the Library of Congress.
Bloated
What is going on with all this production data? Steve Jones talks about the need to manage data growth and is it really worth the resources.
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers