Examing database shared locks using sys.dm_tran_locks
If you’ve worked with Microsoft SQL Server for any length of time, you’re probably already aware that SQL Server uses...
2009-08-25
684 reads
If you’ve worked with Microsoft SQL Server for any length of time, you’re probably already aware that SQL Server uses...
2009-08-25
684 reads
I’ve been reading his blog for a while and getting consistently good value. I’d categorize it as a SQL blog...
2009-08-25
718 reads
Last but certainly not least we’ve just announced Kalen Delaney as a member of the Advisory Council. Now that we...
2009-08-25
570 reads
Well, three chapters. The latest book I worked on is up at Apress. I only have three chapters in this...
2009-08-25
561 reads
I think the Professional Association of SQL Server users (PASS) is an extremely important organization for SQL Server DBA’s. Even...
2009-08-25
663 reads
Well I feel a little strange making an announcement about this since I'm not running. A number of people have...
2009-08-25
1,618 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-08-25
534 reads
As part of my professional development and to help raise my professional profile, I have become more involved with my...
2009-08-25
611 reads
Image a full day of SQL Server and BI training. Even better yet, a full day of FREE training. Well PASS (Professional...
2009-08-24
537 reads
I really enjoy reading technical articles. They often enlighten me on new technologies or provide me with a new way...
2009-08-24
945 reads
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item 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