Date Range
Date Range
Date Range
SQL DBA Scripts, sql 2005, sql server dba, sql 2008R2. In order to use AWE, the Lock Pages in Memory privilege must be granted for the account that runs SQL Server. On both 32-bit and 64-bit platforms, memory that is allocated through the AWE mechanism cannot be paged out. General system and SQL Server state and memory-specific DMVs.
Sunday, September 28, 2008. Wednesday, January 30, 2008. Windows Communication Foundation Security guide. Here is good link related to WCF security. Wednesday, September 26, 2007.
Of course - much of the focus of security these days is in the application space but SQL injection remains a large part of that. My focus will shift more to this area going forward.
Informações técnicas sobre SQL Server 2005, 2008, 2008 R2, 2012, 2014 e 2016. Terça-feira, 28 de julho de 2015. Entendendo o crescimento do Transaction Log. O crescimento do Transaction Log é talvez um dos mais frequentes problemas que um Administrador de Banco de Dados pode enfrentar no dia a dia, chegando até encher por completo o disco ou esgotar a capacidade de armazenamento do arquivo. A coluna log reuse wait desc. Da visão de sistema sys.
Backing up SQL Server Database. Restoring Database in SQL Server. Using SQL Server Database Tuning Advisor. SQL Server RPO and RTO. SQL Server 2008 HA and DR Solutions. OS Memory and Paging Performance Counters. OS CPU and Processor Counters. OS Disk and Miscellaneous Counters.