SSWUG.ORG Author Content

Four Non-Technical Steps To Data Security

As you work to protect your data in this day and age of data breaches and regulatory compliance, technology and software solutions to data and database security spring to the front of most people's minds. This is to be expected because, after all, most of our data is stored on computers, so technology and software are required to protect this data from unauthorized access. This is a good thing; technology is a crucial component of protecting your valuable business data. However, it is not the only thing.

Tips for using SQL Server 2008 configuration options (Part 1)

In this article, you can find some useful tips to use SQL Server 2008 configuration options.

The Real Story Behind Geo-clusters

If you are a web retailer or a financial institution, this kind of availability is critical to your business.

Security Is Now Much More Than Encrypting Column Data

In the past, you'd put up a firewall, encrypt social security numbers and credit card information and you'd be set. Information was protected and you were providing reasonable controls. Not so any more. Here are some thoughts about not only what to protect, but why.

Troubleshooting SQL Server 2008 Analysis Services problems (Part 3)

In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2008 Analysis Services. He also tells how you can resolve these problems.

So, You Want to be a DBA? (Part 3)

An important task is running a CheckDB on your database systems.

Some SQL Tricks for the DB2 Developer

It is always a good idea to keep your bag of SQL tricks loaded with techniques to help solve some of the more common or troubling application development problems.

Troubleshooting SQL Server 2008 Analysis Services problems (Part 2)

In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2008 Analysis Services. He also tells how you can resolve these problems.

So, You Want to be a DBA? (Part 2)

When you start as a new DBA, the first task you should perform is to ensure that a proper backup process is in place.

Avoiding Bachelor Programming Syndrome

Unless you plan for, and issue regular COMMITs in your DB2 batch programs, you will cause locking problems for your DB2 environment.

Troubleshooting SQL Server 2008 Analysis Services problems (Part 1)

In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2008 Analysis Services. He also tells how you can resolve these problems.

So, You Want to be a DBA? (Part 1)

So, you want to be a database administrator (DBA). You want to be in charge of the data of your company and realize that data is the lifeblood of any company.

Troubleshooting SQL Server 2008 System Stored Procedures (Part 2)

In this article, Alexander Chigrik explains some problems that you can have when you use SQL Server 2008 system stored procedures. He also tells how to resolve these problems.

Tips for IT Professionals to Increase Effectiveness and Efficiency at the Office

Many of us like to think of ourselves are multi-tasking experts. In reality, multi-tasking is an euphemism for interruptions and distractions.

Troubleshooting SQL Server 2008 System Stored Procedures (Part 1)

In this article, Alexander Chigrik explains some problems that you can have when you use SQL Server 2008 system stored procedures. He also tells how to resolve these problems.

Overview of SQL Server Indexes

A detailed description of what indexes in SQL Server are and how they work.

10 IT Career Boosting New Year Resolutions (Part 2)

Career-driven professionals in the IT industry should want to surround ourselves with energetic and like-minded people.

A Resurgence of Metadata Management

Are we poised for a resurgence of interest and attention being given to metadata and its management?

The Future of PaaS: Preparing for a World of Developers and Data

By understanding and embracing modern development tools - starting with PaaS - there is a huge opportunity for DBAs to offer developers the guidance they need to build around data.

Troubleshooting SQL Server 2008 service pack 2 problems

In this troubleshooting checklist, you can find descriptions of known SQL Server 2008 Service Pack 2 bugs and information on how to resolve or work around these problems.

Setting up SQL Server on a Virtual Machine

Through reading about my discoveries, you should have the material needed to get started with using SQL Server in a virtual environment.

10 IT Career Boosting New Year Resolutions (Part 1)

At the beginning of every year, many people in the IT field explore the possibilities to improve their career and professional life through New Year resolutions

Building a Solid and Workable Disaster Recovery Strategy

Even for those of you who are leveraging cloud solutions for hosting your infrastructure, you still need to consider what happens if your provider has a major outage.

Using System Monitor to Tune SQL Server 2008

In this article, you can find some helpful tips to use System Monitor with SQL Server 2008.

Azure ServiceBus: Connectivity at a Cloud Scale

Azure ServiceBus is a key enabling technology to allowing applications to migrate to the cloud.

Tips for using SQL Server 2008 Database Console Commands (Part 2)

In this article, you can find some tips to optimize SQL Server 2008 performance by using database console commands.

The Tao of the Database Administrator

Can the ancient Chinese philosophy of Tao be applied to database administration?

Tips for using SQL Server 2008 Database Console Commands (Part 1)

In this article, you can find some tips to optimize SQL Server 2008 performance by using database console commands.

Optimistic Locking in DB2 for z/OS

As of DB2 Version 9, a new technique called "optimistic locking" is available to help reduce lock contention.

Troubleshooting SQL Server 2008 Database Engine Tuning Advisor

In this article, Alexander Chigrik explains some problems that you can have with SQL Server 2008 Database Engine Tuning Advisor. He also tells you how you can resolve these problems.