SQL Server

Pro Members SQL Server Standard Members

System Health Session Dashboard – sp_server_diagnostics

System Health Session Dashboard – sp_server_diagnostics In my previous posts on the System Health Session, I have been demonstrating how to use the default System Health Extended Events session to build reports that can be deployed to your Report Server instance. In this post, I shall discuss the new system stored procedure, sp_server_diagnostics, which was introduced in SQL Server 2012...

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.
Log In Register
Pro Members SQL Server Standard Members

SQL Server Database Consolidation

SQL Server Database Consolidation By Basit A. Farooq Introduction The database expansion costs money, not just software licenses. It costs money in maintenance and hardware, and also impacting businesses by indirectly affecting the performance of other applications. Through database consolidation, companies can reduce the number of database servers that they have to manage and reduce the demand for servers and...

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.
Log In Register
Pro Members SQL Server Standard Members

The Ever-Changing Role of the DBA

The Ever-Changing Role of the DBA by Craig S. Mullins Defining the job of DBA is getting to be increasingly difficult. Oh, most people know the rudimentary aspects of the job, namely keeping your organization’s databases and applications running up to par. The DBA has to be the resident DBMS expert (whether that is DB2, Oracle or SQL Server, or...

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.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting problems with SQL Server 2008 R2 Business Intelligence Development Studio

Troubleshooting problems with SQL Server 2008 R2 Business Intelligence Development Studio If you have problems with SQL Server 2008 R2 Business Intelligence Development Studio (BIDS), review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 Business Intelligence Development Studio bugs were fixed in SQL Server service...

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.
Log In Register
Pro Members SQL Server Standard Members

Getting Started with Contained Databases

Getting Started with Contained Databases By Basit A. Farooq Introduction Before SQL Server 2012, when we move or restore databases to a different SQL Server instance, then any logins associated with the database users do not automatically relocates to the new instance. As a result of this, we end up having orphaned users inside databases and these databases do not...

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.
Log In Register
Pro Members SQL Server Standard Members

Denormalization Techniques for Relational Databases

Denormalization Techniques for Relational Databases By Craig S. Mullins Speeding the retrieval of data from relational tables is a frequent requirement for DBAs and performance analysts. One way to accomplish this is to denormalize the tables. The opposite of normalization, denormalization is the process of putting one fact in many places. This speeds data retrieval at the expense of data...

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.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting problems with SQL Server 2008 R2 Management Studio

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

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.
Log In Register
Pro Members SQL Server Standard Members

How to secure SQL Server infrastructure?

How to secure SQL Server infrastructure? By Basit A. Farooq Introduction Databases are an important reservoir of sensitive information in most organizations, and it is important to keep unauthorized users from accessing this information. Obviously, securing SQL Server and database is not an easy task, and we have to follow a set of best practices in order to accomplish this...

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.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting problems with SQL Server 2008 R2 Profiler

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

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.
Log In Register
Pro Members SQL Server Standard Members

Understanding DBCC CHECKDB Command to Deal with Corrupt Database

Understanding DBCC CHECKDB Command to Deal with Corrupt Database Author: Basit A. Farooq DBCC CHECKDB Overview: Database files are volatile, constantly being changed and updated, so that, like any other volatile files in the system, there is potential for them to become corrupt. Because of this, it is necessary to perform periodic maintenance, to validate the allocation, logical, and structural...

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.
Log In Register