SQL Server Security: Login Weaknesses
Brian writes regularly for us on sql security issues, this week he discusses the pros and cons of various authentication methods.
Script your Data in T-SQL format
SQL Scripter is a tool for SQL Server 7.0/2000 database administrators and developers to script data in a valid T-SQL format which can be executed in Query Analyzer. All types are supported (INSERT, UPDATE, DELETE). It's free in the moment. (Not Reviewed)
Cluster That Index! Part Two
Chris discusses questions raised by his first article on clustered indexes. Few subjects more important to master than clustered indexes, this is good reading!
Red Earth Technologies releases Superior SQL Builder
Red Earth Technologies announces the release of Superior SQL Builder, a new SQL tool that visually builds complete SQL scripts, not just single queries. It employs a completely different method of developing SQL scripts. By taking advantage of new scripting technology, Superior SQL Builder can visually build complete SQL scripts within a single, integrated environment. This means that SQL scripts can be developed faster, while reducing syntax and logic errors. (Not Reviewed)
Where Do I Want To Go Today? - Real Time Defragging
Where should SQL Server go in the future? What enhancements are needed? Steve Jones continues to explore his wish list for future versions of SQL Server.
Log Navigator Final Beta Released
The final beta of Log Navigator has been released. This sql server auditing tool reads the MS SQL Server transaction log to track all data changes with no performance overhead or use of triggers. You can read database auditing trails from activity that took place even before the tool was installed. Powerful filters allow you to sort audit data by date, user, table and more. New features include LIVE LOG support and XML export. (Not Reviewed)
Altering Replicated Tables (SQL 2000)
Changing a replicated table in SQL 7 was a lot of work. SQL 2000 offers some help, but in many cases it's not enough. This article by Andy Warren shows you which changes SQL 2000 will help you with and which ones it won't.
AutoCode - Beta Release of SQL Editor
The authors of the application are offering a 30% discount off of the release price to those that participate in the beta cycle. Feature list includes autocomplete, db comparison and reconciling, and point/click constraint generation. (Not reviewed)
Using Built in Functions in User Defined Functions
This short article shows an interesting technique for using the SQL built in functions inside a user defined function (UDF).
Review of Murachs SQL for SQL Server
Andy rates this one 4.5 out of 5 stars and likes it enough to recommend it's use at work. This is a book that should teach a developer how to use the key abilities of SQL. If you're looking for a book to guide your beginning/intermediate developers, this might be it.
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
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...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers