Before Asking for Help...
I have a standard rule that I use before going and bugging a co-worker or posting via social media/message forum about...
2013-08-29
1,872 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Specify the Parameter Names for Stored Procedures
I just ran across a case where a script was failing. Here's the part that's failing:
EXEC sp_addrolemember 'MyDomain\MyGroup', 'SomeRole';
GO
Do...
2013-08-27 (first published: 2013-08-23)
4,484 reads
Schneier's Thoughts on the Future of IT Security and the Impact of the Internet on Power
If you've got an hour to spare, you might want to check out this presentation by Bruce Schneier where he...
2013-08-23 (first published: 2013-08-15)
1,666 reads
Boorish Behavior? No, Worse. Death Threats Against Developers/Designers.
I know DBAs and developers have a rocky relationship. However, I don't believe we go as far as some of...
2013-08-16
831 reads
Windows Phone Security Advisory - Weakness in Security Protocol
If you're using a Windows phone, versions 7.8 or 8, there is a new security advisory out with respect to...
2013-08-06
615 reads
More on SQL Server Built-In Cryptography Options
I wrote a series of articles at MSSQLTips.com to cover the cryptographic algorithms that are available with Microsoft SQL Server....
2013-08-02
857 reads
Thank you, Mr. Solomon
On one of the newsgroups I follow, I received a message that David Solomon will no longer be teaching seminars...
2013-07-30
1,402 reads
Audio and slides are up for my webinar on SQL Server encryption
The webinar audio and slides/demo scripts are up for the presentation I did for the PASS Security virtual chapter.
PASS Security...
2013-07-19
751 reads
Presenting for the new PASS Security Virtual Chapter on July 18
The PASS Security virtual chapter is up and running thanks to the hard work of Argenis Fernandez (blog | twitter) and...
2013-07-17
1,269 reads
Dealing with Auditors: Password Settings
Yet again I've seen an audit request where the auditor wants the DBA to show what SQL Server's settings are...
2013-06-19
8,212 reads
Blogs
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Questions and Answers from Running a Local LLM
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers