Wildcard – Match One Character using Underscore (_)
I was recently contacted by a developer with what I would consider to be a very simple question. How do...
2009-10-21
2,699 reads
Blog Posts
Yes, I am a square, but not the way my wife thinks.
I’ll be on the Twitter Bingo card along with a lot of other great SQL Server folks at Pass! Quest...
2009-10-21
573 reads
A Week of SQL Server
As anyone who reads this blog knows, SQLSaturday #21 – Orlando was last Saturday (Oct. 17, 2009) and as a lead...
2009-10-20
402 reads
It's NOT TOO LATE to Register....NY/NJ SQLSaturday Event 10.24.09
Hi, all;
The countdown to the NY/NJ SQL Saturday event this upcoming Saturday has begun. And it's NOT TOO LATE to...
2009-10-20
547 reads
Old Inventory
Each year at the PASS Summit I have run a party on opening night. The last 4 or 5 years...
2009-10-20
638 reads
PASS Connector Editorial for October 21, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-10-20
533 reads
PASS Summit – My List of Tips
It’s easy to think of the Summit as just work, but I can tell you that you’ll have more fun...
2009-10-20
675 reads
SQL Server 2005 SP3 CU6 Released
Microsoft released Cumulative Update 6 for SQL Server 2005 SP3 yesterday (and the KB link is working today). This is...
2009-10-20
1,037 reads
Electronic Health Records – What’s the Big Deal? (Part 1)
Last week, I had lunch with an old friend who is, by his own definition, technologically ignorant. While we caught...
2009-10-19
820 reads
Images in your blog
In a recent talk I gave, I recommended using images to spice up your blog. I think it's great, and...
2009-10-19
634 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