-
SQL Administration
- List Phsical File Size for SQL Databases
- Shrink SQL Server Database Log File Size
- Move SQL Database File
- SQL Update Statistics
- SQL Database Principal
- Monitoring SQL processes
- Scripts to drop all SQL tables
- Backup SQL Databases
- Backup SQL Databases by Creating SQL Server Maintenance Plan
- Restore SQL Databases
- List Record Count for SQL Tables
- List Data Size for SQL Tables
- SQL Index Performance
- SQL Information Schema
- Scripts to list all SQL tables and their extended properties
- How to search sql server database for string?
- Database comparison tool
- SQL Server Log Shipping
- Get List of Linked Servers and associated logins
-
SQL Security
-
SQL
- SQL Questions and Answers
- Encrypt/Decrypt Data with Passphrase
- SQL Cursor
- SQL Identity
- Find index of the last occurrence of a substring using T-SQL
- SQL Case Sensitive String Compare
- How to count # of occurrences of a character inside a string using SQL query?
- Search for a string in all tables of SQL Server Database
- SQl Procedure to script data - sp_generate_inserts
- SQL update with correlated subquery
- Convert an adjacency list model into a nested set model
- Using Common Table Expression to traverse the adjacency List (parent / child) Model
- SQL Table Variables
- Convert String to Title Case
- Split a delimited string of ID into table rows
- Split a long text into table rows
- SET vs. SELECT When Assigning Variables
- Insert results of a stored procedure into a temporary table
-
SQL Server Integration Services