SQL Server General DBA

Sonasoft

Disaster recovery is an important topic to DBAs. In this interview with Dr. Vas Srinivasan, Vice President of Marketing of Sonasoft.com, makers of SonaSafe for SQL Server, you will learn about the importance of SQL Server backups and disaster recovery. Tell us a little about Sonasoft, and what its mission is. Sonasoft’s vision is to […]

SQL Server 2000: View Basics

Views are nothing but saved SQL statements, and are sometimes referred as “Virtual Tables”. Keep in mind that Views cannot store data (except for Indexed Views); rather they only refer to data present in tables. Let’s checkout the basic syntax for creating a view: CREATE VIEW <View_Name> AS           <SELECT Statement>         GO There are two […]

An Interview with Simon Galbraith, Marketing Director of Red Gate Software, on Major Trends in the SQL Server Market

What do you see as the major trends affecting the SQL Server market? SQL Server is becoming one of Microsoft’s biggest businesses. As it becomes bigger and more important, I think we’ll see a number of changes that affect users, Microsoft, and the market in which Red Gate participates. The main market for SQL Server […]

Taking a Proactive Approach with SQL Server Agent

SQL Server agent plays an important role in the day-to-day tasks of a database administrator (DBA). It is often overlooked as one of the main tools for SQL Server management. Its purpose is to ease the implementation of tasks for the DBA, with its full-function scheduling engine, which allows you to schedule your own jobs […]

How to Find a SQL Server Database Object

How many times, we as a SQL developer or DBA, find ourselves shuffling through objects in Enterprise Manager, or expanding the left pane of Query Analyzer, trying to find a table or view for which we have no clue, except a nearly correct name, and the only way we would know that it is the […]

Pros & Cons of Using SELECT, Views, and Stored Procedures in SQL Server

When I first started using SQL Server as a novice, I was initially confused as to the differences between the SELECT statement, views, and stored procedures. They all seemed to perform more or less the same task (retrieve data), and I wanted to know the pros and cons of using each. Why would SQL Server […]

Keep Your SQL Servers Synchronized with SQL Compare and SQL Data Compare

Managing multiple versions of the same database across different environments (i.e. Development, Test, Production, and Disaster Recovery site) is perhaps one of the most important and least favorable Database Administrative duties. Whether it’s synchronizing database objects or actual data, creating utilities to perform this obligatory task is somewhat of a dreaded chore. I mean, think […]

Can Amazon Serve Customers and Protect Privacy at the Same Time? (What Data Should DBAs Keep and Discard)

One of the biggest challenges for DBAs and programmers is deciding when to keep information and when to discard it. Good records are both the product of a natural, protective instinct, and a requirement for many businesses. That’s why websites and businesses need detailed tracking information to offer the most customization and assistance.But this information […]

Migrating from Oracle to SQL Server

I was involved in a recent project to migrate an Oracle database to Microsoft SQL Server 2000, and successfully migrated all Oracle objects to SQL Server. This experience has encouraged me to write an article on Oracle to SQL Server 2000 migration. In this article, I will explain how to transfer Oracle Objects, including constraints […]

Sample SQL Server Disaster Recover Plans

Continues…
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |