Connecting to SQL Server with a Bad Logon Trigger
One of the things you need to aware of is that if you create a logon trigger and there is some bad code you are going to prevent everyone from logging into your SQL Server, even if you try as "sa" or a member of the sysadmin fixed server role. How do I log on to my SQL Server to fix this trigger?
The Energizer Bunny
Energizer, one of the world's leading battery manufacturers, is looking to have Microsoft host much of their infrastructure.
The Energizer Bunny
Energizer, one of the world's leading battery manufacturers, is looking to have Microsoft host much of their infrastructure.
The Energizer Bunny
Energizer, one of the world's leading battery manufacturers, is looking to have Microsoft host much of their infrastructure.
Power and Deception of CTEs
A performance problem with a CTE based stored procedure, opened the developers eyes to a whole new world
The Full Potential of SQL 2000
Attending a conference and hearing about all the latest and greatest new features is a bit like spending holiday sampling exotic seafood and imbibing strange new cocktails. When you return, you're decidedly in the mood for a pie and a pint of beer.
The Wild Fringes of SQL Server Development
We can now clearly see two opposing trends in the way SQL Server is being used in applications. The dumb database brigade regards SQL Server as simply a 'data dump'. The 'database fanatics' think SQL Server on its own can meet the needs of all but the most demanding applications. Can these opposing trends be reconciled? Tony Davis would like to think so.
Configuring Transport Encryption in SQL Server 2005 Express Service Broker Conversation
In the recent installments of our "SQL Server 2005 Express Edition" series we have been discussing mechanisms that facilitate authentication of distributed systems participating in Service Broker conversations. This article discusses use of digital certificates in encrypting their content on the transport level.
Blogs
Stupid Things I Did With AI: ASCII Art
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
Simple Talks Podcasting in 2026
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
SSMS 22 still inserting tabs instead of spaces
I’m not trying to start up a debate whether you should use tabs or...
Forums
Cumulative Update 23 - KB5074819 - Database Mail - No longer working.
Hi there, Has anyone else had any trouble with Database Mail in Cumulative Update...
Script Task execution error with HTTP request
I have a script task that tries to execute a HTTP request, which seems...
SQL Server 2025 Standard Developer Edition
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
Question of the Day
URL Safe or Not?
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers