June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Recovery Models and Selection

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Backup and Restore, SQL Coding Standards, SQL Data Storage, SQL Scripts, SQL Server Security
SQL Server offers three recovery models: full recovery, simple recovery and bulk-logged recovery. The recovery models determine how much data loss is acceptable and determines whether and how transaction logs can be backed up. Select Simple Recovery Model if: * Your data is not critical. * Losing all transactions since…
Read More

SQL SERVER – Top 15 free SQL Injection Scanners – Link to Security Hacks

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Download, SQL Server Security
SQL injection is a technique for exploiting web applications that use client-supplied data in SQL queries, but without first stripping potentially harmful characters. Checking for SQL Injection vulnerabilities involves auditing your web applications and the best way to do it is by using automated SQL Injection Scanners. Security-Hacks.com compiled a…
Read More

SQL SERVER – 2005 Understanding Trigger Recursion and Nesting with examples

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Server Security, SQL Stored Procedure, SQL Trigger
Trigger events can be fired within another trigger action. One Trigger execution can trigger even on another table or same table. This trigger is called NESTED TRIGGER or RECURSIVE TRIGGER. Nested triggers SQL Server supports the nesting of triggers up to a maximum of 32 levels. Nesting means that when…
Read More

SQL SERVER – Fix : Error : Msg 7311, Level 16, State 2, Line 1 Cannot obtain the schema rowset DBSCHEMA_TABLES_INFO for OLE DB provider SQLNCLI for linked server LinkedServerName

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server Security, sqlcmd
You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server or to a linked SQL Server 7.0 server. Error: The stored procedure required to complete this operation could not be found on…
Read More
Exit mobile version