(Pinal Dave) Many people ask me how is the life as a freelancer, as a consultant? My answer is “life is good, but to get the complete picture, you have to experience it”.

(Jack Vamvas) Question: I’m just investigating a SQL Server Agent Job failure and noticed there were no records in the SQL Server Agent history log.

(Tim Radney) Azure SQL Database currently has three service tiers to choose from for your workload. These tiers consist of Basic, Standard, and Premium. Basic supports only one size of 5 DTUs. Premium starts at 125 DTUs and goes up to 4,000 DTUs.

(Tejas Shah) The title of the blog may throw someone off a little. After all, SQL Server is not a centennial app and the error message doesn’t appear to have anything to do with SQL Server. So please bear with us while the whole scenario is explained.

(Koen Verbeeck) With the release of SQL Server 2017, a couple of new enhancements have been introduced for Analysis Services Tabular. One of those improvements is the ability to specify an encoding hint for certain columns.

(Kenneth Fisher) SQL Server login ids may not be the most secure thing in the world but they are likely to be around for quite a while and one of the more common uses of them is as an application id.

(Michael J. Swart) Recently I tackled an issue where a DateTime field was getting updated too often. The query looked something like this:

(Anoop Kumar) In a previous article we discussed Data Migration Assistant (DMA) and how DMA can help in migrating an older version of SQL Server to SQL Server 2017.

(Pinal Dave) One of my clients was using Always On availability group. They were having 3 nodes Always On AG setup. For simplicity, let’s call them Node1, Node2 and Node3. The first two nodes were in one subnet and node3 was in separate subnet. Let us learn about availability group failover.

(Jason Brimhall) One good database maintenance practice is to keep the indexes in good working order. This is typically done via index defragmentation routines.