Generate Next Numbers with SQL Server
Dinesh ran into a situation where a client had very specific requirements for generating keys. Take a look at the solution, can you better alternatives? Sometimes you just can't talk the client into changing!
How to Make Sure You Have Good Passwords
As Robin points out there is no built in way to make sure users have strong passwords when using SQL authentication. There are a couple changes you can make (with appropriate warnings!) that will allow you to do this. Read on to find out why and how.
Monitoring Failed Job Steps
New Author! We've run a couple articles on similar topics, this one takes a slightly different approach. It's a short article and has two scripts included.
Microsoft Action Pack Subscription
One of the biggest hurdles people new to the IT field face is getting access to all the software they need so they can learn. This new program from Microsoft offers a TON of software for under $400. Caveats apply (don't they always?) but it's worth the 5 minutes to read what it takes.
Review of Lumigent Entegra
We've been trying to catch up on reviews lately, Hai was kind enough to give Entegra a try and report back on it. The basic concept is that it lets you do extensive auditing without having to add triggers. If you're trying to find an auditing solution, this is worth considering.
Regular Expression Library
This isn't a SQL site nor can you easily do regular expressions from SQL. That said, sometimes regular expressions are EXACTLY what you need to solve a problem. The downside? They're tricky! This is a great resource to pass on to your development team.
Typed Data Objects
This is a tool to generate C# code based on a sql script. Source code is also available for download. It's free! One caveat is that the site is in Italian.
Optimizing Your Application - Part 2
This article is for developers (and is in C#), looks at how you can avoid requerying by storing data in a hashtable. Mainly code, but you may get a good idea or two from it.
What is the difference between SET and SELECT?
Both SET and SELECT can be used to assign values to variables. But when to or when not to use SET or SELECT? Or does it matter? This articles shows you how SET and SELECT are different in various scenarios, along with examples. You will also find a test script that you can run, to identify the performance differences between SET and SELECT
SQL Injection - Part 1
Randy says that the biggest reason we have so many injection vulnerabilities is that all the asp books use inline sql for their examples! We STILL encounter developers who don't understand injection. Read and pass on to your dev team.
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Alamat Kantor Bank BCA KCU KEDIRI Telp:08218154393
WA:08218154393 Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
Alamat Kantor Bank BCA KCU MALANG Telp:08218154393
WA:08218154393 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa Timur 65111
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers