Following on from yesterdays blog I was wondering about the comparison of objects that were the same and how the IgnoreWhitespace, IgnoreComments, IgnoreKeywordCasing and IgnoreSemiColonsBetweenStatements flags affected the comparison....
2017-03-02
11 reads
Following on from yesterdays blog I was wondering about the comparison of objects that were the same and how the...
2017-03-02
44 reads
Log shipping provides a means to maintain a secondary server on an automated basis
using a chain of transaction log backups....
2017-03-02
21,635 reads
Log shipping provides a means to maintain a secondary server on an automated basisusing a chain of transaction log backups. This chapter explains the basic confi guration oflog shipping...
2017-03-02
10 reads
A nice little error log feature that I noticed in SQL Server 2016 regarding tempdb. Tempdb, a system database in...
2017-03-02
405 reads
I am resuming technical blogging after a gap of nearly a month. I will continue to blog my re learning...
2017-03-02 (first published: 2017-02-27)
2,516 reads
J.C. Penney is one of the oldest and most storied retailers still in existence in the United States. For years,...
2017-03-02
379 reads
I’ve been working with containers for a while now and one of the questions that always gets asked when I...
2017-03-01
1,998 reads
I see a lot of confusion when it comes to Azure Data Factory (ADF) and how it compares to SSIS....
2017-03-01
447 reads
One of the most common ways to get an event notification is by email. So what happens when you get...
2017-03-01
384 reads
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...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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