SQL Lunch Rescheduled
Due to a few scheduling conflicts the SQL Lunch scheduled for tomorrow as been rescheduled. The event will be on March...
2012-03-14
801 reads
Blog Posts
SQL Saturday 103 Recap
SQL Saturday 103 was in Curacao, a beautiful Dutch Island in the Caribbean. I was fortunate enough to be able...
2012-03-14
624 reads
SQL Server 2012 AlwaysOn & A Thorough Setup
It’s surprisingly easy to set up the new AlwaysOn features. I’ve done it on VMs running on my laptop, from...
2012-03-14 (first published: 2012-03-12)
3,137 reads
SQL Server 2012: Tabular Models vs PowerPivot Models
In SQL Server 2012, there is a new data model, called tabular, that is part of the new feature called the...
2012-03-14
2,769 reads
Table Size and Missing FK Indexes
I am bringing an oldie back with another twist. I recently ran into the need to correlate information between a couple of different queries that I like to use....
2012-03-14
4 reads
Table Size and Missing FK Indexes
I am bringing an oldie back with another twist. I recently ran into the need to correlate information between a...
2012-03-14
1,103 reads
Understanding the concept of SQL Server Failover Cluster
Before getting hands on experience in SQL server on failover cluster , I used to read many article about failover clustering. Unfortunately...
2012-03-14
17,384 reads
A Quick Introduction to Data Compression in SQL Server 2008
There is one thing every DBA knows with certainty, and that is that databases grow with time. MDFs grow, backups...
2012-03-13
2,002 reads
Command Prompt connectivity –U option
When you try to connect to sql server using isql/osql or sqlcmd there are two authentication you can use windows...
2012-03-13
524 reads
DBA supertech . Specialise or generalise?
Specialise or a generalise? It all depends on how you define these terms.
A SQL Server DBA may be considered to...
2012-03-13
746 reads
Blogs
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
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...
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