Pro Members

DB2 Pro Members Standard Members

Materialized Query Tables…and the Death of Denormalization?

by

Materialized Query Tables…and the Death of Denormalization? By Craig S. Mullins Materialized Query Tables, or MQTs, are provided by many relational database systems as a means of speeding up access to static data. You also may know them as Automatic Summary Tables, or ASTs, but regardless of the name, the functionality is basically the same. Though not exclusively for 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.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting problems with SQL Server 2008 R2 Database Mail

by

Troubleshooting problems with SQL Server 2008 R2 Database Mail If you have problems with SQL Server 2008 R2 Database Mail, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 Database Mail 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.
Register
Already a member? Log in here
Continue Reading →
Development Pro Members Standard Members

Trends in Database Technology

by

Trends in Database Technology Introduction Since 1965, attempts to develop different approaches for the construction of different versions of Database Management systems (DBMS) technology were made, which is today vital to the decision making process from Top management to bottom management. But the competition among technical experts in the creation of sophisticated software in this area made complicated the decision...

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

System Health Session Dashboard – sp_server_diagnostics

by

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.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server Database Consolidation

by

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.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

The Ever-Changing Role of the DBA

by

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.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting problems with SQL Server 2008 R2 Business Intelligence Development Studio

by

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.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Getting Started with Contained Databases

by

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.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Denormalization Techniques for Relational Databases

by

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.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting problems with SQL Server 2008 R2 Management Studio

by

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.
Register
Already a member? Log in here
Continue Reading →
1 … 100 101 102 103 104 … 110