Full list of articles posted

February 25, 2012 Powershell Get-EventLog and Event Log messages

February 24, 2012 SQL Server - DBA Team FAQ

February 20, 2012 SQL Server – Powershell Active Directory search

February 17, 2012 SQL Server – read only database status

February 15, 2012 SQL Server – DBA productivity and less is more

February 10, 2012 Powershell default start directory

February 09, 2012 SQL Server Product Life Cycle

February 08, 2012 Not enough storage is available to complete this operation

February 07, 2012 Send email from Powershell with attachment

February 06, 2012 List failed SQL server Jobs with Powershell

February 04, 2012 List SQL Server Instances using Powershell and Get-ItemProperty

February 02, 2012 SQL Server – COPY TABLE from another SQL Server

January 31, 2012 SQL Server – Send email using Powershell

January 30, 2012 SQL server – ISNUMERIC and checking for valid numeric tyopes

January 27, 2012 SQL Server - Generate SQL INSERT from Excel

January 26, 2012 SQL Server – Error Logs recycle without SQL Server Restart

January 22, 2012 SQL Server - BACKUP LOG WITH NO_LOG

January 21, 2012 SQL Server – Modifying Production Data Good Practise

January 20, 2012 SQL Cachestore flush

January 19, 2012 SQL Server – Powershell Excel to HTML

January 18, 2012 SQL Performance Tuning - optimizing for response time

January 17, 2012 Hungarian Notation is misunderstood

January 16, 2012 SQL Agent Jobs – Schedule in seconds

January 12, 2012 SQL Server – Logical Disk Read Bytes/sec and disk io

January 11, 2012 SQL Server – Backup to NUL trick - read throughput

January 10, 2012 SQL Server – Maintaining different environments

January 09, 2012 SQL Server –WRITELOG and how to reduce it

January 06, 2012 Arithmetic overflow error and isdate sql

January 05, 2012 SQL Server Disable Indexes and Rebuild Indexes dynamically

January 04, 2012 SQL SERVER REBUILD INDEX

January 03, 2012 SQL SERVER DISABLE INDEX

January 02, 2012 SQL Index Fragmentation and sys.dm_db_index_physical_stats

January 01, 2012 SQL Server DBA – Grow as a DBA

December 31, 2011 SQLServerDBA News - 2011 Review for SQLServerDBA

December 24, 2011 Top 10 SQL Server Posts for 2011

December 21, 2011 Routing OSPF and Network Team

December 14, 2011 Nic Teaming

December 13, 2011 CPU Count

December 12, 2011 SQL Traces and c2 auditing are different

December 09, 2011 SQL Database Status with sys.databases

December 07, 2011 SQL Server Latency

December 06, 2011 DATEADD and variables in SQL

December 05, 2011 Enable XA transactions for SQL Server

December 02, 2011 System Reserved Partition and monitoring

December 01, 2011 SQL Table variable and temporary table

November 28, 2011 SQL Dirty Pages

November 26, 2011 Data Loading Performance Guide

November 24, 2011 MS DTC and sys.dm_tran_active_transactions

November 23, 2011 ALTER INDEX permissions

November 22, 2011 Monitoring a Rollback and sys.dm_exec_requests

November 15, 2011 Quotename in SQL

November 14, 2011 DBCC CHECKDB

November 10, 2011 Stored Procedure Checklist

October 24, 2011 SET ARITHABORT ON

October 24, 2011 ALTER SCHEMA

October 19, 2011 JOIN IN SQL FAQ

October 18, 2011 SQL Server Collation

October 15, 2011 SQL WAIT TYPE – OLEDB and how to reduce it

October 10, 2011 sys.dm_os_loaded_modules

October 08, 2011 DBCC checktable

October 04, 2011 TCP Chimney offload

October 03, 2011 SQL Server Database SUSPECT state

September 28, 2011 Format Disk for SQL Server

September 27, 2011 ALTER AUTHORIZATION sql to change owner of a database

September 23, 2011 Performance Monitor Counters for SQL Server performance testing

September 22, 2011 SSIS version in SQL Server

September 20, 2011 Migrating to SQL Server from another Database platform

September 16, 2011 Import Data from AS400 to SQL Server

September 13, 2011 Powershell , Excel charts and data presentation

September 13, 2011 SQL Server Quiz – the last time a stored procedure was executed

September 08, 2011 TPC-H generate test data , test queries and sql database benchmark

September 05, 2011 Database Cost Savings

September 03, 2011 Server sudden shutdown unavailable

September 02, 2011 SQL Server test data generation testing tools

August 31, 2011 Mobile Commerce and SQL Performance Tuning

August 30, 2011 TRUNCATE_ONLY is not a recognized BACKUP option

August 30, 2011 Datawarehouse Trends – In-memory

August 27, 2011 Storage Checklist FAQ

August 25, 2011 Index Disabled and Index Rebuild

August 24, 2011 Correctness and stress test

August 23, 2011 Disk IO performance and SQLIO

August 22, 2011 Define IOPs for all database servers

August 19, 2011 Attach database without log file and rename database

August 18, 2011 How to report a SQL Server performance problem

August 17, 2011 RAID server configuration and disk amounts

August 16, 2011 Calculate table size with existing data

August 15, 2011 Should libraries be installed on database servers ?

August 12, 2011 Calculate disk IO throughput and MB per second

August 11, 2011 SQL Server Storage and IO performance

August 10, 2011 Database autogrow and slow database recovery – t-sql Tuesday 21

August 09, 2011 SQL Server Optimizer and Trivial Plan

August 08, 2011 Data compression in SQL Server 2008

August 04, 2011 Guide to Plain English

August 03, 2011 Powershell to HTML

August 02, 2011 AWE SQL Server memory not supported in future releases

August 01, 2011 Redundancy for SQL Server

July 30, 2011 Frequently Asked Questions

July 27, 2011 SQL Sp_send_dbmail and bcc

July 26, 2011 Disable Index and Rebuild Index for Updates on very large tables

July 25, 2011 Affinity Mask on SQL Server 2008 R2

July 20, 2011 Powershell sql server security audit

July 19, 2011 SET SHOWPLAN ON

July 18, 2011 SQL Server sql_handle returns sql statement

July 16, 2011 Powershell - run script on all sql servers

July 15, 2011 SQL Azure July 2011 Service Release

July 14, 2011 Speed and Duplex settings

July 13, 2011 Database Virtual Server Candidacy Criteria

July 12, 2011 Filtered statistics, T-SQL best practises for T-SQL Tuesday

July 11, 2011 SQL Server – Windows Virtual memory and paging file location

July 10, 2011 Optimize query for LIKE

July 09, 2011 Excel Connect to SQL Server

July 08, 2011 SQL Server Import Data from DB2 AS400 iSeries

July 07, 2011 SQL Server detected a DTC/KTM in-doubt transaction with UOW

July 06, 2011 SQL Server ALTER DATABASE , change collation and exclusive lock

July 05, 2011 DBA and the end of time management

July 04, 2011 Capacity Planning

July 03, 2011 SQL Server Version with Powershell

July 02, 2011 SQL Kill connections to a database

July 01, 2011 Missing Indexes. Equality and Inequality on sys.dm_db_missing_index_details

June 30, 2011 SQL WAIT TYPE – RESOURCE SEMAPHORE and how to reduce it

June 29, 2011 BACKUP failed to complete the command BACKUP LOG

June 28, 2011 The future of the SQL Server Performance Tuning Expert

June 27, 2011 SQL Server Database names with spaces

June 26, 2011 SQL Disk storage performance overview

June 25, 2011 SQL Server IO patterns and RAID levels

June 23, 2011 Outsourcing DBA tasks to an Offshore IT company

June 22, 2011 SQL Server xp_msver

June 21, 2011 SQL Server Database Size and Free Disk Space Daily Report

June 20, 2011 SQL Server DBA Top 10 automation tasks

June 19, 2011 What is SQL Server Query Tuning?

June 18, 2011 Top 10 DBA mistakes

June 17, 2011 Window Perfmon scripting, SQL Server perfmon and how to perfmon

June 17, 2011 Powershell for SQL SMO

June 16, 2011 Professional Development and Soft Skills Training Books for the SQL Server DBA

June 15, 2011 SQL Server database files configuration checklist

June 14, 2011 Powershell and Disaster Recovery preparation – T-SQL Tuesday

June 13, 2011 SQL Server Transaction Log files - performance myth

June 12, 2011 SQL Server Database Status,monitoring and Restores

June 11, 2011 SQL Server MSDB size checklist

June 10, 2011 T-SQL UPDATE JOIN on a table.

June 09, 2011 SQL Server architecting write-intensive databases

June 08, 2011 SQL Server Buffer Cache Hit Ratio and memory pressure

June 07, 2011 SQL Server page life expectancy and memory bottleneck

June 06, 2011 SQL Server ISOLATION LEVELs ,UDF and table hints

June 05, 2011 SQL Server Tuning Targets

June 04, 2011 SQL Server Performance ,memory pressure and memory usage

June 03, 2011 SQL SSIS and service pack upgrade

June 01, 2011 SQL Server database free space with sys.dm_os_performance_counters

May 31, 2011 SQL open transactions and how to find

May 30, 2011 ISO-11179 Naming Conventions and SQL DDL

May 28, 2011 SQL Server Error 26 troubleshooting checklist

May 27, 2011 Top 5 SQL Server DMV for Index Analysis

May 25, 2011 SQL Server CTE and PARTITION BY

May 24, 2011 Bulk Insert CSV into a SQL Server table

May 24, 2011 SQL BACKUP failed to complete BACKUP LOG and sql error 3041

May 23, 2011 Top 10 DBA Tips to develop your competitive edge

May 22, 2011 SQL Server 2008 books online download

May 21, 2011 SQL Server non-clustered index checklist

May 20, 2011 SQL WAIT STAT - TRACEWRITE and how to reduce it

May 19, 2011 DBA jobs

May 18, 2011 SQL Server SLEEPING MODE , locks and transactions

May 17, 2011 SQL Server sp_updatestats and UPDATE STATISTICS

May 16, 2011 SQL Server Query Optimizer and Statistics

May 14, 2011 Jack Vamvas DBA

May 14, 2011 Disk IO performance , disk block size tuning and SQL Servers

May 13, 2011 IO_completion on disk solved with Wait Stats and Perfmon

May 12, 2011 Auto Update Statistics and Update Statistics in SQL Server

May 10, 2011 SQL Server Linked Servers and User permissions

May 09, 2011 How to request SQL Server troubleshooting

May 07, 2011 Slow SQL Server Backup and Restore with DBCC TRACEON (3004, 3605, -1)

May 05, 2011 SQL Table variables do not support indexes MYTH

May 04, 2011 BACKUPIO and sql database backup

May 03, 2011 Detach and Offline for moving databases

May 03, 2011 Stored Procedures versus ad-hoc paramaterized queries.Which is faster?

April 30, 2011 Operations DBA description

April 29, 2011 TempDB performance and strategy checklist

April 28, 2011 SSPI handshake failed with error code 0x80090304 while establishing a connection with integrated security

April 27, 2011 Powershell,PSEexec and lock pages in memory – made easy

April 26, 2011 SQL Server and TSM - ANS1315W (RC15) Unexpected retry request.

April 22, 2011 SQL Server - Grant execute on all stored procedures

April 21, 2011 Sys.dm_os_memory_clerks and AWE memory allocation

April 20, 2011 Virtualization – and database servers

April 19, 2011 SQL Server – sys.dm_os_waiting_tasks and performance

April 18, 2011 Perfmon ,Waits and Queues

April 16, 2011 SQL Server – Disk is full during reindexing and ALTER DATABASE

April 15, 2011 Query Response Time measure

April 09, 2011 SQL Server – SOS_SCHEDULER_YIELD and how to reduce it

April 08, 2011 SQL Server – SAN and anti virus

April 06, 2011 SQL server – Pre size a database

April 04, 2011 SQL Server Versions

April 04, 2011 SQL Server – Transaction Log files sequential

April 02, 2011 SQL Server – tempdb and solid state drives

March 29, 2011 SQL Server – LOGMGR and how to reduce it

March 25, 2011 SQL Server – IO_COMPLETION and how to reduce it

March 24, 2011 SQL Server Async_io_completion and how to reduce it

March 23, 2011 SQL Server profiler Scan Event

March 21, 2011 SQL Server – read ahead

March 18, 2011 SQL server 2008 R2 – Silent installation for the SSMS and client tools

March 16, 2011 SQL Server – virtualization - is it a viable alternative

March 15, 2011 Performance Metrics used in acceptance tests

March 12, 2011 7 habits of highly effective DBAs

March 10, 2011 Event ID 40960 Cannot generate SSPI context

March 09, 2011 Database Server Consolidation

March 07, 2011 SQL Server – files and filegroups. Improving database performance

March 04, 2011 SQL Server – Pageiolatch_sh and how to reduce it

March 03, 2011 Active Directory and Microsoft Management Console

March 01, 2011 Login failed for user 'username'. The user is not associated with a trusted SQL Server connection

February 28, 2011 SQL Server – performance counters not appearing

February 26, 2011 Waitstats CXPACKET wait type and how to reduce it

February 25, 2011 SQL Server system redundancy and high availability

February 24, 2011 SQL Server – RAID levels overview

February 22, 2011 Not enough server storage is available to process this command and poolmon.exe

February 22, 2011 Datawarehouse Wait Stats

February 18, 2011 Speed up copying large files with ESEUTIL

February 17, 2011 SQL Server – CONTROL SERVER

February 14, 2011 SQL Server – architecting online utilities for 24 x 7

February 12, 2011 Powershell – setting the Execution Policy

February 09, 2011 SQL Server table hint for index

February 07, 2011 SQL Server Remote DBA - who wants to be one?

February 05, 2011 SQL Server statistics and Datawarehouse

February 02, 2011 RESTORE VERIFYONLY

February 02, 2011 SQL Server recompile error after upgrade from 2000 to 2005

February 01, 2011 Largest SQL Server projects in the world

January 31, 2011 SQL Server 2008 licensing

January 30, 2011 SQL server RESTORE detected an error on page (0:0) in database as read from the backup set.

January 29, 2011 SQL Server Collations and code page

January 28, 2011 SQL Server – Disk Queue length

January 27, 2011 SQL Server Materialized Views

January 26, 2011 How to View Remote Desktop Sessions

January 25, 2011 SQL Server monitoring situations

January 24, 2011 sp_password and ALTER LOGIN

January 22, 2011 Restricted user on database after restore

January 21, 2011 Virtual Device Interface (VDI) and sysadmin

January 20, 2011 SQL Server faster restores with instant file initialisation

January 19, 2011 SQL Server scaling techniques

January 17, 2011 sys.sysprocesses and permissions

January 15, 2011 SQL Server 2008 security changes

January 13, 2011 Shrink tempdb without sql server restart

January 12, 2011 SQL Server – refresh all Views

January 10, 2011 SQL Server measure i\o transaction rates and sys.dm_io_virtual_file_stats

January 07, 2011 SQL Server query plans in cache

January 07, 2011 SQL server 2005 install with ISO images

January 06, 2011 SQL Server resizing a column on a large table

January 05, 2011 AWE memory full and dynamic releasing on SQL Server 2005 Standard Edition 32 bit

January 02, 2011 Index missing Statistics

January 01, 2011 Set up Database Mail on SQL Server 2005 and SQL Server 2008

December 31, 2010 Powershell – adding multiple worksheets to Excel spreadsheet

December 30, 2010 TSM ACO5422E BackUp failure and OOM on SQL server

December 29, 2010 List all indexes of all tables

December 27, 2010 Last time a stored procedure was executed

December 18, 2010 SQL server OLE Automation memory pressure

November 06, 2010 IO Requests taking longer than 15 seconds to complete

October 17, 2010 SQL Server 2005 memory configuration management

October 09, 2010 SQL Server deadlocks analysis

October 05, 2010 Copy only backup in SQL server 2005 and not break the backup chain

October 01, 2010 Time Management

September 29, 2010 SQL Server execution plan as text

September 25, 2010 SQL Server - Backup data is incorrectly formatted

September 19, 2010 Restoring a sql server 2005 master database on sql server 2005 error

September 05, 2010 SQL Server 2005 and SQL Server 2008 Upgrade tasks

August 31, 2010 SQL Server Update Statistics with FULL SCAN

August 28, 2010 SQL Server BACKUP - There is insufficient system memory to run this query

August 26, 2010 SQL Server - sp_MSforeachtable

August 24, 2010 SQL SELECT INTO

August 23, 2010 Differential backup cannot be restored . BACKUP with COPY_ONLY

August 19, 2010 SQL Server DBA Tools

August 09, 2010 Page level locking is disabled

July 26, 2010 Database Mirroring planning on SQL server 2005

July 09, 2010 SQL Server agent fixed roles

July 08, 2010 SQL Server Security Policy

July 01, 2010 Name change to SQL Server DBA

June 26, 2010 Linked Server migration from sql server 2000 to 2005

June 23, 2010 Performance Myth : Replacing a CURSOR with a WHILE LOOP and think you are not processing with a row

May 18, 2010 Virus scan exclusions for SQL Server

May 08, 2010 Query baseline testing

May 01, 2010 Free space on drives using Powershell

April 09, 2010 Table sizes and percentages

March 27, 2010 Contact me Jack Vamvas

January 30, 2010 All tables row count

December 07, 2009 Space used for all databases

September 19, 2009 sp_detach_db causing loss of permissions

August 19, 2009 Quick uninstall of SQL Server 2005 instance

July 31, 2009 Recover from a Suspect database

July 21, 2009 SQL Server backup review with Powershell

May 27, 2009 SQL Server blocked access to procedure 'dbo.sp_sqlagent_get_startup_info' of component 'Agent XPs'

May 19, 2009 SQL and Markov Chains in Tennis

January 21, 2009 sp_spaceused not refreshing

January 20, 2009 Viewing legacy DTS packages in SSMS

January 13, 2009 SQL Server Surface Area Configuration command line interface

January 08, 2009 ole automation configuring for SQL Server 2005

January 07, 2009 Powershell and Batch files

January 05, 2009 Powershell : SQLCMD and invoke-expression

December 31, 2008 SQL Server restore problem - Error 3154: The backup set holds a backup of a database other than the existing database

December 30, 2008 mssqlsystemresource moving error

October 19, 2008 Interview with Jim Gray

September 22, 2008 Account Locked out

September 19, 2008 Move MDF/LDF files to a designated path

September 03, 2008 Space Integrity Check

August 28, 2008 SQL Server xp_regread with T-SQL

August 23, 2008 SQL Best Practices in less than 6 minutes 1/3