MSSQL Extended Stored Procedures

Extended stored procedures can be built to perform functionality not possible with Transact-SQL stored procedures. Extended stored procedures can, however, compromise the integrity of the SQL Server process, while managed code that is verified to be type-safe cannot. Further, memory management, scheduling of threads and fibers, and synchronization services are more deeply integrated between the managed code of …

Continue reading "MSSQL Extended Stored Procedures"

MSSQL CLR Integration and .NET with SQL

The common language runtime (CLR) is the heart of the Microsoft .NET Framework and provides the execution environment for all .NET Framework code. Code that runs within the CLR is referred to as managed code. The CLR provides various functions and services required for program execution, including just-in-time (JIT) compilation, allocating and managing memory, enforcing type safety, exception …

Continue reading "MSSQL CLR Integration and .NET with SQL"

MSSQL PowerShell

PowerShell is a relatively new interactive shell and scripting tool from Microsoft that combines the capabilities of the MS-DOS Command Prompt, batch files, Windows Scripting Host and even the popular Unix shells. Windows PowerShell is an extensible command-line shell and associated scripting language built on top of the .NET Framework v2.0. PowerShell includes an impressive array of commands …

Continue reading "MSSQL PowerShell"

MSSQL DBCC- Database Console Commands

DBCC: Microsoft SQL Server Database Console Commands (DBCC) are used for checking database integrity, performing maintenance operations on databases, tables, indexes, and filegroups, and collecting and displaying information during troubleshooting issues. .The first DBCC command to become familiar with is the DBCC HELP command, which returns the syntax and all the options for any DBCC command. The …

Continue reading "MSSQL DBCC- Database Console Commands"

MSSQL Phantom Read

Data getting changed in current transaction by other transactions is called Phantom Reads. New rows can be added by other transactions, so you get different number of rows by firing same query in current transaction. In REPEATABLE READ isolation levels Shared locks are acquired. This prevents data modification when other transaction is reading the rows and also …

Continue reading "MSSQL Phantom Read"