Recap of April 2010 DMV a Day Series
Well, I managed to finish up my series that featured a DMV query every day during the month of April....
2010-05-03
2,905 reads
Blog Posts
Register For 24 Hours of PASS Event
The free 24 Hours of PASS event will be held on May 19-20, and includes 24 different one hour presentations...
2010-05-03
536 reads
SQL Server Monitoring Checklist
I have worked with a lot of organizations who just have just a small handful of SQL Server instances. In...
2010-05-03
3,043 reads
Table Sizes
In SQL Server there are two stored procedures that help one to determine the size of a table. One is...
2010-05-03
870 reads
Upcoming Presentation for Professional Development Chapter
I’ll be presenting “Building a Comprehensive Professional Development Plan” on May 13th via Livemeeting to members of the PASS Professional...
2010-05-03
691 reads
What is a Good Way to Get the SQL Server Log Directory?
Introduction
Today’s post is going to be a quick one to get back in the saddle again. I have been on...
2010-05-03
415 reads
When Did SQL Server Restart?
I saw Joe Webb’s post, and then Gethryn Ellis’ post as well on when SQL Server last restarted. It’s something...
2010-05-03
450 reads
SQL Server 2008(R2) and Win Server 2008 R2 Core Edition
The WinServer 2008 Core Edition was the server that you cannot install the SQL Server 2008. The Win Server 2008...
2010-05-02
1,513 reads
SQLSaturday #39 NYC Presentations available online....
SQLSaturday #39 NYC Presentations available online....
If you were at SQLSaturday in NYC and want to see it again, or, you...
2010-05-02
956 reads
With Great Advice Comes Great Responsibility
I know that you have seen it yourself too. That forum or blog post that contains “advice” that is daft,...
2010-05-02
571 reads
Blogs
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...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
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