2011-12-01 (first published: 2011-11-09)
1,282 reads
Scripts
LEFT equivalent in SSIS Derived Column Task
This command is the equivalent of the LEFT() function (cumbersome but effective)
2011-11-29 (first published: 2011-11-14)
1,182 reads
Generate alter datatype script for entire database
ntext, text, and image (Transact-SQL). This script will alter the data type from image to
varbinary(max) which is very much required as the data type is out
of support.
2011-11-28 (first published: 2011-11-14)
876 reads
Generate Job Schedule Descriptions
A SELECT statement which includes the alpha description of each job's schedule
2011-11-25 (first published: 2007-11-01)
4,564 reads
Create a Tally or Numbers Table
This creates a Tally or Numbers table which is frequently used to replace loops in code and is much faster than most loops.
2011-11-24 (first published: 2008-03-07)
6,702 reads
Script Generates Audit Triggers
This script generates a audit trigger for each table in the database. The trigger then logs when each table is updated.
2011-11-23 (first published: 2008-05-09)
4,795 reads
2011-11-22 (first published: 2008-03-19)
5,887 reads
Extract More Than 1000 Active Directory Accounts
This is a simple method to load a SQL database with active directory account information without running into the 1000 record limit. You will need to change the SERVERNAME, PORT, DATABASENAME, USERID, AND PASSWORD values in the connection strings to your own values. You will also need to change the LDAP connection string values ('LDAP://SERVERNAME/ou=OUName,dc=host,dc=domain,dc=tld') […]
2011-11-21 (first published: 2007-08-01)
2,825 reads
2011-11-18 (first published: 2008-01-29)
2,910 reads
Server Up-Time Information
Calculates server uptime in days, hours, and minutes. Also calculates the UTC date (smalldatetime) when the server was started.
2011-11-17 (first published: 2007-08-31)
2,446 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 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,...
Alamat Kantor BCA KCU Menara Bca Telp:08218200233
Wa:628218200233 Alamat. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1 Lt. 28, RT.1/RW.5, 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