SQL Server

Pro Members SQL Server Standard Members

Tips for using SQL Server 2012 configuration options

by

Tips for using SQL Server 2012 configuration options One of the ways to optimize SQL Server 2012 performance is setting the appropriate server configuration options. You can set these options by using the SQL Server Management Studio or the sp_configure system stored procedure. SQL Server 2012 configuration options may be separated to two categories: – Options that take effect immediately...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server monitoring and optimization–(Part 2)

by

SQL Server monitoring and optimization – (Part 2) Author: Basit A. Farooq Editor’s Note: In this first of the two part article series, you learned how to use monitoring tools, including System Monitor and SQL Server Profiler. You also learned how capture a trace file or table using SQL Server Profiler. In this second part, you learn how to use...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

What is More Valuable: a Jack of All Trades or an Expert of One?

by

Hello, this is Laura Lee Rose – author of the books TimePeace: Making Peace with Time – and the Book of Answers: 105 Career Critical Situations. I am a business and efficiency coach that specializes in professional development, career management, time management, and work-life balance strategies. Today’s question is : What’s more valuable to job force: Jack of all trade...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting problems with locking in SQL Server 2012

by

Troubleshooting problems with locking in SQL Server 2012 If you have problems with SQL Server 2012 locking, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 locking bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Some tips for using SQL Server 2012 Database Console Commands

by

Some tips for using SQL Server 2012 Database Console Commands Try to run the DBCC commands when there are no other disk I/O operations, such as disk backups, replication and so on. Use DBCC CHECKFILEGROUP instead of DBCC CHECKDB, if you need to check only specified filegroup, not entire database. If your database contains several filegroups and you need to...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server Monitoring and Optimization (Part 1)

by

SQL Server monitoring and optimization – (Part 1) Author: Basit A. Farooq To optimize the performance of your database, you need to monitor and tune. You determine the performance baseline, how SQL Server is currently performing, through monitoring. Your optimization process includes making changes and then monitoring their effect. This means adjusting two overlapping performance areas, that is, database server...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server Encryption Options – Part 2

by

SQL Server Encryption Options – Part 2 Author: Basit A. Farooq Editiors Note: In the first part of this article series, I discussed the options for encrypting connections and learn concepts on how to encrypt confidential data in the database. In this second part, I will show you how to encrypt data using cell-level encryption, and how to encrypt database...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting problems with connection to SQL Server 2012

by

Troubleshooting problems with connection to SQL Server 2012 If you have problems with connection to SQL Server 2012, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 connection bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server Encryption Option – Part 1

by

SQL Server Encryption Options – Part 1 Author: Basit A. Farooq Many database servers store confidential data, which must be protected from unauthorized access when it’s transmitted across the network and stored on the server. SQL Server provides support for encrypted connections, encrypting data, encrypting database and for encrypted storage. In this first part of this article series, I’ll discuss...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2012 Log Shipping

by

Troubleshooting SQL Server 2012 Log Shipping If you have problems with SQL Server 2012 log shipping, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 log shipping bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
1 … 93 94 95 96 97 … 115