The Build Book of News

Every year Microsoft has held the Build conference for developers. I've been lucky enough to go a few times, and I was hoping to get the chance to attend again. With the pandemic, the entire event went virtual, and was held across 48 continuous hours. I was slightly disappointed as a few sessions I wanted […]

[Video] Free DBA Training Month: Configuring TempDB, Lock Pages in Memory, and the DAC

While you’re stuck inside wondering if you’ll ever be able to attend a user group meeting again, I’m giving you free access to training materials that your boss probably wouldn’t have been nice enough to buy you anyway. So far this week, we’ve covered DBCC CHECKDB, how to set up Ola Hallengren’s maintenance scripts, and restoring for oops deletes. Today, let’s talk about two common configuration issues. Don’t dilly-dally on these though: these blog posts will be online during May only, and they’ll disappear on June 1.

The IDENTITY Column Property

There are a number of ways to generate key values in SQL Server tables including the IDENTITY column property, the NEWID() function and more recently, SEQUENCES. The IDENTITY column property is the earliest of these methods. It was introduced very early in the history of SQL Server and it is arguably the simplest approach. Though old, IDENTITY is still maintained in modern versions of SQL Server and is still relevant for simple use cases.

Blogs

Step By Step Installation of SQL Server 2019 with all features

By

[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please...

Step By Step Installation of SQL Server 2019 with all features

By

[MSSQLFUN & Decote ITeS becomes a family of 1500 individuals across the globe. Please...

When Your Azure Data Catalog App Won’t Connect

By

This year I created a new presentation for introducing Azure Data Catalog.  I love...

Read the latest Blogs

Forums

https //ketomegamar com/vaso-prime-rx/

By lrisyjamtions

Vaso Prime RX Now for your method. Process specific exercises that you perform on...

Avamar Backup--Is it good?

By VastSQL

Dear Experts, is it good to use Avamar backup for SQL Server, currently we...

Read-only

By curious_sqldba

  I read MSFT documentation few times but couldn't find a clear answer. I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers