How Do I Identify Invalid or Unneeded Logins?
Introduction
I was looking at one of my servers and was caught off-guard by how many individual users had been granted...
2010-04-07
525 reads
Blog Posts
How Silly
Have you ever done anything that made you feel like a dunderhead? Maybe a little bone-headed, thick, numb-skullish?
Here is my...
2010-04-07
556 reads
New MSSQLTips Article: Nesting Database Roles in SQL Server
I'm still way behind on my writing for the year, thanks to fighting off stronger than usual migraines and now...
2010-04-07
1,671 reads
SQLSaturday Orlando 2010 - The Planning Begins
Believe it or not, it's already time to start planning for Orlando's next SQLSaturday. Andy Warren and I had our...
2010-04-07
428 reads
Test Driving a LinkedIn Poll
Had this on my list for a while, thinking maybe it’s a way to leverage the investment in my (your)...
2010-04-07
257 reads
Use a Clustered Index
I stumbled across this clustered index test from Hugo Kornelis recently from a post in the forums. I think I’d...
2010-04-07
537 reads
24 Hours of PASS Registration Now Open
Registration for the 24 Hours of PASS is now open. This free, online training event will be held starting 12:00...
2010-04-06
649 reads
24 Hours of PASS v2.0
The kids over at the Professional Association of SQL Server Users have done it again. They’re hosting 24 Hours of...
2010-04-06
712 reads
24 Hours of PASS: Celebrating SQL Server 2008 R2
Well, we finally got the ok to start talking about the second 24 Hours of PASS event, called 24 Hours...
2010-04-06
573 reads
A DMV a Day – Day 6
The DMV for Day 6 is sys.dm_db_index_usage_stats, which is described by BOL as:
Returns counts of different types of index operations...
2010-04-06
855 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