SQL Server 2011 (Denali) CTP3 Released!
I started this blog a few weeks ago when I heard rumors that CTP3 was coming soon, but figured that...
2011-07-12
953 reads
Blog Posts
SQL Server 2011 CTP3 (Denali) Released
I started this blog a few weeks ago when I heard rumors that CTP3 was coming soon, but figured that...
2011-07-12
1,372 reads
SQL Server Denali CTP3: Policy Based Management
Whether you know it or not, Policy-Based Management is an integral part of the new release of SQL Server “Denali”....
2011-07-12
1,391 reads
SQLDIY: Index Usage Statistics
There are several different aspects of indexes that can be monitored via DMV’s. One the neatest things is just how...
2011-07-12
2,466 reads
SQLSaturday #80 - Wheeling, West Virginia!
Next up, on the super SQLSaturday extravaganza, is SQLSaturday #80, in Wheeling, West Virginia! Wheeling, known as the friendly city,...
2011-07-12
1,003 reads
Subtle Errors When Using Dates-Part 2
It’s so easy to make make mistakes with dates. Here is another one I saw recently, this one used when...
2011-07-12
572 reads
Teaching Transact-SQL at University of Denver, University College
Starting this week on Wednesday night, I will be teaching a special five-week condensed version of ICT 4462, Transact-SQL Programming...
2011-07-12
615 reads
Which database is using all my CPU #2
A few weeks back we wrote about a query to tell you which database is using up most CPU time....
2011-07-12
1,484 reads
2011 SQL Rally Evaluations - Reporting Services Boot Camp
I wrote this early in June, but lost it in my blog pile again and just found it…
First and foremost,...
2011-07-11
411 reads
5 Ways to Be a More Effective DBA Today
Regular readers will now that I like to talk (quite a lot) about how we can be more effective as...
2011-07-11
1,443 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