Continuation from the previous 90 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Given the improvements and the availability of...
2016-11-20
618 reads
Warning! If you have added custom indexes to the VMware vCenter database, you will need to remove them completely before...
2016-11-20
625 reads
Recently, after an security fix GDR (https://support.microsoft.com/en-us/kb/3194716) on SQL Server 2016 RTM, SQL Service refused to start. Though, the patch...
2016-11-20
1,183 reads
Microsoft just announced Microsoft SQL Server 2016 Service Pack 1 (SP1)
Microsoft reference: [Click Here]
Ganapathi varma ChekuriLead SQL DBA, MCPLinkedin
2016-11-19
253 reads
Change is inevitable, it's natural. I would like to quote few lines from Shrimad Bhagavad Gita says Change is the...
2016-11-19
433 reads
Steve Jones wrote a great article on using this automation here titled The Demo Setup-Attaching Databases with Powershell. I threw...
2016-11-18
1,082 reads
Different people approach their career in different ways. My working assumption, all the time, is that I don’t know enough...
2016-11-18
432 reads
Background
We have recently been working on large data migration project for one of our clients and thought I would share...
2016-11-18 (first published: 2016-11-14)
1,437 reads
Another week almost over so in-between daydreaming about relaxing this weekend I’ll be reading…
https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released/
SQL Server 2016 SP1 has been released....
2016-11-18
412 reads
After the MVP Summit, I was excited to check out more code and features in all aspects of SQL Server,...
2016-11-18 (first published: 2016-11-14)
1,875 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