Fun With SQL Azure
Pinal Dave had a helpful post a few days ago about how to setup and configure SQL Azure. You will...
2009-12-03
1,375 reads
Blog Posts
Fundamentals of Storage Systems – Disk Controllers, Host Bus Adapters, and Interfaces
We have covered the Hard Disk and the System Bus. This time around we will cover disk controllers and host...
2009-12-03
6,472 reads
MDX Utility Belt of Calculations Part 3
This is part three in a series of blog posts that will help you build an arsenal of MDX calculations...
2009-12-03
1,770 reads
Thanksgiving Review
Last week I posted about planning to cook some for Thanksgiving, thought this week I’d share some of how it...
2009-12-03
469 reads
Transactional Replication Conversations –Must read
Everyone who wants to know about how transaction replication works and how to improve the performance of transaction replication must...
2009-12-03
2,146 reads
You pulled BUILTIN\Administrators, but are you auditing?
The conversation on local administrators having rights in SQL Server has proven to be interesting and at times entertaining. My...
2009-12-03
2,530 reads
Another Update on SQLSaturday
I’ve fallen behind a little on sharing SQLSaturday news, so I’ll try to catch up on the latest. First, we’re...
2009-12-02
486 reads
Authors Needed for the SQL Server Standard (PASS) & Almost Engraved Invitations
SQL Server Standard editor Grant Fritchey needs more content! We’ve got about three done and three more in the pipeline,...
2009-12-02
952 reads
Dr. DeWitt’s Key Note at the PASS Summit
If you missed this, here’s your chance to make it up. If you were there, and like me, you need...
2009-12-02
714 reads
Explain it to yourself
I found a nice post from a friend, Roy Ernest, on an effective way to learn. He notes that one...
2009-12-02
672 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