Working at home
It’s usually nice, sometimes challenging, always interesting.
The other day both Tia and I were working in the “spare” office when...
2009-02-23
753 reads
Blog Posts
Database Mirroring FAQ: Will the Mirror automatically fail back to the original Principal when it comes back online?
Question: Will the Mirror automatically fail back to the original Principal when it comes back online?
This question doesn't usually come...
2009-02-22
11,483 reads
Mapping Database Principals to Server Principals
A question on the forum asked how to find all the database mappings for a particular login. If you're on SQL...
2009-02-22
9,778 reads
SQLSaturday #13 in Atlanta - Another Update & Shared Knowledge
Stuart says that as of Feb 20 registration is at 150 with a cap of 200, and plenty of speakers...
2009-02-22
671 reads
Looking Forward to Getting My Kindle 2
When the Kindle 2 was first announced, I debated about whether or not to get it. Then I realized I...
2009-02-21
1,369 reads
Adobe Acrobat/Reader 0day - Disable JavaScript
There is an active attack in the wild for the newly announced Adobe Acrobat and Adobe Reader vulnerability. While the...
2009-02-20
2,064 reads
How do I ... Determine Database Growth If I Am Not Tracking It? -- Error Logs Part III
How do I ... Determine Database Growth If I Am Not Tracking It?
If your database has grown considerably and you're not...
2009-02-20
5,965 reads
I Want a Macbook
Video editing is a bit of a pain on a Windows PC I definitely have some flexibility with ULead’s Video...
2009-02-20
996 reads
Want Information on Data Dude, Check Out DBProj.Com
If you use Data Dude (Visual Studio 2008 Team System Database Edition GDR), you might want to check out Gert...
2009-02-20
643 reads
You HAVE to Trust, you MUST Verify -and that may still not be enough!
In Brian Kelly's recent blog post, he makes an excellent case outlining why there are few options but to 'Trust' SQL...
2009-02-20
418 reads
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