Lock and Latch Compatibility Articles
Here is a good article describing what lock compatibility is all about as well as a few charts for reference: TechNET: Lock Compatibility…
Read MoreAuthor: Lincoln Bovee'
DBCC Notes
This post will be updated regularly as I work through all the DBCC commands. Using ‘DBCC HELP command’ will provide the help and…
Read More
Log-shipping Logins Roles and Rights
Per the MSDN article below, accounts used to perform log-shipping tasks must be a member of the ‘sysadmin’ server role group: “The log-shipping…
Read More
Enabling and Disabling SQL Logins
Here is some simple T-SQL to enable or disable a SQL login account:
|
1 2 3 4 5 6 7 |
-- Disable the login ALTER LOGIN [someLogin] DISABLE GO -- Enable the login ALTER LOGIN [someLogin] ENABLE GO |
Views – 1822
Read More
Using SQL Server 2012 Performance Dashboard Reports
Below is the link to install (on your local workstation instance of SSMS) the SQL Server 2012 Performance Dashboard Custom Reports. SQL Server…
Read More
Using EXISTS for Functions, Stored Procedures and Databases
Here is a segment of code you should add to any T-SQL that is dropping a function or stored procedure to make sure…
Read More
sql_handle vs. plan_handle
sql_handle: is the hash of the original T-SQL source. plan_handle: is the hash of the cached execution plan. The important thing to note…
Read More
A Simple Overview of a SQL Query
Here are the 4 basic steps all queries go through: 1. Parsing: The query is examined by SQL Server to syntax errors, invalid…
Read More
PASSMN User Group, Tuesday January 21st
Today we had a very informative presentation from Merrill Aldrich on SQL Server storage internals. Merrill demonstrated his SQL Server File Layout Viewer.…
Read More
Using WordPress with SQL Server
Here is a great step-by-step blog post on how to use SQL Server and WordPress: Installing WordPress on SQL Server Views –…
Read More