Access to SQL Server is finally coming

Imagine a world where one of the software giants releases their brand new operating system and a new application architecture...

Friday Reading 2017-06-09

Exciting day today as I’m presenting my first webinar on SQL Server & Containers in the GroupBy June conference! There’s a...

SQL Azure Databases - Active Secondary - Failover - Part 3

Continuing on the series on SQL Azure Databases - Active Secondary, this post will explore the task of failing over to secondary.

Fairly straightforward task, just one needs to take...

SQL Azure Databases - Active Secondary - Failover - Part 3

Continuing on the series on SQL Azure Databases - Active Secondary, this post will explore the task of failing over to secondary.

Fairly straightforward task, just one needs to take...

SQL Azure Databases - Active Secondary - Failover - Part 3

Continuing on the series on SQL Azure Databases - Active Secondary, this post will explore the task of failing over to...

Sync SQL Logins and Jobs

In this post I’ll point you to some options to sync SQL logins and then I’ll demo my favorite option...

Sync SQL Logins and Jobs

In this post I’ll point you to some options to sync SQL logins and then I’ll demo my favorite option...

Time saving trick for PowerShell and CMD

Real quick and simple post for today. Having grown up with a computer since the 80’s, I can tell you...

Top string functions in SQL Server 2017

SQL Server 2017 has been in the talk for its many features that simplify a developer’s life. With the previous...

SSIS To SqlServer DataTypes

SSIS Data TypeSSIS ExpressionSQL Serversingle-byte signed integer(DT_I1)
two-byte signed integer(DT_I2)smallintfour-byte signed integer(DT_I4)inteight-byte signed integer(DT_I8)bigintsingle-byte unsigned integer(DT_UI1)tinyinttwo-byte unsigned integer(DT_UI2)
four-byte unsigned integer(DT_UI4)
eight-byte unsigned...