BLOG

See what we are up to

Create a Login in a SQL Server Availability Group

Situation In SQL Server Availability Groups (AG), Logins must have the same SID (Security identifier) on all the nodes where they use the AG databases. An Availability Group consists of (at least) 2 different SQL Servers: [caption id="attachment_585" align="alignnone" width="3264"] Availabili

Read more

VBA script reads outlook mailbox

In one of our projects we needed to analyze email stored in outlook or office365 mailbox. We have written this utility in VBA that helped us do the job. [caption id="attachment_418" align="alignnone" width="406"] Excel sample[/caption] Download this macro enabled spreadsheet: InboxCalculatorV3

Read more

Stretch database to cloud.

Microsoft Azure stretch database     Purpose   Information regarding the new feature in SQL Server 2016. Reading time +/- 20 minutes   References Microsoft documentation: https://docs.microsoft.com/en-us/ Contents What is a stretch database? When sho

Read more

Why do you want to use SQL Service Broker

Why use SQL Service Broker It enables you to execute SQL Statements faster and do the real work later. SQL Server is using Service broker for its builtin Mail components since SQL Server 2015. Asynchronous SQL Server statements are synchronous, 1 statement after another. Each statement waits unt

Read more