As Jeff says, "There are lots of articles about how to do auditing, but there are few discussions about how to use the auditing results in a real time environment". Well, now we have one that shows you how to do it!
Nice write up on the Admin Companion. Should you add it to your bookshelf? Frank offers his frank opinion.
Continuing Steve Jones' series on string manipulation in T-SQL, this article examines how quotations are handled in T-SQL.
It's not often you'll need to access the registry from SQL, but when you do - these functions make it happen!
A week ago, we solicited readers to let Microsoft know which of the SQL Server 2005 announced features mattered most to them. We had a great response, with 890 of you answering the survey in three days. The answers were pretty interesting. The full results can be seen at the bottom of this article.
Some good info on password changes in Yukon (SQL 2005). Based on the beta, but worth taking a look at.
Dinesh did a little research on nulls and was kind enough to package it up for us. How many of you know or use NULLIF? Or COALESCE? Handy stuff!
We saw a note from Chad about a tool he wrote in the forums and asked him to write up some notes. Not only did we get notes, we got the source code! See what a DBA can do with some DMO.
We get books in occasionally for review and have started making them available to our existing authors. Jim was interested in this one - turns out he didn't find much to like. If you're a beginner it might be a better fit. Or maybe you've read the book and disagree?
A very short article that discusses how nulls can ruin your day if you don't understand how they behave when you concatenate.
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
The post When is the perfect moment to build a data strategy in a...
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
I have a table dbo.tblPresentationStatus (sql script attached - table script.txt) I have to...
We are planning to migrate our on-premises SQL Server to an AWS PostgreSQL database...
Comments posted to this topic are about the item Learn Microsoft Fabric: A practical...
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers