The Video World
I wonder what you think of this: video shorts. I've gottne the Lockergnome newsletters for years and they've proven interesting...
2007-07-06
608 reads
Midlands PASS Chapter July Meeting with SQL Server MVP Wayne Snyder
SQL Server MVP Wayne Snyder Speaks on SQL Server Integration Services (SSIS)
Midlands PASS Chapter - July 12, 2007 Meeting
Sponsored by...
2007-07-06
783 reads
Cursors to Increase Performance?
I recently had the chance to look over a friends shoulder at a query that needed some tuning work. In...
2007-07-06
730 reads
Blogs
One of the suggestions I saw today was to add blogs to the user profile on the site and not...
2007-07-05
655 reads
70-444 Exam Prep Book
I just got my author copies of the Sybex book for exam 70-444 and have to say the book looks...
2007-07-05
743 reads
The Journey to Katmai
I wrote an article recently on the Journey To Katmai, looking at some of the new features that are coming...
2007-07-04
672 reads
Who said that breaking up is hard to do?
Some of you younger DBA’s out there may not know who Neil Sedaka is or remember his poignant words "Breaking...
2007-07-03
617 reads
Working Remotely
Most people I know tend to work in one of two places consistently: work or home. So they've built a...
2007-07-03
570 reads
Breaking Up is Easy to Do
Breaking Up is Easy to DoHardIt's nice to be able to package a process into a single, tidy, elegant query,...
2007-07-03
603 reads
Earthquake
This is pretty cool, a, earthquake test for Project Black Box from Sun. They take one of their systems to...
2007-07-01
633 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