35K
Microsoft's new server lab building will house 35,000 servers. That's a lot of computing power, and it's being done in a greener fashion.
Changing Usernames
SQLServerCentral is changing usernames for some of our members in an effort to clean things up. Read more about what will be happening on Tuesday, Sept. 15, 2009.
Don't Build a Monitoring System
Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.
T-SQL Challenge #1
Do you want to improve your T-SQL skills? MVP Jacob Sebastian runs regular challenges to get you to think about how to solve a problem in T-SQL. These run monthly and we have a summary and explanation from challenge #1 to help you learn more about moving data from 3 tables into a specific format.
Disaster Recovery for SQL Server Databases
High-Availability depends on how quickly you can recover a production system after an incident that has caused a failure. This requires planning, and documentation. If you get a Disaster Recovery Plan wrong, it can make an incident into a catastrophe for the business. Hugo Shebbeare discusses some essentials, describes a typical system, and provides sample documentation.
Don't Build a Monitoring System
Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.
Don't Build a Monitoring System
Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.
Don't Build a Monitoring System
Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.
SQL Server 7.0 – Transaction Log Not Backing Up
I have not worked with SQL Server 7.0 in a loooong time. So when I received a call from a...
A Function Gotcha with the Use of an Asterisk
This article describes and demonstrates the problem of using asterisk to select all fields from a table within a table function. (from Apr 2008)
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers