Monica Rathbun
C# Corner
Virginia, United States
Contact Monica
Discover and connect with journalists and influencers around the world, save time on email research, monitor the news, and more.
| Recent: |
|
| Past: |
|
Past articles by Monica:
What Is SQL Server TempDB
In this article, you will learn what is SQL Server TempDB → Read More
What Is Azure SQL Database Serverless
In this article, you will learn about Azure SQL Database Serverless. → Read More
What Is Batch Mode On Rowstore In SQL Server
In this article, you will learn what is Batch Mode on Rowstore in SQL Server. → Read More
Coding Standards Gone Bad
In this article, you will learn about the Coding Standards Gone Bad. → Read More
Moving Your SQL Workload to the Cloud
Every day, more IT organizations decide to move their SQL Server databases to Azure. In fact, over a million on-premises SQL Server databases have been moved to Azure. There’s an interesting blog about how Microsoft is faster and cheaper than its competitors that’s worth a read. To assist with your move to Azure Microsoft offers a number of migration tools and services to make this move as… → Read More
Being A Woman In The SQL Community
In this article, you will learn about being a woman in the sql community. → Read More
Upcoming International Speaking Engagements
In this article, you will learn about upcoming International Speaking Engagements. → Read More
String Function In SQL Server
In this article, you will learn about String Function in SQL Server. → Read More
SQL Server In Memory Table Indexes
In this article you will learn about SQL Server in memory table indexes. → Read More
Memory Optimizer Advisor
In this article, you will learn about Memory Optimizer Advisor. → Read More
Memory Optimized Tables In SQL Server
In this article, you will learn about memory-optimized tables in SQL Server. → Read More
Filtered Index Basics
In this post, we will continue with another beginner’s blog of database features that may be unknown to many. → Read More
DMV's For Beginners
In this article you will learn about DMV's. → Read More
What Is Implicit Conversion
In this article, you will learn what implicit conversion is and how it works. → Read More
Enable Mail Profile Back To Basics
I’ve seen many people go through the trouble of setting up database mail and configuring SQL Agent Alerts only to realize it’s not working. The reason in the cases I’ve seen is because they have simply neglected to assign a mail profile to SQL Agent. → Read More
How Your Hypervisor Can Impact Your CPU
The most prevalent SQL Server wait type was SOS_SCHEDULER_YIELD. This wait type is typically prevalent on a server undergoing CPU pressure. → Read More
Azure Key Vault Logging
Azure Log Analytics uses advanced analytics and machine learning to analyze your azure log files. It adds intelligent insights to your monitored data such as Key Vault usage and access as well as latency in key retrieval from your Audit Event Logs. → Read More
Learn About Azure Key Vault
Keys and secrets (AKA passwords) are an essential part of data protection management not only on-premises, but within the cloud as well. One of the many advantages of the cloud is the ability to have a secure, persisted key store. If you have used a password manager like Keepass or 1Password, you can consider Azure Key Vault to be an enterprise level password manager, but also a lot more. → Read More
Azure Advisor
Azure offers a lot of value-added services included with the price you pay. One of the things I really like is the Azure Advisor. → Read More
APPROX_COUNT_DISTINCT Function In SQL
We all have written queries that use COUNT DISTINCT to get the unique number of non-NULL values from a table. This process can generate a noticeable performance hit especially for larger tables with millions of rows. Many times, there is no way around this. To help mitigate this overhead SQL Server 2019 introduces us to approximating the distinct count with the new APPROX_COUNT_DISTINCT function. → Read More