(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
Tag: sql server
(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.
SQL SERVER – Setup Rule: Microsoft .NET Application Security. The computer cannot access the Internet
(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
(Laerte Junior) Any DBA who is trying to find the cause of an intermittent problem with a server or database dreams of being able to use a query or procedure take a snap of the relevant variables at the point when the problem occurred.
(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.
(Robert Sheldon) It is not just the analytic power of R that you get from using SQL Server R Services, but also the great range of packages that can be run in R that provide a daunting range of graphing and plotting facilities.