Questions About SQL Server Backups
SQL Server backups are a “funny” topic to talk about. If you are talking with experienced DBAs, the topic of...
2010-02-03
801 reads
Blog Posts
SQLSaturday & PASS – More Details
Yesterday I posted the news that SQLSaturday is now owned by PASS, today I’d like to share a bit of...
2010-02-03
1,095 reads
What Would I Do With a Week?
After my editorial this week on Coding By the Sea, my boss actually pinged me to say that I could...
2010-02-03
388 reads
“Building a Better Blog” with Steve Jones
I recently watched Steve Jones’ (Blog | Twitter) "Building a better blog" presentation from the 24 hours of PASS virtual conference...
2010-02-02
848 reads
Key Discovery III
In Part I and Part II of the series, I discussed documenting and discovering Primary Keys and Clustered Indexes. In...
2010-02-02
1,706 reads
Key Discovery III
Recursively traverse system views to build a Hierarchical Perspective into the database.
Related Posts:
T-SQL Tuesday Participation Over the Years December 19, 2018
T-SQL Tuesday #104: Just Can't Cut That Cord...
2010-02-02
9 reads
PASS Acquires SQLSaturday
I’ll write more about this tomorrow, but for now I’m reposting the release from Rushabh Mehta, President, PASS:
It gives me...
2010-02-02
314 reads
Providing Online Help for Powershell Modules
As a finishing touch for the SQL Server Powershell Extensions 2.0 Release I wanted to provide an online version of...
2010-02-02
2,003 reads
RedGate Releases SQLSearch - FREE!
RedGate Releases SQLSearch - FREE!
SQL Search - Released
My friends at RedGate have released a new FREE Tool. Please read on to learn...
2010-02-02
803 reads
Reflections on ‘Visibility, the Art of Being Noticed’ by Phil Factor
If you have not read the Master of Phrenetic Phoughts’ article, please do so here. I enjoyed very much the...
2010-02-02
966 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