SQL Saturday #21
I presented a 1 hr session at SQL Saturday #21 session SQL Server PowerShell Extensions: In this sesssion we will...
2009-10-18
394 reads
Blog Posts
Post SQL Saturday #21 Orlando
Today I gave a two part session at SQL Saturday in Orlando. When originally planning this years event Andy Warren said many people who...
2009-10-17
1,323 reads
Backing Up Your Data is Obvious, Or Isn’t It?
Often, when I give presentations on DBA best practices, I make the obvious point that databases need to be regularly...
2009-10-16
490 reads
Dev Days
I heard about the Stackoverflow Dev Days earlier this year and thought it was an interesting idea. We had talked...
2009-10-16
1,156 reads
Free E-Book on XSD SQL Server Schema Collections
Whether you like it or not, as a SQL Server DBA or Developer, you will eventually have to learn about...
2009-10-16
555 reads
PASS Board of Directors Debate - Transparency and Vision
There is an amazing debate occurring on Brent Ozar's blog where he interviewed Matt Morollo. Being a little out of...
2009-10-16
1,377 reads
Shipping
I've got a conference to attend in a few weeks, and needed to get some things out the door. Every...
2009-10-16
633 reads
SQLSaturday #21 Shirt Snafu!
Thought I’d share a funny story. Way back before SQLSaturday #1 my friend Shawn recommended a local shirt/embroidery vendor, I...
2009-10-16
496 reads
Table Variable and Temp Table
Today I come across the great blog by Wayne Sheffield on Sqlservercentral.com about temp table and table variable so I...
2009-10-16
578 reads
Vetting the PASS Board of Directors candidates
I've had a pretty heavy involvement in Brent Ozar's interview of Matt Morollo. The reason for my intense activity is he was...
2009-10-16
1,360 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