Do we take security too far? Are we creating unnecessary rules for those that need to use the resources we support? Steve Jones talks today about security and how we might want to approach it when handling rights for developers.
Do we take security too far? Are we creating unnecessary rules for those that need to use the resources we support? Steve Jones talks today about security and how we might want to approach it when handling rights for developers.
Do we take security too far? Are we creating unnecessary rules for those that need to use the resources we support? Steve Jones talks today about security and how we might want to approach it when handling rights for developers.
A colleague pointed out a site that collects a lot of job posting data and exposes graphs - so I've taken...
Longtime SQL Server expert David Poole brings us a look at Agile Development and how he's been converted. (From Feb 2008)
Working with passwords that provide enough security and are hard to crack is complicated enough. Most users want to simplify their lives with fewer passwords if possible. This Friday Steve Jones asks how you handle passwords across systems.
I’ve been on the board just about 8-1/2 months, so I’m not doing too bad on updates, but think I’ll...
Python is increasingly used by DBAs as a general-purpose scripting language, despite the pressure to adopt Microsoft's PowerShell. They find it easy to learn, powerful, and reasonably intuitive. Here Timothy Wiseman, a working DBA, explains the attraction of Python and gives a general introduction to the language, suitable for anyone who has been wondering whether to give it a try.
Working with passwords that provide enough security and are hard to crack is complicated enough. Most users want to simplify their lives with fewer passwords if possible. This Friday Steve Jones asks how you handle passwords across systems.
Working with passwords that provide enough security and are hard to crack is complicated enough. Most users want to simplify their lives with fewer passwords if possible. This Friday Steve Jones asks how you handle passwords across systems.
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
By gbargsley
One of the first things I review when I inherit a new SQL Server...
I have an issue where I have a Bill of Material list of items...
Comments posted to this topic are about the item Follow Your Hunch
Comments posted to this topic are about the item What Happens When You Ask...
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers