Scripting Indexes
I was recently reading a blog posting on BIDN, Scripting Indexes with Filters and schemas.In the posting the author explained...
2010-01-15
1,457 reads
Blog Posts
SQL Lunch #8 recording
If you weren't able to attend tuesday for SQL Lunch you can watch the recording now mosted on the website. ...
2010-01-15
581 reads
SQL Lunch #8 recording
If you weren't able to attend tuesday for SQL Lunch you can watch the recording now mosted on the website. ...
2010-01-15
602 reads
SQL Server Waits and Queues
Recently, I was asked to do an extensive sql server performance audit and review. I will be sharing some of...
2010-01-15
9,688 reads
SQLServerCentral
My boss gave me an assignment, asking for 200 words on the history of SQLServerCentral. This is what I came...
2010-01-15
1,465 reads
Too Much Data – Idiocracy or Star Trek?
I used to think that too much data was never a bad thing. That having more information out there is...
2010-01-15
928 reads
Using Synthetic Benchmarks To Help Evaluate Database Server Hardware Choices
As a DBA, I think it is very important to stay current on trends in x64 based hardware. The DBA...
2010-01-15
734 reads
Vancouver’s Winter Olympics Less Than 30 Days to Go (!) – But Not Without Issues
There are some Februarys in Vancouver, while growing up, when I can remember wearing shorts and watching plants flowering, therefore with...
2010-01-15
640 reads
Book #9 - Dearly Devoted Dexter
The second in the Dexter series, Dearly Devoted Dexter starts out with him stalking in the bushes. It’s a well...
2010-01-14
834 reads
Broadcasting OPASS over Live Meeting
Well, on January 12th OPASS moved into the present by broadcasting our meeting over the internet using Live Meeting. Our...
2010-01-14
479 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