(Pinal Dave) On Random basis, I do get some emails and comments on my blog which makes me do some research and write more blogs to share my thoughts and findings. This blog is an outcome of one such email communication with a user. Let us learn about missing columns in SSMS.

(Ahmad Yaseen) During your experience as a SQL Server Database Administrator, you may work with applications that store data as comma-separated values in a single column. To deal with this de-normalized data, you may need to normalize it to work with each single value separately in your SQL Server c

(Michael Otey) SQL Server 2017 adds support for Linux and a variety of other new features that could justify upgrades to the revamped database platform, even coming so soon after the 2016 release.

(Kenneth Fisher) Ever have this conversation?

(Marcin Policht) Deploying Infrastructure as a Service (IaaS) solutions in Microsoft Azure offers a number of benefits that leverage agility, resiliency, and scalability built into the underlying platform.

(Pinal Dave) There are many rules in SQL Server setup which are checked to make sure that the user is not seeing failure at the end of the installation. Most of the rules are generally passed, but few of them are known to generate warnings. One of such rule is Microsoft .NET Application Security whi

(Michael J. Swart) We encountered a CPU issue which took over a month to understand and fix. Since then, it’s been another couple months and so I think it may be time for a debrief.

(Holger Linke) For migrating databases from an on-premise SQL Server to Azure SQL Database, Transactional Replication has become more and more popular. This approach has some important advantages: you may maintain a live copy of your production data in Azure SQL Database, and reduce the downtime for

(Tim Smith) We have a set of live data that frequently changes, even though there isn’t many data points and we had developers introduce other architectural layers, like caching mechanisms, but these introduced new bugs we hadn’t seen before their introduction.

(Kenneth Fisher) Looking at what a job has been doing is important. Particularly if something is going wrong. Now there are several ways to do this depending on your preference. You can use the system views.