Stupid DBA Tricks
Well, I just learned a valuable lesson about something you should not do as a DBA…
About a month ago, a...
2009-10-04
4,340 reads
Blog Posts
Pitching in at SQL University
Jorge Segarra (@SQLChicken) has put together an idea to have on-line basic lessons on SQL Server called SQL University. The idea...
2009-10-03
1,125 reads
Red Gate's SQL Data Generator
I'm reading SQL Server MVP John Magnabosco's new e-book, Protecting SQL Server Data, and he includes a database schema to...
2009-10-03
3,036 reads
Southwest Florida Code Camp II
I presented a Powershel session at the SW Florida .Net Code Camp IIl. The session demonstrated the following uses cases for...
2009-10-03
530 reads
Choosing a career path; which way do I go?
“Should I get an MBA or an MCSE?” What an odd question. At least these days it seems odd. But,...
2009-10-02
301 reads
Editorial on the Incidental DBA
You can read the full text of it in today’s SSC Newsletter, the quick summary is that for many businesses...
2009-10-02
255 reads
Free Stuff and a SQL Server Standard Update
Great news. We’ve managed to get one article all the way through the process. We’ll have our first publication out...
2009-10-02
717 reads
Installer Cache – C:\Windows\Installer
Over the past few months I have been upgrading most of my SQL Server Reporting Services (SSRS) 2005 installs to...
2009-10-02
572 reads
MVP Again
It was nice to work through my email and find a bit of positive news instead of more work! I’m...
2009-10-02
391 reads
Perth .NET Users Group First Stop of Down Under Tour
As the first stop of my five city speaking tour of Australia, I spoke at the Perth .NET Users Group...
2009-10-02
478 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