Administration

SQLServerCentral Article

Maximum Capacity Specifications in SQL Server 2005

  • Article

SQL Server 2005, the next evolution of SQL Server, should be growing the capacities as well as the capabilities of the product. With some research, Steve Jones brings you the best current information he could find about SQL Server 2005, comared with the SQL Server 7 and 2000 values.

5 (3)

You rated this post out of 5. Change rating

2007-01-26 (first published: )

41,894 reads

SQLServerCentral Article

Identifying Blocking Locks

  • Article

Blocks in SQL Server can cause untold amounts of pain and headache, mostly because they are so transient and often when you go to look for them, they have been released on whatever object you are researching. Author Eli Leiba has writeen a short piece on how you can automate the search for blocking locks and help you as a DBA be proactive in identifying them.

2 (1)

You rated this post out of 5. Change rating

2004-10-28

12,399 reads

SQLServerCentral Article

Controlling SQL Server Settings

  • Article

Change control in SQL Server isn't the strong point of the product. And change control of server based settings is something that you might not worry about, but which can easily cause you hours of troubleshooting time. Author Andre Vigneau deploys software to other companies and has developed a solution to deal with this problem. Read on and get some code that can help you prevent or at least fix any changes to SQL Server sp_configure parameters.

5 (1)

You rated this post out of 5. Change rating

2004-10-26

11,374 reads

SQLServerCentral Article

Exploring SQL Server 2000 Configuration Properties

  • Article

The SQL Server tools are top notch and often other platforms attempt to duplicate their handiness. Enterprise Manager is one that every DBA uses and it can perform a myriad of functions to configure your server. Read this new article by Dale Elizabeth Corey that looks that the wide range of items in the Configuration Properties of this tool.

5 (5)

You rated this post out of 5. Change rating

2007-10-02 (first published: )

40,355 reads

Blogs

Query Intelligence in SQL Server 2025: What Developers Need to Know

By

When Microsoft announced SQL Server 2025, I was curious about what would truly change...

Finding and Killing Blockers with Redgate AI Tech

By

Redgate has a research arm, called the Foundry, that has been experimenting with AIs...

Back at Small Data SF in 2025

By

Today I’m in San Francisco at Small Data SF 2025. I went to the...

Read the latest Blogs

Forums

Distributed Availability Group Issue / Misunderstanding.

By goodtimecharlie

Not sure if this is a tech mistake I've made or a lack of...

Large posts full of code not allowed anymore?

By Lowell

Several times now, I've seen a post asking for a solution. I've replied, and...

Data > Hype

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Data > Hype

Visit the forum

Question of the Day

Slipstream parameters

What parameters are needed to enable a slipstream installation for setup.exe (SQL Server setup)?

See possible answers