Microsoft SQL Server Archives - Page 14 of 17

Dec 17

Stored procedure execution info with query plan

By Lori Brown | Expert , Performance Tuning , SQL Administration , SQL Server

Sometimes it is good to have some queries in your toolkit that give you information on how things are running that includes the actual execution plan. While looking at Glenn Berry’s diagnostic query scripts (http://www.sqlskills.com/blogs/glenn/sql-server-diagnostic-information-queries-for-september-2015/), which are very good btw, I found queries that will list stored procedure statistics but none had the execution plan […]

Dec 02

How to connect using the Dedicated Administrator Connection

By SQLRx Admin | Intermediate , SQL Administration , SQL Server , Tip of the Month

The SQL dedicated administrator connection(DAC) has been around since SQL 2005 and is a diagnostic connection that is designed to allow an administrator to troubleshoot SQL Server when the instance is having problems. Only members of the sysadmin role can connect using the DAC. You can connect using the DAC both through SQLCMD (SQLCMD –A […]

Nov 19

Reset a lost or forgotten SA password

By Lori Brown | Beginner , SQL Administration , SQL Server

— By Lori Brown @SQLSupahStah Any login that is a member of the sysadmin role can reset the SA password. But, what if you have a hostile takeover by an application or for some strange reason don’t have any other logins as members of the sysadmin role? Don’t laugh! I have actually run into both […]

Nov 12

Good DBA! Tasks that all DBA’s should do to have a Stable SQL Server

By Lori Brown | Beginner , SQL Administration , SQL Server

— By Lori Brown @SQLSupahStah What are the critical aspects of SQL Server that a DBA should check on a daily basis? How about on a weekly or monthly basis? Daily Checklist Backups: Check your backups (Full, Differential, Transaction Logs) to validate that they were successfully created per your company’s policies. Nightly Processing: Review the nightly or […]

Nov 04

SQL 2014 Backup Encryption

By SQLRx Admin | Beginner , SQL Administration , SQL Server , Tip of the Month

Available in SQL Server 2014 Enterprise Edition and Standard Edition Backup encryption has been introduced in SQL 2014 to allow encrypting backups without being forced to encrypt the entire database. Several encryption algorithms are supported, including Advanced Encryption Standard (AES) 128, AES 192, AES 256, and Triple DES. You can also compress the encrypted backup. […]

Oct 29

Find and Remove Duplicate Records

By Ginger Daniel | Beginner , Miscellaneous , SQL Development , SQL Server

— by Ginger Keys Having duplicate records in a database is an age-old problem that almost every organization has to deal with. Duplicates can appear because of careless data input, merging records from old systems into new systems, uploading leads from purchased lists, and multiple other reasons. Identifying these duplicate records can also be tricky. […]

Oct 23

Contained Databases – Pros and Cons

By Ginger Daniel | Beginner , Miscellaneous , SQL Administration , SQL Server

Beginning with SQL Server 2012 and beyond, Microsoft has developed a new feature in all editions of SQL Server that allows us to create databases independent of the instance hosting that database. In this article I will cover some of the features, pros and cons, and how to create a contained database. What is it? […]

Oct 15

Using Common Table Expressions to Improve Query Performance

By Jeffry Schwartz | Advice , Intermediate , Performance Tuning , SQL Development , SQL Server

-by Jeffry Schwartz Queries with multiple join clauses create particularly difficult issues when they perform poorly. Join ordering is extremely important because if a join creates a huge interim result set at the beginning of the query execution, SQL Server must continue to handle this result set until it can be trimmed down with filtering […]

Oct 08

AlwaysOn Availability Groups – Enable or Disable Jobs on Failover

By Lori Brown | Helpful Scripts , Intermediate , SQL Administration , SQL Server

— By Lori Brown @SQLSupahStah After reading up on AlwaysOn Monitoring and Alerting (http://blog.sqlrx.com/2015/08/27/alwayson-monitoring-and-alerting/), I was asked to come up with a way to automatically enable jobs that may only need to run on the primary replica of an availability group. Requirements were that on failover of an AlwaysOn Availability Group some jobs should be […]

« Previous 1 … 12 13 14 15 16 17 Next »

Tag Archives for " Microsoft SQL Server "