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?
2008-12-02
3,887 reads
Energizer, one of the world's leading battery manufacturers, is looking to have Microsoft host much of their infrastructure.
2008-12-02
538 reads
Energizer, one of the world's leading battery manufacturers, is looking to have Microsoft host much of their infrastructure.
2008-12-02
508 reads
Energizer, one of the world's leading battery manufacturers, is looking to have Microsoft host much of their infrastructure.
2008-12-02
778 reads
A performance problem with a CTE based stored procedure, opened the developers eyes to a whole new world
2008-12-01
9,171 reads
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.
2008-12-01
2,512 reads
Given the fundamental importance of indexes in databases, it always comes as a surprise how often the proper design of indexes is neglected. It often turns out that the programmer understands detail, but not the broad picture of what indexes do. Bob Sheldon comes to the rescue with a simple guide that serves either to remind or educate us all!
2008-12-01
6,724 reads
2008-12-01
980 reads
2008-12-01
136 reads
2008-12-01
927 reads
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
WA CS (08218154392) Jl. Diponegoro No.68, Palraman, Dawuhan, Kec. Situbondo, Kabupaten Situbondo, Jawa Timur...
WA CS (08218154392) Jl. Dr. Setiabudi No.146, Hegarmanah, Kec. Cidadap, Kota Bandung, Jawa Barat...
Hub Via Wa:62817825533 Alamat: Jl. K.H. Wahid Hasyim No.183 A-B, RT.14/RW.6, Kb. Kacang, Kecamatan...
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers