In this article, I’ll provide some useful information to help you understand how to use Unicode in SQL Server and address various compilation problems that arise from the Unicode characters’ text with the help of T-SQL.
Read more »
Jignesh Raiyani
Jignesh has good experience in Database Solutions and Architecture, working with multiple customers on Database Design & Architecture, SQL Development, Administration, Query Optimization, Performance Tuning, HA and Disaster Recovery.
View all posts by Jignesh Raiyani
View all posts by Jignesh Raiyani
Latest posts by Jignesh Raiyani (see all)
- Page Life Expectancy (PLE) in SQL Server - July 17, 2020
- How to automate Table Partitioning in SQL Server - July 7, 2020
- Configuring SQL Server Always On Availability Groups on AWS EC2 - July 6, 2020
Resolve and Troubleshoot SQL Blocking chains with root sessions
November 5, 2019In this article, we will study how to recognize and resolve the SQL blocking chain by determining and troubleshooting the root cause.
Read more »
Prepare ZIP or RAR files in SQL Server Using xp_cmdshell (T-SQL)
October 21, 2019Microsoft SQL Server offers the ability to export data into CSV, Excel, PDF and other formats with the help of xp_cmdshell in T-SQL.
Read more »
Database Level DDL Triggers for Views, Procedures and Functions
October 4, 2019In this article, we will un-riddle the ways to make use of the data definition language trigger (DDL Trigger), in order to monitor the progressions made to the database programming objects, View, Procedure or Function with a few real-time examples.
Read more »
MySQL Query (T-SQL) Tutorial for SQL Server
September 25, 2019Microsoft SQL Server and MySQL, both are quite well-established database engines. In our role as a DBA, at some given time point we require T-SQL straddling between both database engines unites Select, Insert, Update, Delete and some other…
Read more »
Database Level DDL Triggers on Tables
September 23, 2019This article portrays the different utilization of database DDL Triggers for the Tables with a counting mail alert on schema composition using DDL (Data Definition Language) standard. Using that efficient method we can keep close eyes on monitoring schema changes in any database of SQL Server. We’ll also see how we could monitor these movements and send an alert email to persons responsible to inform about this change.
Read more »
Move or copy SQL Logins by assigning roles and permissions
September 13, 2019This article speaks to, how to copy SQL Logins on the new server with Server Level roles and database-level permissions as existing Source to Destination SQL Server instance using a script.
Read more »
Limit SQL Server Login Authentication scope using a Logon Trigger
September 13, 2019This article contains the SQL Server login Authentication scope on the Security side. We will find the subtleties, how Login Authentication extension can be controlled SQL Server level Logon trigger.
Read more »
SQL Server Transactional Replication on Linux
September 12, 2019In this article, we will talk about how to send the SQL Server Transactional Replication on Linux Environment.
Read more »
SQL Server Index Fill factor with a Performance Benchmark
September 9, 2019In this article, we will study in detail about the how SQL Server Index Fill factor works.
Read more »
SQL Server Merge Replication on Linux
August 15, 2019Replication is a process to manage multiple copies of the same data at a different node. Microsoft SQL Server supports Merge Replication, Transaction Replication, Peer to Peer Replication and Snapshot Replication.
Read more »
SQL Server Installation & Troubleshooting on Ubuntu
August 15, 2019A couple of years ago, Microsoft announced that SQL Server would be available on Open Source (Linux). In this article, we will go through the installation of Microsoft SQL Server on Linux (Ubuntu) and each step in detail.
Read more »