Pragmatic Works Foundation Class Introduction
You may have noticed a flux of new blog post entires yesterday from a group of people talking about the...
2010-02-09
804 reads
Blog Posts
Relationships
This month Rob Farley is hosting TSQL-Tuesday #3. The topic is Relationships and he has left it wide open for...
2010-02-09
881 reads
Relationships - T-SQL Tuesday #3
I missed T-SQL Tuesday #1, but participated in T-SQL Tuesday #2. Now it's time for #3, and I'm making my...
2010-02-09
3,377 reads
Round Two of Insert Benchmark Tests
After seemingly exhausting my physical file layout and instance configuration options in Round One of testing, I decided to “throw...
2010-02-09
527 reads
Speaking at the Rocky Mountain Tech Trifecta on February 27
I will be giving my Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With...
2010-02-09
503 reads
SQL Server Useful Reading
I have been having an IO subsystem issue recently and I found the whitepapers very useful and wanted to post...
2010-02-09
783 reads
What is SQL Server? – Rocky Mountain Tech Trifecta
I’m doing a basic presentation at the Rocky Mountain Tech Trifecta later this month on what SQL Server is from...
2010-02-09
428 reads
Who Would You Like To See as a PASS Summit Keynote Speaker?
Note: These are my opinions and don’t reflect the official views of PASS, just my thoughts!
I’ve been to every PASS...
2010-02-09
455 reads
Attending SQLSaturday #33 in Charlotte, NC
Just booked the travel, going up the afternoon of March 5th and returning on an early evening flight on the...
2010-02-08
340 reads
I've been published on Simple-Talk.
I am excited to say I have been published on Simple-Talk. This was my first foray into being professionally edited. I...
2010-02-08
328 reads
Blogs
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...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
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