SQL Server Articles

Categories : Performance | Audit | Business Intelligence | Clustering | Developer | Reporting | Windows Server | SQL Azure | Powershell | ASP.NET | Other .NET

Using AWE Memory in SQL Server 2000

If you are using SQL Server 2000 Standard Edition under Windows NT 4.0 or Windows 2000 (any version), or are running SQL Server 2000 Enterprise Edition under Windows NT 4.0 or Windows 2000 Server, or if your server has 4GB or less of RAM, the “awe enabled” option should always be left to the default […]

Return Values: Getting Something Back from Your SQL Server Stored Procedures

You give so much to your database . . . sometimes you just want something back. What do you give your database?  Plenty. You give it new records (INSERT). You give it changes to existing records (UPDATE/DELETE). Every now and then, you just look around (SELECT). When you do these things, it is often essential […]

How to Implement SQL Server Log Shipping Using Visual Basic

Log Shipping is a Disaster Recovery (DR) tool that provides you the ability to have a readily available “warm backup.” Essentially, should your existing system fail, you have a backup SQL Server and database available to take over with relatively up-to-date information. If your database is critical to your business, such as in a call center, […]

SQL Server Techniques for Creating a Web Reporting Page — Part 1

In this article, I’ll demonstrate how to give web users the ability to search and group data via web reporting pages –- using good old web scripting and SQL Server. No ETL/OLAP tool needed. Before we begin, I need to explain data warehousing. In general, as raw transaction level data accumulates, we summarize the data […]

Achieving Massive Scalability with SQL Server

With each release, Microsoft SQL Server continues to gain in performance and scalability. A little known fact buried under Oracle marketing is that SQL Server’s TPC-C score is now even higher than Oracle’s. However, few other than Microsoft have millions of dollars of hardware needed to generate the 709,220 transactions per minute achieved in the […]

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 […]

SQL Server 2000 Undocumented Stored Procedures

In this article, I want to tell you about some useful undocumented stored procedures shipped with SQL Server 2000. sp_MSget_qualified_name This stored procedure is used to get the qualified name for the given object id. Syntax sp_MSget_qualified_name object_id, qualified_name where object_id - is the object id. object_id is int.qualified_name – is the qualified name of the […]

Microsoft SQL Server & Solid State Accelerators

Solid State Accelerators make it possible for you to give your peripheral storage the speed of memory. Essentially, a Solid State Accelerator is Solid State memory technology with an attitude, which emulates a conventional disk drive or array. It includes a built-in UPS backup system that allows the data to be copied to an available […]

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 […]

Testing SQL Server 2000 Clusters

If you have successfully gotten this far, most likely the SQL Server 2000 cluster is ready to be used. But before I trust any production systems on a new cluster, it is a good idea to test the SQL Server 2000 cluster to see if it is really working as it should. This section takes […]
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 |