Test the SQL Server database collation with PowerShell and dbatools

If your server collation is different to your database collation then you may find that you get an error similar...

How to Become a SQL Server Database Administrator

I wrote How to Become a SQL Server Database Administrator (email address required for download) a few years ago as a project...

Olcot and Arratoon Ancestry

I have spent a fair amount of time researching the Olcot and Arratoon ancestry and I am very interested in the family tree, especially pre 1900 in India. If...

Tuga IT 2017 Tickets are on sale

I am glad to announce thatTuga IT 2017 Tickets are finally on sale!

Wait a second, you might think – on sale?...

Monday Coffee 2017-04-03

Last week Pass announced changes to how speakers are going to be selected for their annual conference (you can read...

Monday Coffee 2017-04-03

Last week Pass announced changes to how speakers are going to be selected for their annual conference (you can read...

Preconference Session at SQL Nexus – SQL Server Virtualization

If you are attending this year’s SQL Nexus conference in Copenhagen, Denmark, from May 1st to 3rd this year, I...

Custom Handling Flat File Output of an SSIS Package with the Script Component

I recently had a requirement to remove the last Carriage Return <CR> and Line Feed <LF> characters when outputting a...

Can I tune the tempDB of an Azure based SQL Server database…

Yip. You can.
I was originally going to write this post about tuning tempDB in our Azure SQL database. Which would...

Columnstore Indexes – part 101 (“Estimated? Similar! Similar How?”)

Continuation from the previous 100 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost will focus on warning you...