TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
About Server
Share
facebook
twitter
linkedIn
Reddit
Topics
No topic found
Content Filter
Articles
Videos
Blogs
News
Complexity Level
Beginner
Intermediate
Advanced
Refine by Author
[Clear]
Monica Rathbun (14)
Sarathlal Saseendran (8)
Chittaranjan Swain (6)
Sundaram Subramanian (6)
Sarthak Varshney (5)
Rohini Parade (3)
Jitendra Mesavaniya (3)
Rinki (2)
Naveen Kumar (2)
Sumit Kharche (2)
Raj Kumar (2)
Frank Gutierrez (1)
Abiola David (1)
Anubhav Chaudhary (1)
Pradeep Chandraker (1)
Sean Franklin (1)
Vikas Gupta (1)
Shripad Kulkarni (1)
Asma Khalid (1)
Alagunila Meganathan (1)
John O Donnell (1)
Satyaprakash Samantaray (1)
George (1)
Ashutosh Singh (1)
Shivam Payasi (1)
Yash Rajora (1)
Divyansh Gupta (1)
Ajay Yadav (1)
Harishsady D (1)
Anupam Singh (1)
Vineet Desai (1)
Usman Sheikh (1)
Mageshwaran R (1)
Ganapathi Raman (1)
Vithal Wadje (1)
Aswinth G T (1)
Manoj Kalla (1)
Sifad Hussain (1)
Malvik Bhavsar (1)
Shenbagapandiyan P (1)
Veerendra Annigere (1)
Najath Risni (1)
Dhavalkumar Patel (1)
Sharad Gupta (1)
Lajapathy Arun (1)
Abhishek Yadav (1)
Satya Karki (1)
Shashangka Shekhar (1)
Arun Potti (1)
Abhijit Patil (1)
Rohatash Kumar (1)
Suvendu Shekhar Giri (1)
Deepak Middha (1)
Venkatesan Jayakantham (1)
Pankaj Patel (1)
Gajendra Jangid (1)
Ishika Tiwari (1)
Sanwar Ranwa (1)
Related resources for Server
No resource found
Delete Duplicate Rows In SQL Server From A Table
4/25/2024 8:49:52 AM.
In SQL Server, delete duplicate rows from a table efficiently using techniques like DISTINCT, GROUP BY, or ROW_NUMBER(). Ensure data integrity by considering primary keys or unique constraints.
How to Call a .NET Assembly From a SQL Server Scheduled Job
4/25/2024 8:29:38 AM.
Explore step-by-step guide showcasing integration of unmanaged calls via DTS ActiveX script to a .NET assembly within a SQL Server scheduled job. Understand assembly registration, system path configur
Ingest Data into Azure SQL Database using SSMS
4/25/2024 6:43:37 AM.
This video shows how to ingest data into Azure SQL Database using SQL Server Management Studio.
Get Client Side and Server Side Data in Grid View Using jQuery and Ajax
4/24/2024 1:18:02 PM.
Learn how to efficiently manage data in a grid view by combining client-side and server-side approaches using jQuery and Ajax. This tutorial guides you through the process of retrieving data from both
What is Server Load Balancer in Alibaba Cloud
4/24/2024 6:31:03 AM.
Unveil the power of Alibaba Cloud's SLB! Balance traffic, optimize performance, & ensure app uptime. Explore NLB, ALB & CLB for a robust cloud infrastructure. #AlibabaCloud #ServerLoadBala
What Is There In SQL Server Integrated Services (SSIS) Toolbox?
4/24/2024 5:55:45 AM.
This comprehensive overview of SQL Server Integration Services (SSIS) delves into its toolbox, encompassing Control Flow, Data Flow, Variables and Parameters, Event Handlers, Package Explorer, and Con
What is SQL Server Integration Services?
4/24/2024 5:21:49 AM.
SQL Server Integration Services (SSIS) is a robust data integration platform within Microsoft SQL Server, enabling seamless data extraction, transformation, loading, and management tasks efficiently.
ASP.Net 4.0 ClientId
4/23/2024 11:36:43 AM.
In ASP.Net 4.0, ClientId is a crucial feature enabling the unique identification of HTML elements rendered by server controls. It facilitates client-side scripting by providing a predictable naming co
Blazor Server - How To Store Encrypted Session Data In The Browser
4/23/2024 11:17:21 AM.
Learn how to enhance security in your Blazor Server applications by storing encrypted session data in the browser. Explore techniques to safeguard sensitive user information using ASP.NET Core and cli
Customized Auditing In SQL For DDL Operations At Server Level
4/23/2024 11:14:16 AM.
Explore the intricacies of customized auditing in SQL for DDL operations at the server level. Enhance database security and compliance by implementing tailored logging and monitoring mechanisms.
.NET Remoting: The Interface Approach
4/23/2024 9:01:14 AM.
.NET Remoting offers efficient remote object interaction, ideal for network resource access. Compared to SOAP-based web services, it's lighter. While easier than Java's RMI, it's more comp
Integrating Datatables JQuery Plugin in ASP.NET Webforms
4/23/2024 8:57:18 AM.
Learn how to seamlessly integrate the DataTables jQuery plugin with ASP.NET WebForms for efficient server-side processing. This tutorial delves into harnessing the power of DataTables for dynamic data
Exploring About Azure Function
4/23/2024 8:34:53 AM.
Explore the power of Azure Functions, Microsoft's serverless computing offering in the cloud. Dive into event-driven programming, scalability, and seamless integration with Azure services.
Rebooting a Remote Server using WMI
4/23/2024 8:20:03 AM.
Windows Management Instrumentation (WMI) facilitates remote management and system administration tasks, including remote shutdown and monitoring. However, it requires administrative privileges and pos
CRUD Operation Using Stored Procedure In ASP.NET GridView Real Time
4/22/2024 8:20:12 AM.
Prepare to be in stitches as [subject of video] finds themselves in a whirlwind of unexpected mischief! Their reaction is pure comedy gold, making this video an instant hit! #funny #prank #meme.
Server Automation (4), Jenkins
4/22/2024 6:18:15 AM.
This article will discuss Jenkins, server automation.
Real-Time Data Transfer with WebSockets and SignalR in .NET Core
4/22/2024 4:05:14 AM.
In this article, we'll explore how to implement WebSocket functionality using SignalR in a .NET Core application to retrieve data from a concurrent dictionary and push it to clients in real time.
Understanding VARCHAR and NVARCHAR in SQL Server
4/22/2024 4:00:34 AM.
VARCHAR and NVARCHAR are essential data types in SQL Server for storing character data. Understanding the differences between these data types is crucial for designing efficient database schemas and o
Zero To Hero In MS SQL Server - Part Three
4/19/2024 10:51:37 AM.
Part Three of Zero To Hero In MS SQL Server delves into advanced concepts like data warehousing, BI, reporting services, and data security, completing your journey to SQL Server mastery.
Zero To Hero In MS SQL Server - Part One
4/19/2024 10:51:18 AM.
This is part one of Zero To Hero Series in MS SQL Server. This is mainly focused for beginners who are into MS SQL Server and also for experienced who want to fresh up for interviews and daily technic
Mastering SQL Server Common Table Expressions (CTEs)
4/19/2024 10:50:28 AM.
Mastering SQL Server Common Table Expressions (CTEs) empowers users to create complex queries efficiently. Learn recursive and non-recursive CTEs, optimize queries, and enhance database management ski
Zero To Hero In MS SQL Server - Part Six
4/19/2024 10:32:56 AM.
Part six of "Zero To Hero In MS SQL Server" explores the WHERE Clause in SQL, used for filtering records based on conditions. It covers the syntax and usage of WHERE Clause, along with examp
Zero To Hero In MS SQL Server - Part Five
4/19/2024 10:32:41 AM.
Embark on a journey from novice to expert in MS SQL Server with Part Five of our comprehensive series. Explore advanced topics including query optimization, stored procedures, indexing strategies, and
Zero To Hero In MS SQL Server - Part Four
4/19/2024 10:31:37 AM.
In this article, Part Four of 'Zero To Hero In MS SQL Server' delves into advanced topics like query optimization, stored procedures, and indexing strategies. Master database management, T-SQL
Zero To Hero In MS SQL Server - Part Two
4/19/2024 10:30:33 AM.
Advance your MS SQL Server skills from Part One to mastery with Part Two. Dive into advanced T-SQL, stored procedures, triggers, and performance tuning techniques for efficient database management and
SQL Stored Procedures: Benefits, Implementation & Best Practices
4/19/2024 9:52:48 AM.
Stored procedures are a powerful feature of SQL databases that allow developers to encapsulate SQL logic and execute it as a single unit. In this article, we'll delve into the concept of stored pr
Difference Between Scalar and Aggregate Functions
4/19/2024 5:10:46 AM.
In this article, we'll discuss the differences between Scalar and Aggregate functions in MSSQL in detail. This article explores scalar and aggregate functions in Microsoft SQL Server, detailing th
Bulk Data Import in Blazor Server with Radzen Datagrid
4/19/2024 4:12:22 AM.
In this article, we'll explore how to implement a robust bulk data upload feature in a Blazor Server application using the Radzen Datagrid component for rendering the bulk imported data.
What are SQL dialects with Example?
4/19/2024 4:09:17 AM.
SQL dialects are versions of SQL tailored to specific database systems. Each dialect has its syntax and features while adhering to SQL's core principles. Understanding dialects is essential for wr
Remoting Technology: Distributed Computing
4/18/2024 1:27:32 PM.
Remoting technology facilitates distributed computing, enabling seamless communication between processes or applications across a network. It employs protocols, marshaling, and proxies to facilitate r
How Recursive CTE Works in SQL Server
4/18/2024 1:16:02 PM.
Recursive Common Table Expressions (CTEs) in SQL Server enable querying hierarchical data structures efficiently. Using the WITH clause, recursive CTEs define anchor and recursive members, facilitatin
Getting Started With OpenLayers 3 And Spatial Data
4/18/2024 10:45:12 AM.
Explore visualizing spatial data using OpenLayers with SQL Server 2008. Learn about the capabilities of OpenLayers for mapping, including its support for tiles and vector layers. Understand the two ty
Easily Create A Chart In Blazor With Syncfusion Component
4/18/2024 9:56:20 AM.
Effortlessly generate interactive charts in Blazor using Syncfusion's intuitive components. With seamless integration, harness the power of C# and .NET to create compelling data visualizations for
Working With Temporal Tables In EF Core 6.0
4/18/2024 8:46:18 AM.
Get started with creation of SQL Server Temporal Tables using Entity Framework Core 6.0 Code First approach and querying the historical data using LINQ.
Building Scalable Applications with Alibaba Cloud Serverless Computing
4/18/2024 4:13:40 AM.
This article guides setting up serverless architecture on Alibaba Cloud, configuring Object Storage Service, ApsaraDB for MongoDB, and Function Compute.
How To Easily Create Azure Functions Using Azure Portal
4/17/2024 8:04:43 AM.
Learn to effortlessly build Azure Functions via Azure Portal. Explore serverless computing, diverse triggers like HTTP or Timer, bindings for seamless data integration, and easy deployment. Monitor, s
How to Send & Read Messages with Azure Service Bus Queues in Azure Functions
4/17/2024 7:47:00 AM.
Learn to efficiently manage message communication in Azure using Azure Functions. Discover how to send and read messages from Azure Service Bus queues seamlessly, leveraging the power of serverless co
Creating Azure WebJobs To Parse Message From Azure Storage Queues
4/16/2024 8:53:11 AM.
In this article, you will learn how to utilize Azure WebJobs to efficiently process messages from Azure Storage Queues. Explore background processing, message parsing, and event-driven architecture in
MERGE Stored Procedures in SQL Server
4/16/2024 8:14:21 AM.
In this article, I present how to use the MERGE statement in a stored procedure to merge a single record and how to use it to merge a list of records by using Table-Valued parameters in SQL Server.
Table-Valued Parameters in SQL Server
4/16/2024 5:42:55 AM.
Table-Valued Parameters in SQL Server enable passing multiple rows of data to stored procedures, enhancing performance for bulk operations. Utilizing user-defined table types, they streamline data man
Create A Simple Blazor Server Application With .NET Core 3.0
4/16/2024 5:39:36 AM.
In this post, we will see how to create a simple Blazor application with .NET Core 3.0 SDK and default template. We will create a new service and get the C# Corner latest post details from their RSS f
Create a Single Page App with Blazor Server and Entity Framework Core 3.0
4/16/2024 5:34:48 AM.
Create dynamic web applications efficiently using Blazor Server, a .NET Core framework, coupled with Entity Framework Core 3.0 for seamless data integration. Leverage C# to build interactive, single-p
Alibaba Cloud CDN: Enhancing Web Performance Globally
4/16/2024 5:13:33 AM.
Unleash website speed with Alibaba Cloud CDN! Explore its benefits, architecture, and how it works. Discover the difference between CDN and DCDN for optimal content delivery. #AlibabaCloud #CDN
SQL Server System Functions: Aggregate, String, Math, Date
4/15/2024 11:17:36 AM.
Learn about SQL Server system functions including aggregate, string, mathematical, and date time functions. Explore their syntax and examples for efficient database operations. Ideal for beginners an
Create A Blazor Server SPA With Dapper
4/15/2024 11:13:00 AM.
In this post, we will see how to create a single page application in Blazor Server with Dapper ORM. We will see all the CRUD operations with Dapper using native SQL commands and stored procedures.
How To Create A Partitioned View In SQL Server
4/15/2024 11:05:27 AM.
Learn about creating and utilizing partitioned views in SQL Server for efficient data retrieval and performance optimization. Understand the concept, steps for implementation, check constraint usage,
A Guide to Cost Optimization on Alibaba Cloud
4/13/2024 5:20:37 PM.
Unleash Alibaba Cloud's full potential! This guide explores proven strategies to optimize costs, from resource allocation to serverless options. #AlibabaCloud #CloudCostOptimization
Share Data Between Child And Parent Components In Blazor
4/12/2024 11:14:56 AM.
Explore Blazor, Microsoft's framework for building dynamic web UIs with .NET. Learn about Razor components, data sharing between parent and child components, and creating reusable UI elements like
Role Based Authorization In Blazor
4/12/2024 11:14:35 AM.
Role-Based Authorization in Blazor enables access control based on user roles. By defining roles and policies, specific functionalities or resources can be restricted to users with certain roles. Blaz
ASP.Net Form Validation Using jQuery
4/11/2024 10:52:32 AM.
Learn how to perform form validation in ASP.Net using jQuery, enhancing user experience by validating form data on the client-side before submission. This tutorial covers setting up jQuery functions,
Create A Database Project From Existing SQL Database
4/11/2024 7:03:00 AM.
In this post, we will see how to create a database project from existing SQL database. We will modify the project by adding a table into the project and add seed data through post deployment script. W
Enhance SQL Server Queries with OPTION(RECOMPILE) Hint
4/11/2024 6:56:49 AM.
This article provides an in-depth exploration of the OPTION(RECOMPILE) hint in SQL Server, offering developers and database administrators a thorough understanding of its functionality, practical appl
How To Execute SSIS Package Using SQL Job
4/11/2024 6:24:56 AM.
Execute SSIS packages seamlessly with SQL Jobs, leveraging SQL Agent to schedule tasks and manage execution, ensuring automation and reliability in data integration workflows.
Leveraging Server-Sent Events (SSE) with Angular and Node.js
4/11/2024 5:25:47 AM.
Server-Sent Events (SSE) is a powerful technology that enables servers to push real-time updates to web clients over HTTP.
Localization In Blazor Server With .NET Core 3.1
4/10/2024 10:40:11 AM.
In this post, we will see how to implement localization in a Blazor server app. We will create an Employee app with all CRUD actions and create localization resource files for English and Malayalam cu
Understanding of Blazor Server App Project Structure
4/9/2024 8:50:28 AM.
This article covers creating a Blazor Server App project, project structure overview, default folders' usage, setting startup components, and essential files like AppSettings and Program.cs. Prere
How To Create SSIS Catalog
4/9/2024 8:25:51 AM.
In this article, you will learn how to efficiently create an SSIS Catalog in SQL Server Integration Services (SSIS). This comprehensive guide covers the setup and management of the catalog, including
Creating DNS Zones and Changing Name Servers from Public DNS
4/8/2024 10:40:25 AM.
This comprehensive guide walks you through the fundamentals of DNS zones, setting up Azure DNS, and integrating it with popular domain registrars like GoDaddy. With Azure DNS Zones, you can optimize y
Becoming Proficient in C# and ASP.NET: A Roadmap to Mastery
4/8/2024 4:59:04 AM.
From traditional ASP.NET Web Forms to the sleek ASP.NET MVC, and from robust backend solutions using ADO.NET and SQL Server to dynamic front-end interactions with jQuery, AJAX, and more, developers ha
How Secure Sockets Layer Works?
4/8/2024 4:49:33 AM.
SSL (Secure Sockets Layer) and TLS (Transport Layer Security) protocols establish encrypted connections between clients and servers, ensuring secure online communication by encrypting data and verifyi
NSX-T and the VMware SDDC Ecosystem
4/6/2024 6:16:11 AM.
Explore VMware's Software-Defined Data Center (SDDC) ecosystem, including vSphere, ESXi, vCenter Server, VSAN, and NSX for comprehensive virtualization and network management
Using Table Type Parameter In .NET Core
4/5/2024 11:24:07 AM.
In many cases, we need to send a list of objects to the stored procedure to save or update the list of data in the database, which helps in increasing the performance of the application. Here I'll
Install and Configure Network Load Balancing Manager in Server
4/5/2024 9:55:20 AM.
In this article, we will learn Network load balancing is the ability to balance traffic across two or more WAN links without using complex routing protocols like BGP.
Employee Salary Updates Using SQL Update with Inner Join Query
4/5/2024 9:16:51 AM.
Explore how to update employee salaries while ensuring that each employee has only one salary per job. We'll accomplish this task using the UPDATE statement with INNER JOIN in SQL. Let's dive
How to Use Stored Procedure in PHP
4/5/2024 5:42:14 AM.
Using stored procedures in PHP involves connecting to a database using MySQLi or PDO, preparing and executing SQL queries that call the stored procedures. Utilize parameterized queries for security an
Power of Filtered Indexes in SQL Server
4/5/2024 4:28:34 AM.
Discover the power of filtered indexes in SQL Server with our concise guide. Explore practical applications and key benefits, empowering you to harness the full potential of SQL Server for enhanced da
Dynamically Getting Stored Procedures Collection From SQL Server Using C#
4/4/2024 9:32:40 AM.
In this article, we will learn how to dynamically fetch stored procedures from Microsoft SQL Server using C# for enhanced database interaction. This tutorial explores C#'s capabilities to programm
Grant Execute Or View Permission To Stored Procedures In SQL Server
4/4/2024 8:53:54 AM.
In this article we’ll learn how we can grant execute permission or view permission on stored procedures. We’ll also see why users require explicit permission on stored procedures.
What Is Power BI Report Server And How To Install It
4/4/2024 7:25:02 AM.
Discover the essence of Power BI Report Server and its significance in business intelligence. Learn step-by-step installation procedures, enabling you to harness the power of Microsoft's robust an
Learn about Self Join In SQL Server
4/4/2024 5:59:15 AM.
Explore self-joins in SQL Server, including inner, outer, and cross joins. Understand their use for hierarchical data querying. Create a database, tables, and execute queries to grasp concepts effecti
Advanced Joins In SQL Server 2017
4/3/2024 10:50:44 AM.
Explore the intricacies of SQL Server 2017 with advanced join techniques. Master inner, outer, cross, and self joins to optimize database queries. Elevate your SQL skills with join algorithms and quer
SQL Server: Grant Permission To A Particular Table
4/3/2024 10:47:46 AM.
In this article, we will learn how to manage database security in SQL Server by granting permissions to specific tables. Safeguard sensitive data and control access with precise authorization settings
How To Query Dataverse In Microsoft SQL Server Management Studio (SSMS)?
4/3/2024 10:45:55 AM.
Querying Dataverse in Microsoft SQL Server Management Studio (SSMS) involves using Transact-SQL (T-SQL) to interact with tables, views, indexes, and stored procedures. Understanding entity relationshi
Joining Three Or More Tables In SQL Server 2017
4/3/2024 10:45:07 AM.
Joining three or more tables in SQL Server 2017 involves using various types of joins such as INNER JOIN, LEFT JOIN, RIGHT JOIN, and CROSS JOIN. These joins combine rows from multiple tables based on
Tools in SQL Server Management Studio
4/3/2024 10:42:11 AM.
Learn to utilize essential tools like Object Explorer, Query Editor, and TSQL in SQL Server Management Studio. Navigate objects, execute commands, and manage databases efficiently. Explore more tech a
Joins In SQL Server 2017
4/3/2024 9:57:44 AM.
In SQL Server 2017, joins allow combining data from multiple tables based on specified conditions. Varieties include INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF joins, each with distinct functiona
Difference Between Union & Union All In SQL Server 2017
4/3/2024 9:56:30 AM.
In this article, you will learn the nuances between UNION and UNION ALL in SQL Server 2017. While both combine results from multiple queries, UNION removes duplicates, whereas UNION ALL retains them.
Comparing Execution Plans In SQL Server
4/3/2024 9:52:56 AM.
SQL Server Management Studio (SSMS) allows easy comparison of execution plans, aiding in identifying performance discrepancies. Users can compare .sqlplan files, highlighting differences in query oper
Creating Various Types of Tables in SQL Server
4/3/2024 9:42:53 AM.
Learn about SQL Server tables like User, Temporary, Global; understand creation methods, differences between temporary and regular tables, storage locations, and utilization of table variables. Exampl
Trick To Use Dark Theme In SQL Server Management Studio 2017
4/3/2024 9:42:18 AM.
Unlock the stylish Dark Theme in SQL Server Management Studio 2017 with this ingenious trick. Enhance your visual experience and reduce eye strain while working with SQL databases. Customize your work
Temporary Table in SQL Server
4/3/2024 9:41:55 AM.
In this article, we will learn about temporary tables in SQL Server, a powerful feature for temporary data storage and manipulation. Master T-SQL techniques for creating and managing temporary tables,
Temporary Table vs Temporary Variable in SQL Server
4/3/2024 9:41:39 AM.
Temporary tables adhere to transaction boundaries, affected by rollbacks, whereas temporary variables remain unaffected, persisting data despite rollbacks. Illustrated through SQL queries, highlightin
Simple Image or File Import Using T-SQL for SQL Server
4/3/2024 8:47:23 AM.
The article demonstrates importing image files into SQL Server using T-SQL's OPENROWSET, BULK, and SINGLE_BLOB. It covers basic examples and prerequisites, allowing dynamic file paths and names fo
Temporary Tables and Table Variables in SQL Server
4/3/2024 5:59:21 AM.
In this article we will explore the temporary tables and table variables in SQL Server. From understanding their differences to exploring practical use cases and examples. Whether you're storing i
Database Optimization Technique
4/3/2024 5:40:07 AM.
Database optimization ensures efficient and performant systems. Techniques like indexing, normalization, and query optimization enhance query performance and overall efficiency.
Temporary Tables vs Common Table Expressions in SQL Server
3/29/2024 11:07:01 AM.
In this article, we will learn what is Differences Between Temporary Tables and Common Table Expressions in SQL Server. Temporary tables and Common Table Expressions (CTEs) are SQL Server tools for da
How to Identify Code Is Running on Client or Server in Vue.js
3/28/2024 11:08:56 AM.
In Vue.js, distinguishing between client and server-side execution is vital, especially in SSR scenarios. By checking for windows or process.server, developers tailor code for respective environments,
SQL Server Data Collection And Management Data Warehouse
3/28/2024 10:41:49 AM.
Explore the built-in SQL Server Data Collection tool for system monitoring. Learn setup steps for Management Data Warehouse, access control via roles, and monitoring data collection using SQL Agent an
Replication Of Max Text Length
3/28/2024 10:34:54 AM.
Ensure smooth replication of maximum text length in SQL Server by configuring 'max text repl size' using sp_configure. Optimize data management and maintain database performance with appropria
Contained Database - No Need For Server Level Logins Anymore
3/28/2024 10:34:38 AM.
Starting in SQL Server 2012 and in Azure SQL Database, Microsoft introduced the concept of a contained database. A contained database is a database that is completely un-reliant on the instance of SQL
Backup Encryption In SQL Server
3/28/2024 6:36:20 AM.
SQL Server offers backup encryption to enhance data security. Utilize encryption algorithms and key management to protect database backups, ensuring compliance with privacy regulations and safeguardin
Be Careful With Your SQL Server Max Memory Settings
3/28/2024 6:35:24 AM.
Quite often, I see database administrators set SQL Server Max Server Memory thinking that only everything related to SQL Server uses this shared memory pool. This is a mistake. There are many things t
Overview Of Cycle Error Logs
3/28/2024 6:34:11 AM.
I saw this again recently and see it too often in environments so wanted to take a second to remind everyone to cycle their error logs on a regular basis. SQL Server keeps error logs and when you rebo
Keeping Large Table Statistics Current - TF2371
3/28/2024 6:33:21 AM.
Statistics are the magic ingredient that helps the query optimizer create its best guess for generating an execution plan. Keeping statistics as accurate as possible will give the optimizer the inform
SQL Server Vulnerability Assessment
3/28/2024 6:33:00 AM.
SQL Server Vulnerability Assessment (VA) in SQL Server Management Studio 17.4 or later lets SQL Server scan your databases for potential security vulnerabilities and can be run against SQL Server 2012
SQL Data Discovery And Classification In SSMS
3/28/2024 6:32:31 AM.
SQL Data Discovery and Classification in SSMS allows users to identify and categorize sensitive data within databases, aiding in compliance with regulations like GDPR. Enhance data security and govern
New Resumable Online Index Create SQL Server 2019
3/28/2024 6:32:06 AM.
SQL Server 2019 brings a very exciting new feature that is long overdue. Resumable Online Index Create is one of my favorite new things. This, paired with the Resumable Index Rebuilds introduced with
Static Data Masking (SSMS 18.0 Preview)
3/28/2024 6:31:38 AM.
Static Data Masking in SSMS 18.0 Preview enhances data security by obscuring sensitive information in databases. It safeguards privacy during testing by replacing real data with masked values, ensurin
What Does This Little Check Box Do
3/28/2024 6:31:10 AM.
Ever wander around SQL Server properties and wonder what these little check boxes turn on? I do, and I get very tempted to check them. Here is one of those tempting little boxes that seems pretty hand
VLFs - The Forgotten Foe
3/28/2024 6:30:53 AM.
Unveil the hidden impact of Virtual Log Files (VLFs) in SQL Server. Explore strategies to mitigate performance issues stemming from log file fragmentation and learn essential database maintenance tech