Passing Values into an SSIS Package at Runtime from Outside the Package
SSIS provide several methods for passing values into your packages at runtime.The benefit of doing so allows you to change...
2011-03-14
34,689 reads
Blog Posts
Restore and Relocate Database Files Using PowerShell
I was recently asked a question on restoring a database using PowerShell with the following requirements
Take a database backup file...
2011-03-14
8,017 reads
SQLPeople: An Interview With Andy Leonard
The thing that I most enjoy about going to conferences, SQLSaturdays, and user group meetings is the people I get to meet or see there. That’s why I was intrigued...
2011-03-14
15 reads
SQLPeople: An Interview With Andy Leonard
The thing that I most enjoy about going to conferences, SQLSaturdays, and user group meetings is the people I get...
2011-03-14
1,689 reads
SSRS: Shared DataSet, Not So Shared!!!
I was really excited about the concept of Shared DataSets when they were introduced. My excitement diminished a little when...
2011-03-14
5,725 reads
Stored Procedure Definitions and Permissions
I wrote a post a while back that showed how you can grant execute permission ‘carte blanche’ for a database...
2011-03-14
2,792 reads
The Lighter Side of Technical Interview Questions
I hate those puzzle type interview questions. I am sure that they show some level of aptitude about something, but...
2011-03-14
1,018 reads
March PASSMN Meeting This Week
I mentioned the PASSMN meeting last week and thought a reminder might be worthwhile. Just in case you head has...
2011-03-13
592 reads
SQLPSX 2.3.2.1 Release
We’ve released a minor update to SQLPSX which includes includes several bug fixes/enhancements as well as one new module. Here’s...
2011-03-13
1,040 reads
Do you know SqlServer ? Do you want an iPad ?
If you’ve answered yes to both of those questions , Jacob Sebastian has some more question for you.
Every day in March...
2011-03-12
541 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 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,...
Alamat Kantor BCA KCU Matraman Telp:08218200233
Wa:628218200233 Alamat. Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta Timur,...
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