Best Thing I Learned at PASS
At the 2003 PASS Summit in Seattle the organization had a "SIG Challenge" that involved developing a database solution to...
2009-06-29
1,369 reads
Blog Posts
Featured Blog: Jeremiah Peschka
I met Jeremiah at the PASS Summit last year and since then I’ve looked in on his blog from time...
2009-06-29
1,697 reads
SQL Saturday #17 - Abstract Submitted
I was asked to attend SQLSaturday #17 in Baton Rouge, LA. Despite my lack of desire to travel, I've never...
2009-06-29
1,518 reads
LinkedIn Groups
I’ve written a few posts now about LinkedIn, and for now still find it be the best fit for me...
2009-06-28
1,556 reads
SQLPSX Release 1.6
I completed Release 1.6 of SQLPSX which adds support for SQL Authentication and addresses several issues. SQLPSX consists of 106 functions,...
2009-06-28
1,612 reads
Incorporating Kids Into Work
I recently attended SQL Saturday #14 in Pensacola and took my daughter along. This was the third presentation she's come...
2009-06-26
1,474 reads
Presentation materials: Intro to Analysis Services (SSAS)
I did a presentation last week for the Denver SQL Server User Group (www.DenverSQL.org) and the Colorado Springs SQL Server User Group...
2009-06-26
1,514 reads
An Android Update - TMobile G1
I still love my G1, and I got a pleasant surprise recently. I was out at dinner with my wife,...
2009-06-25
1,485 reads
Exceptional DBA Award Entries Must Be In By July 10, 2009
If you have been considering entering yourself in the Exceptional DBA Awards this year, or nominating a DBA you know,...
2009-06-25
1,596 reads
How to Avoid Database Restore Issues by a Simple Script Edit - A DB Restore Work-around
During the process of applying changes to a production database - let's call it Change Management (pick your ITIL or COBIT...
2009-06-25
2,664 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