Traveling More Than Expected
For a guy that was looking to not travel much, it seems that I’ve got way more on my plate...
2012-03-09
1,019 reads
Blog Posts
Why Support WIT
First, only support Women in Technology if you want to. It’s an idea that appeals to some, but not to...
2012-03-09
957 reads
Converting SQL SERVER DateTime? Test it thoroughly….
Today one of my user complained that a report was missing one particular ticket from the output. The report in...
2012-03-08 (first published: 2012-02-28)
4,284 reads
Let’s Talk
I’m travelling to several upcoming events and I’d love to sit down and talk with you. Yes, I get it,...
2012-03-08
871 reads
March 2012 – Monthly SQL Server Checklist
Are your SQL Servers healthy? If the things went south today today, would you be able to say you can...
2012-03-08
1,769 reads
March Madness – SQL Server style
Bodypaint not required
It seems that March is another great month for getting your geek on without having to leave the...
2012-03-08
635 reads
Moving MASTER Database
In my previous post we see how to move MSDB database, today we will see how to move or relocate...
2012-03-08
1,071 reads
SQL Server – netstat monitoring and tuning performance
To display network connections and various network interface statistics – netstat is a handy command – line based tool.
Why is it...
2012-03-08
1,320 reads
What is a Favicon?
If I were to show you the tabs in the following pic without a description, would you recognize the websites to which they belong? I would dare say that...
2012-03-08
4 reads
What is a Favicon?
If I were to show you the tabs in the following pic without a description, would you recognize the websites...
2012-03-08
789 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