QA Lite - .Net Version of Query Analyzer
A free product from RAC4SQL, if you need something a little different maybe this will help. (Note: We're looking for a review of this, if you're using it drop us a note)
Asynchrous Execution with C#
Definitely not a beginner article, this one describes how to asynchronous execution using delegates in C# (C Sharp). Async is usually harder to implement - conceptually at least - but offers benefits in that the user/application isn't blocked while you wait on results.
Permissions on System Tables Granted to Logins Due to the Public Role
Many of you know that Brian Kelley is our resident security guy. If you didn't, this might prove it! There is a ton of information in this 63 page document worth reading. Let us know what you think.
Getting Ready to Replicate
We've asked Andy to put together some articles that tackle replication from a beginner perspective, a tutorial type approach PLUS comments on what you should or should not do. This week he covers the steps needed to set up a server for replication. More images than usual so the page may take a little longer to load, but we think worthwhile so that you can see every step along the way. Let us know what you think.
Debugging MSDTC Issues
For the most part the DTC (Distributed Transaction Coordinator) just works. What happens when it doesn't? Chris had to resolve an issue with it recently and documented some of the steps he used.
Auditing Through Triggers
In this article by Robert Marda, he shows you how to setup a simple auditing system through triggers.
Review of SQL Compare v3
Regular columnist Robert Marda had some extra time so we got him to take a look at the latest upgrade to SQL Compare - for those of you aren't familiar with it, it is a tool that will let you compare two databases to see the differences, then optionally sync one to the other.
Building a Demo Server
Everyone does demos. Selling software relies upon people viewing your software in action and being confident it will work. Managing a demo server can be a challenge and this series will look at different problems and options you have.
Sending Alerts Via a Custom SMTP procedure
SQL Mail comes with SQL, but you have to load Outlook to use it. The alternative is to send email directly via SMTP. Combine that idea with alerts and you've got a new article!
SQL Server Statistical Functions
I bet most of us count and sum fairly often, but how often do you use the rest of the 'in the box' statistical functions? Learn these now and be ready when you need them.
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers