Tampa Code Camp 2007
Web site just went live for this year. Brian & I both presented sessions last year and we're planning to go...
2007-06-12
1,345 reads
Mirrored Backups Posted on SSC
This was fun to run through, nice to see MS adding features even if in my view they didn't quite...
2007-06-12
1,329 reads
June Midlands PASS Meeting Canceled
We are canceling the June Midlands PASS meeting because the speaker (me) is still under the weather. I'll post in...
2007-06-07
1,302 reads
Katmai Manageability
The database manages itself. Not totally, but close to it. It was an
analogy made by Dan Jones with cars. Auto...
2007-06-06
1,351 reads
SQL Server 2005 Security
It's a similar theme, off by default if it makes sense, minimize surface area.
Recommendations: for new installs, leave stuff off...
2007-06-06
1,472 reads
Southern BBQ
Last night I went out with Tony Davis of Simple Talk and Alan White, a
longtime author for both here and...
2007-06-06
1,401 reads
DBCC Internals
CHECKDB
- needs consistent view of the db. Needs to do this without locking. In
SQL Server 2000 log analysis is used....
2007-06-05
1,859 reads
Beyond Relational
I missed this yesterday, but I saw it on the schedule again, and I knew
I had to make this one....
2007-06-05
2,013 reads
Maintenance in SS2K5
Andrew Kelley from Solid Quality Learning did this one, which was good.
I was worried it would be about maintenance plans,...
2007-06-05
1,564 reads
SQL Server Always On
Everyone wants 5 9's of uptime, 24x7 support, and instant fixes for
issues with their database server. Never mind that I'd...
2007-06-05
2,190 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Alamat Kantor BCA KCU Suryopranoto Telp:08218154374
Hub Via Wa:628218154374 Alamat: Jl. Suryopranoto No.40, RT.12/RW.7, Petojo Utara, Kecamatan Gambir, Kota Jakarta...
Alamat BCA KCU Pangeran Jayakarta Telp:08218154374
Hub Via Wa:628218154374 Alamat: Jl. P Jayakarta Komp. No.127, RT.7/RW.7, Mangga Dua Sel., Kecamatan...
Alamat Kantor BCA KCU Mangga Dua Raya Telp:08218154374
Hub Via Wa:628218154374 Alamat: Jl. Mangga Dua Raya Jalan Kavling No.1 Blok C-5, RT.11/RW.5,...
Question of the Day
Symmetric Key Encryption
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers