What You Don't Know
A very short article that discusses how nulls can ruin your day if you don't understand how they behave when you concatenate.
A very short article that discusses how nulls can ruin your day if you don't understand how they behave when you concatenate.
We had Mike take a look at this product recently and he found a lot to like. He also had some suggestions about ways the product could be improved - interesting since you get free upgrades for life with this product. This is a very good walk through of the product.
Microsoft confirmed today that it has delayed Yukon yet again. It also announced that Yukon has an official name and will have another beta added to the development cycle. Get all the info here and share with Microsoft your thoughts about what features are important to you.
Regular columnist Chris Hedgate follow up on Andy's recent article about Worst Practices with one of his own. This is worth passing on to your development team.
Mike takes a good first look at Reporting Services. We're trying to add some coverage of this interesting new product. This gives a good overview from a real user perspective.
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!
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.
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.
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.
By Steve Jones
I was experimenting with a local model (article) and as a part of this,...
By Steve Jones
Redgate Monitor has grown tremendously from its early days and I find many customers...
The post Data Governance: The Invisible AI Accelerator appeared first on Joyful Craftsmen.
SQL Server 2022 16.0.4165.4 Windows Server 2022 Datacenter 21H2 20348.2849 Our Extended Stored Procedure...
We have a publication with three subscribers; it's basically a part list with around...
Hi Experts, I have database about 300GB in size with ADR enabled but after...
What types of database operations does the Data API Builder support?
See possible answers