How do I .... grant access permissions for SSIS to users?
SSIS access permissions are managed via Component Services. It is the DCOM object named MSDTSServer. Here are the steps to...
2008-08-13
46,008 reads
2008-08-13
1,093 reads
DBA's Need (and Deserve!) a Large Monitor, and Preferably Two of Them
With all the options we have for viewing query plans I still prefer the graphical view. Combined with tooltips and...
2008-08-12
525 reads
Installing RTM (SQL Server 2008)
I had to install the RTM version of SQL Server 2008 a few days ago since I'm tech reviewing a...
2008-08-12
746 reads
Argentina Code Camp
My friend Jonas Stawski just sent me a note about the upcoming Code Camp in Argentina on October 24, 2008....
2008-08-11
603 reads
Minutes of the Aug 2008 oPASS Meeting
I've just posted minutes of the August 2008 user group meeting. We had two great presentations, a short one from...
2008-08-10
692 reads
SSWUG SQL Server Virtual Conference III
There are many technical conferences available for SQL Server professionals, such as PASS. I have been lucky enough to go...
2008-08-10
1,036 reads
Changing jobs -- Pros and Cons
I read Andy's post Changing Jobs - Should You? today with great interest. I think it is good topic in the...
2008-08-08
1,310 reads
Changing Jobs - Should You?
I think most people fall into two groups, the ones that change jobs every year/every time they can make another...
2008-08-07
572 reads
SQL Server 2008 RTM - Community Thoughts & Resources
As has widely been announced in the SQL Server community, SQL Server 2008 has RTM'ed. It's now available for download...
2008-08-07
907 reads
Blogs
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Forums
ALAMAT KONTAK BCA KCP Alaydrus Telp:08218154392
WA CS (08218154392) Jl. Alaydrus No.47 & 47 A, RT.8/RW.2, Petojo Utara, Kecamatan Gambir,...
ALAMAT BCA KCU RAWAMANGUN Telp:08218154392
WA CS (08218154392) Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur,...
Alamat Kantor BCA KCU City Tower Telp:08218200233
Wa:628218200233 Alamat. Jl. M.H. Thamrin No.81 Ground Floor, RT.1/RW.6, Dukuh Atas, Menteng, Kec. Menteng,...
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