24 Hours of PASS: Summit Preview
Registration is open for the second 24 Hours of PASS this year. This one is going to be a preview...
2010-08-11
556 reads
Blog Posts
A Chance to Win a Free Trip to the PASS Summit
Passing along this contest from Idera and MSSQLTips. I don’t do many plugs, but it’s a chance for someone to...
2010-08-11
787 reads
Defensive Db Programming Chapter 04
This week we will be checking out the fourth chapter of this book by Alex. This is a continuous effort...
2010-08-11
743 reads
Logo Selected for SQLRally
Hopefully everyone saw the announcement already, either via the PASS Connector or the Twitter announcement, but we have – finally! – a...
2010-08-11
381 reads
Registration Open for 24 Hours of PASS
The ‘Summit Preview’ edition, this time around it features speakers from the upcoming PASS Summit with each doing a one...
2010-08-11
339 reads
Sharing a Temporary Table
One of the things that I’ve often seen people do is build temp tables to hold data for each connection...
2010-08-11
2,139 reads
Speaking at 24 Hours of PASS on September 15, 2010
I will be one of the presenters for the 3rd installment of the 24 Hours of PASS: Summit Preview, which...
2010-08-11
780 reads
SQL Reporting Services - Line Graph with a Vertical Bar
So, I was recently asked if you could display a vertical bar on a line graph to denote the last...
2010-08-11
3,326 reads
SQL Saturday #48, Come One, Come All
SQL Saturday #48 - Columbia, SC, is a little over 7 weeks away (October 2, 2010), so we're picking up the...
2010-08-11
531 reads
Using the Windows Experience Index as a Shopping Tool
One easy to use and useful tool that you can use to compare relative performance between different machines that are...
2010-08-11
1,514 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