Quantcast

SQL Articles

SQL Server Upgrade Recommendations and Best Practices

As the DBA in your organization, you are central to the success of the SQL Server environment. In the case of a system upgrade, you need to act as a driver’ for an upgrade project to ensure success based on your technical expertise and role in the organization. Over this multi-part series, these articles will outline proven and recommended best practices for the upgrade process. This process is detailed from both technical and logistical perspectives which are both critical to the success of the project.

SQL Server Upgrade Recommendations and Best Practices – Part 2

The first article of the series, Part 1 – Upgrade Overview and Project Planning, detailed the business justification for upgrades to SQL Server 2000 related to TCO (Total Cost of Ownership), automation capabilities and new features from both the Business and DBA perspectives. The next portion of the article outlined a detailed process to break down the SQL Server 2000 project as well as the applicable Upgrade project phases using high level steps. Both sets of information were in simple terms for DBAs new to the Upgrade process, well experienced DBAs needing a refresher or for technical managers interested in the level of effort and overall planning for a SQL Server 2000 Upgrade.

Real Life DBA: Dealing with a SQL Server Cluster Failover

Monday 9:30AM

I had just gotten out of a short meeting and went to my desk to see what important e-mail messages I might had missed. In my inbox was a series of messages sent from ELM Enterprise Manager 3.0, the software we use to monitor our SQL Server event logs. The message had arrived about 30 minutes earlier, when I was away from my desk.

Learn About SQL Server Disaster Recovery from Greg Robidoux of Edgewood Solutions

Disaster recovery is a topic on the minds of many DBAs. Learn some of the basics about SQL Server disaster recovery from a leading expert in the area, Greg Robidoux of Edgewood Solutions. Greg is currently the Vice Chair for the PASS DBA Special Interest Group (SIG). In addition, he recently gave two presentations at the PASS Summit in Seattle on Change Management and Project Management for DBAs.

How to Upgrade a SQL Server 7.0 Cluster to a SQL Server 2000 Cluster

Every time I have to perform some major work on my production SQL Server clusters, I spend a lot of time researching and planning the task at hand. And when it comes to something as big as an upgrade from a SQL Server 7.0 Cluster to a SQL Server 2000 cluster, I even spend more time than usual. I can’t afford for mistakes on a server that needs to be up 24/7.

SQL Server 2000 Table Hints

As you advance in your skills as a Transact-SQL developer or SQL Server database administrator there will come a time when you need to override SQL Server’s locking scheme and force a particular range of locks on a table. Transact-SQL provides you with a set of table-level locking hints that you can use with SELECT, INSERT, UPDATE, and DELETE statements to tell SQL Server how you want it to lock the table by overriding any other system-wide or transactional isolation level.

Auditing Your SQL Server Environment Part II – Reviewing your Role Membership

Over the last few years I have been a roving SQL Server DBA contractor and tended to work contacts in small and mid-size companies that involved organizing, documenting and then tuning/optimizing existing SQL Servers in those companies. I have noticed one very disturbing truth over the years; no one seems to document anything. In fact, I was usually thankful if I could find something or someone who knew the sa passwords on each SQL Server installation, let alone knew anything else about their setups.

Inputting A Text File Into SQL Server Using T-SQL

Question: Is it possible to input a text file into SQL Server using T-SQL?

SQL Server Startup Parameters

Every now and then we all have to reread something we may already know because frankly if you are like me, you can’t keep everything in your head. I tend to go back over tips and tricks and even database concepts when I have time so I will maybe remember enough about it so when a problem arises I at least know where to go look and find the answer. It is with, that I want to write about my latest re-education attempt.

Auditing Your SQL Server Environment Part I

Over the last few years I have been a roving SQL Server DBA contractor and tended to work contacts in small and mid-size companies that involved organizing, documenting and then tuning/optimizing existing SQL Servers in those companies. I have noticed one very disturbing truth over the years; no one seems to document anything. In fact, I was usually thankful if I could find something or someone who knew the sa passwords on each SQL Server installation, let alone knew anything else about their setups.

A Simple Web Search Engine

Every user expects a search engine on any Web site they visit. Unfortunately, search engines are extremely complex to develop. They require massive amounts of resources and time to implement. Today I’ll show you how to use a MySQL (or any SQL database) to create your own basic search engine.

Introduction to Relational Database Systems
· 1

If you collect and use any kind of data you probably have some kind of organizing system. Whether you use index cards, a filing cabinet, Excel spreadsheets, or some kind of database program, your system should let you add and change data, delete data, and retrieve data, and it should work faster and more efficiently than if you had to do it by hand.

Transact-SQL Programming – Sample Chapter 1

Transact-SQL, an extension to the SQL database programming language, is a powerful language offering many features–a wide variety of datatypes, temporary objects, system and extended stored procedures, scrollable cursors, conditional processing, transaction control, exception and error handling, and much more. We’ll introduce those features later in this chapter in the section “What is Transact-SQL?” Before getting to Transact-SQL specifics, however, we’ll provide some background information that will help you get a feel for the overall database environment in which Transact-SQL operates. After we explain the basic differences between ANSI SQL and Transact-SQL, we’ll jump back to more generalized topics. We’ll cover the genesis of the relational database model and its impact on SQL programming languages. We’ll talk a bit about normalizing data and introduce you to the idea of row-processing and set-processing information technology. We’ll spend a little time talking about the history of SQL Server in general. Finally, we’ll introduce many of the features of the Transact-SQL programming language itself.

SQL Errors 101

Many programmers hit a brick wall in their SQL queries, slowing development to a crawl and causing an over abundance of hair loss and coffee consumption. If you have been staring at the screen with a blank look and a pounding heart, wondering what you did to deserve this mess, you have come to the right place. In this article I will unveil the six most common SQL query errors and give you tips on stress prevention.

Lee Gould Answers MS SQL Server, Sybase, and Oracle Questions

Are you at odds with your database? Database programming expert Lee Gould can help.

Monique Angelich Answers SQL and Web Programming Questions
· 1

Are you stuck on a SQL query that just won’t return the results you are looking for? Is a piece of HTML coding just not behaving well in Netscape? Does your JavaScript call you nasty names when you try to run it? Are you trying to write a complex ASP script that simply will NOT do what it is told?

SQL Server 2000, XML and XSL: The Ultimate Combination

All the hype that once surrounded XML is finally starting to die down, and developers are really beginning to harness the power and flexibility of the language.

Securing SQL Server

In late January, a worm called SQL Slammer shut down a Bank of America ATM network, Continental Airlines’ online ticketing system, and an emergency call center in Seattle as well as cutting off Internet access for millions of PC users worldwide.

Microsoft Releases 64-bit SQL Database

Microsoft Corp. has released a 64-bit database and claims that the new system features performance rivaling that of Unix-based systems yet offers greater ease of use and at a lower cost.

Using PL/SQL Records in SQL Statements

A PL/SQL RECORD is a composite datatype. In contrast to a scalar datatype like NUMBER, a record is composed of multiple pieces of information, called fields. Records can be declared using relational tables or explicit cursors as “templates” with the %ROWTYPEdeclaration attribute.

MS SQL Server undercuts competition

When Microsoft launches its 64-bit version of SQL Server at the end of April, the database will cost the same as the 32-bit version, perform better, and be part of the company’s bid to oust Oracle and IBM’s DB/2 on high-end systems.