SQL Server Roles

SQL Server-level Roles • SysAdmin: Allows users to perform any activity on the server. • ServerAdmin: Permits users to manage configuration options on…

SQL Administration Part 1

Here are some SQL Administrative queries:

sp_configure Use Type the following to see the options the system sproc “sp_configure” has available to…

T-SQL Basic Command Examples

Some of these snippets are useful when scripting schema changes, as opposed to using the GUI tools. For example, we have several instances…

PowerShell 3.0 Notes

We will post all miscellaneous PowerShell scripts, notes, tips and help on this page. For notes from specific books, please look at the…

Execution Plan Notes

Clustered Index Seek: performed where there is a WHERE clause and the search parameter is included in the clustered index. Clustered Index Scan:…

PowerShell Community eXtensions (PSCX)

TOPIC PowerShell Community Extensions (version 3.0.0.0) SHORT DESCRIPTION Describes the Windows PowerShell Community Extensions (PSCX) module and how to use the contained cmdlets…

SQL Server 2012 Internals

Life Cycle of a Query The command parser evaluates the query and generates a hash to see if the buffer pool has an…