2009-12-17 (first published: 2008-07-13)
1,855 reads
Scripts
Synchronize all stored procedures between two servers
This script will synchronize all stored procedures between two servers, using spSynchStoredProcedure.
2009-12-15 (first published: 2009-11-26)
2,196 reads
2009-12-14 (first published: 2007-10-19)
1,356 reads
Synchronize a stored procedure between two servers
Use this stored procedure to synchronize source code of a stored procedure between two servers.
2009-12-11 (first published: 2009-11-26)
2,008 reads
2009-12-09 (first published: 2009-11-18)
2,075 reads
2009-12-07 (first published: 2009-11-12)
3,089 reads
Generate stored procedure parameter list based on table
Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.
2009-12-04 (first published: 2009-11-10)
2,022 reads
2009-12-02 (first published: 2009-11-11)
874 reads
t-sql first last day date of the month
Returns the First or last day date of the month for a given date.
2009-12-01 (first published: 2009-11-11)
2,861 reads
usp_ShrinkAllLogs
Replacement script for usp_ShrinkDBLogs, updates for SQL 2008 deprecating the WITH TRUNCATE_ONLY method.
2009-11-27 (first published: 2009-10-30)
978 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