A roadmap of Microsoft SQL Server certifications to help you pick the right exam and prove your skills in a tough job market. Download the full article.
SQL SERVER – Add or Remove Identity Property on Column
There is no direct T-SQL to add or remove the identity property on an existing column. Imran Mohammed shows how SSMS does it and what happens behind it.
SQL SERVER – Example of DDL, DML, DCL and TCL Commands
Simple examples of DDL, DML, DCL and TCL commands: SELECT, INSERT, CREATE, ALTER, GRANT, REVOKE, COMMIT, ROLLBACK and what each one does.
SQLAuthority News – Gandhinagar SQL Server User Group Meeting April 24, 2009 – Meeting Report
About 50 people came to the Gandhinagar SQL Server User Group Meeting on April 24, 2009 for query optimization tricks and my back to basics talk.
SQL SERVER – FIX : ERROR : is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)
The error not a valid Win32 application (0x800700C1) comes from .NET on IIS7, not SQL Server. Enable 32-Bit Applications in the app pool to fix it.
SQL SERVER – Solution to Puzzle – Shortest Code to Perform SSN Validation
My solution to Jacob Sebastian’s puzzle: the shortest T-SQL code for SSN validation that removes invalid SSN values and returns only the valid ones.
SQL SERVER – Introduction to SQL Server Encryption and Symmetric Key Encryption Tutorial with Script
SQL Server Encryption keeps stolen data unreadable. Learn the three level encryption hierarchy, then follow a symmetric key encryption tutorial with the script.