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.
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.
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
Comments posted to this topic are about the item Lots of FKs
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Comments posted to this topic are about the item Can You Let Go of...
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers