Azure VPN – Point to Site IP Addresses

Recently, I got to work with a client on something interesting. We implemented transactional replication to send data to an...

Count_Big() function

Learned new function for count while going through the channel 9 video for salva. where for a very big table...

Introducing: The SQLUndercover Inspector

Introducing: The SQLUndercover Inspector! Finally we have a V1 almost ready to hit our GitHub but what exactly is it?
 

Just another...

Introduction to System-versioned temporal tables – New database feature of SQL Server 2016

System-versioned temporal tables is new database feature of SQL Server 2016. Another improved version of table level auditing with some...

Learn Different Options for Importing Data Into SQL Server

Most of the time users need to import their data into SQL Server for its proper management. Select from the...

Outlining (Day 22)

SSMS supports Outlining, the ability to selective hide blocks of code. This can be very useful, especially when working with...

Outlining (Day 22)

SSMS supports Outlining, the ability to selective hide blocks of code. This can be very useful, especially when working with...

Perfecting my presentations

After a considerable amount of “umming and ahhing” last year I decided to start presenting full hour long sessions. Well,...

What is VMware vSAN?

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...

Configuration Manager Missing - Windows 10

SQL Server Configuration Manager is one of the fundamental tools for a DBA to do basic tasks like starting or stopping SQL Service, knowing how many instances and what...