Another Reason To Install Service Pack 1 CU3 on SQL Server 2008
Microsoft has a new KB article describing a problem where the MAXDOP setting that you specify (whether at the instance...
2009-08-04
815 reads
Blog Posts
Disaster Recovery Scenarios with HP Data Protector
Let's say it is a late Monday morning, because something always comes up before you are required at your vocation,...
2009-08-04
7,935 reads
Looking for Good (and Bad) SQL Server Blogs
I was asked to do an hour presentation during the 24 Hours of PASS, which takes place on Sept 2,...
2009-08-04
514 reads
Relocating oPASS
I mentioned last week about closing down sqlgroups.com and trying to decide on a new home for oPASS.org. We did...
2009-08-04
358 reads
Second SW Florida .Net Code Camp Announced for Oct 3, 2009
John Dunagan is the “Chief Organizer” of this event on October 3rd in Estero, FL, just south of Ft Myers....
2009-08-04
327 reads
SQL Bloggers, Make Yourself Known
Are you an active SQL Server blogger? Do you blog regularly about the greatest database technology available? If so, you...
2009-08-04
629 reads
SQL Saturday - Top 5 Suggestions from the Attendees
After spending much of the last two days reading through over 200 SQL Saturday Event Evaluations I have come up...
2009-08-04
847 reads
Why Does Code Outlining In SSMS Only Work When Connected To SQL 2008?
Code Outlining has been part of Visual Studio since VS.NET 2002. If you're not familiar with it, code outlining is...
2009-08-04
465 reads
24 Hours of PASS
I’m fairly certain Jack Bauer isn’t involved with this new initiative from PASS. Just as I’m also certain I won’t...
2009-08-03
734 reads
Active August
One of the bloggers here at SQLServerCentral (and a good friend) posted a note about Active August
last week. In the...
2009-08-03
393 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers