(Daniel Farina) You work as a SQL Server Database Administrator. In your company there is a database application that has grown to a point that needs to be moved to a new server with more resources. You perform the server migration and everything goes fine without any issues.
Other News
Getting Started With Ionic 4, Angular And .NET Core 3
(Smiten Kalathiya) In this article, let’s talk about what Ionic framework is, why developers choose it, and how to implement it with Angular and .NET Core 3
Troubleshooting problems with AlwaysOn Availability Group in SQL Server 2017
Troubleshooting problems with AlwaysOn Availability Group in SQL Server 2017 If you have problems with AlwaysOn Availability Group in SQL Server 2017, review this troubleshooting checklist to find potential solutions. 1. Ensure the accounts under which SQL Server 2017 is running are correctly configured. Microsoft recommends use the same domain user account for the partners in AlwaysOn Availability Group. If...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Snapshot Isolation in SQL Server
(Gerald Britton) In this article, I’ll explore the use of snapshot isolation using row versioning as an alternative to the classic ANSI SQL transaction levels.
Power Query/M Optimisation: Getting The Maximum Value From A Column, Part 1
(Chris Webb) I’ve just learned some really interesting new Power Query/M optimisation tricks!
Profiler and Trace vs. Extended Events
(Grant Fritchey) It’s a running joke among the more experienced (read, older) Microsoft Data Platform specialists as to whether you’re #teamprofiler or #teamexevents.
IBM Reference Architecture for High Performance Data and AI in Healthcare and Life Sciences
(Dino Quintero and Frank N. Lee) This IBM Redpaper publication provides an update to the original description of IBM Reference Architecture for Genomics. It expands the reference architecture to cover all major vertical areas of healthcare and life sciences industries, such as genomics, imaging, and
Reverse Lookups with JavaScript
(David Walsh) I’ve always loved exploring regular expressions because they’re one of those skills that’s never taught in school — you need to pick them up on the fly, messing up and fixing them along the way.
Switch-Less Code : An Example In ASP.NET Core
(Bipin Joshi) It is common in ASP.NET Core application to store one or more configuration options in appsettings.json. These options are then read inside MVC controllers or Razor Pages page models. Depending on a particular configuration setting you want to execute certain piece of processing.
Developing Desktop applications in .NET
(Damir Arh) Although there haven’t been as many new developments in approaches to desktop development as there were in web development, there are still several different frameworks available to .NET developers for creating desktop apps. This article provides an overview of them, compares their featu