Articles

Performing a Database Restore is a part of a DBA's daily life. A DBA may need to perform a Restore due to various reasons such as recovery, refreshing a database for testing purpose etc. Many times it can be difficult to perform a Restore due to corrupted media, low disk space on the server and so on. This articlel outlines one approach which can be used to Restore the backup of the Production Database a test environment.

2011-12-09

4,218 reads

Setup Alerts for PBM

by Site Owners

SQLServerCentral.com

Blogs

PBM raises errors for policy violations. We can create alerts on those errors to be notified of policy violations. In order to setup alerts on these errors there are three prerequisites. Note that violations for the “On Demand” evaluation mode do not raise errors. A policy must be set to

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2011-12-09

1,094 reads

Raw Materials - The Terminator

by Larry Gonick

SQLServerCentral.com

Raw Materials

I'm big and impersonal. Are you?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(26)

You rated this post out of 5. Change rating

2011-12-08 (first published: 2010-04-21)

10,876 reads

Discuss

sp_prepexec and nHibernate

by David Poole

SQLServerCentral.com

sp_prepexec

SQL Server architect David Poole sets about exploring sp_prepexec when called from nHibernate.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(58)

You rated this post out of 5. Change rating

2011-12-08

9,783 reads

Discuss

A DBA is a Data Professional

by Grant Fritchey

SQLServerCentral.com

Career Growth

DBA (Database Administrator) is a Data Professional tasked with managing an organization’s data using some sort of database software, such as Microsoft SQL Server. They are concerned with gathering, storing and presenting data to data consumers, which includes virtually anyone in the modern world.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2011-12-08

1,076 reads

Extended Events - inaccurate_cardinality_estimate

by Site Owners

SQLServerCentral.com

Blogs

Extended events have been a bit of a personal “Elephant in the room” for me. I know they are there and I should really get on a start using them but never *quite* have a compelling enough reason.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2011-12-08

1,538 reads

SQL Server Database Growth and Autogrowth Settings

by Additional Articles

SimpleTalk

Administration

It's easy to create a database nowadays with point-'n-click, but if you've left your database's autogrowth settings at their default, you may hit problems in the future. Why? What to do about it? Read on!

2011-12-08

3,222 reads

Optimal Storage of IP addresses in a SQL Server database

by Additional Articles

MSSQLTips.com

IP Addresses

Often databases are used with web-based interfaces and recording the IP address of the end user can assist with debugging, marketing, bandwidth planning and collation selection to name a few. In a scenario where each page access is logged, is there an optimal way to store IP addresses?

2011-12-07

3,950 reads