Quick Editing Tips (Day 23)

There are many editing items in SSMS that makes formatting and navigating your code easier than ever. Most of these...

Using dbatools to verify your SQL Server instances version compliance

One of the main DBA's duties is to guarantee that SQL Server instances are up-to-date in terms of patches (Service...

When it’s cold outside, perhaps Power BI heat maps can warm you up

(2018-Jan-13) You never know how the weather will behave itself, especially when the temperature gets dramatically changed from +10 to -10...

You Need a New Hobby

Not sure who this is that is attempting to hack into my blog so desperately, but seriously, time for a...

Alwayson Availability Groups vs Alwayson Failover Cluster Instances

SQL Server is one of the finest database management system deployed by organizations for storing and retrieving their data. It...

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...