sureshsimkumar's profile picture.

sureshsimkumar

@sureshsimkumar

Check out my latest article: A Simple Guide to Understanding sys.indexes linkedin.com/pulse/simple-g… via @LinkedIn

sureshsimkumar's tweet image. Check out my latest article: A Simple Guide to Understanding sys.indexes 
linkedin.com/pulse/simple-g… via @LinkedIn

SQL Server Question & Answers-01 What is the difference between DELETE and TRUNCATE statements?handbookofsuresh.blogspot.com/2025/08/sql-se…

sureshsimkumar's tweet image. SQL Server Question & Answers-01 
What is the difference between DELETE and TRUNCATE statements?handbookofsuresh.blogspot.com/2025/08/sql-se…

How to find the "nth" row in SQL Server table using ROW_NUMBER() handbookofsuresh.blogspot.com/2025/04/how-to…

sureshsimkumar's tweet image. How to find the "nth" row in SQL Server table using ROW_NUMBER() handbookofsuresh.blogspot.com/2025/04/how-to…

DATEDIFF_BIG in SQL Server [SQL Server Date Functions-02] handbookofsuresh.blogspot.com/2025/03/datedi…

sureshsimkumar's tweet image. DATEDIFF_BIG  in SQL Server [SQL Server Date Functions-02]  handbookofsuresh.blogspot.com/2025/03/datedi…

SWITCHOFFSET in SQL server [SQL Server Date Functions ]-01 handbookofsuresh.blogspot.com/2025/03/switch…

sureshsimkumar's tweet image. SWITCHOFFSET in SQL server [SQL Server Date Functions ]-01 handbookofsuresh.blogspot.com/2025/03/switch…

sureshsimkumar reposted

PARSENAME in SQL Server PARSENAME is a built-in SQL Server function used to return a specific part of a fully qualified object name (e.g., a table name or column name). #sql #sqlserver #dba handbookofsuresh.blogspot.com/2025/01/parsen…

sureshsimkumar's tweet image. PARSENAME in SQL Server 
PARSENAME is a built-in SQL Server function used to return a specific part of a fully qualified object name (e.g., a table name or column name). 
#sql #sqlserver #dba
handbookofsuresh.blogspot.com/2025/01/parsen…

sureshsimkumar reposted

PATINDEX in SQL Server The PATINDEX function in SQL Server is used to find the starting position of a pattern within a string. It works similarly to the CHARINDEX function but is more versatile because..... #sql #sqlserver #dba handbookofsuresh.blogspot.com/2025/01/patind…

sureshsimkumar's tweet image. PATINDEX in SQL Server 
The PATINDEX function in SQL Server is used to find the starting position of a pattern within a string. It works similarly to the CHARINDEX function but is more versatile because.....
#sql #sqlserver #dba
handbookofsuresh.blogspot.com/2025/01/patind…

sureshsimkumar reposted

TRANSLATE() Function in SQL Server The TRANSLATE() function in SQL Server is used to replace multiple characters in a string with corresponding characters from another string. #sql #sqlserver #dba handbookofsuresh.blogspot.com/2025/01/transl…

sureshsimkumar's tweet image. TRANSLATE() Function in SQL Server 
The TRANSLATE() function in SQL Server is used to replace multiple characters in a string with corresponding characters from another string.
#sql #sqlserver #dba
handbookofsuresh.blogspot.com/2025/01/transl…

sureshsimkumar reposted

Memory-Optimized Tables in SQL Server Memory-Optimized Tables in SQL Server are a feature designed to improve performance and scalability by storing table data in memory instead of disk. #sql #sqlserver #dba handbookofsuresh.blogspot.com/2025/01/memory…

sureshsimkumar's tweet image. Memory-Optimized Tables in SQL Server 
Memory-Optimized Tables in SQL Server are a feature designed to improve performance and scalability by storing table data in memory instead of disk.
#sql #sqlserver #dba
handbookofsuresh.blogspot.com/2025/01/memory…

sureshsimkumar reposted

SQL Server Data Encryption Techniques Data encryption in SQL Server ensures that sensitive information remains secure and protected from unauthorized access. #sql #sqlserver #dba handbookofsuresh.blogspot.com/2025/02/sql-se…

sureshsimkumar's tweet image. SQL Server Data Encryption Techniques 
Data encryption in SQL Server ensures that sensitive information remains secure and protected from unauthorized access.
#sql #sqlserver #dba
handbookofsuresh.blogspot.com/2025/02/sql-se…

sureshsimkumar reposted

Advanced Indexing: Filtered Indexes and Columnstore Indexes in SQL Server Efficient indexing is crucial for improving query performance in SQL Server. Two advanced indexing techniques—Filtered Indexes and Columnstore Indexes #sql #sqlserver #dba handbookofsuresh.blogspot.com/2025/01/advanc…

sureshsimkumar's tweet image. Advanced Indexing: Filtered Indexes and Columnstore Indexes in SQL Server 
Efficient indexing is crucial for improving query performance in SQL Server. Two advanced indexing techniques—Filtered Indexes and Columnstore Indexes
#sql #sqlserver #dba
handbookofsuresh.blogspot.com/2025/01/advanc…

sureshsimkumar reposted

Estimate Types in PMP Estimation is a critical part of project management and is essential for planning, budgeting, and scheduling. #pmp #pmo #projectmanagement #project handbookofsuresh.blogspot.com/2024/04/estima…


sureshsimkumar reposted

Check out my latest article: How to find the last day of a month in SQL Server? linkedin.com/pulse/how-find… via @LinkedIn

sureshsimkumar's tweet image. Check out my latest article: How to find the last day of a month in SQL Server? linkedin.com/pulse/how-find… via @LinkedIn

sureshsimkumar reposted

Isolation Levels in SQL Server Isolation levels in SQL Server determine how transactions interact with each other and control the level of locking, blocking, and concurrency. SQL Server supports five isolation levels #sql #sqlserver #dba #dbadmin handbookofsuresh.blogspot.com/2025/01/isolat…

sureshsimkumar's tweet image. Isolation Levels in SQL Server 

Isolation levels in SQL Server determine how transactions interact with each other and control the level of locking, blocking, and concurrency. SQL Server supports five isolation levels
#sql #sqlserver #dba #dbadmin
handbookofsuresh.blogspot.com/2025/01/isolat…

sureshsimkumar reposted

Dynamic SQL and Its Use Cases in SQL Server Dynamic SQL refers to SQL statements that are constructed and executed at runtime rather than being hardcoded in the script. #sql #sqlserver #dba #dbadmin handbookofsuresh.blogspot.com/2025/01/dynami…

sureshsimkumar's tweet image. Dynamic SQL and Its Use Cases in SQL Server

Dynamic SQL refers to SQL statements that are constructed and executed at runtime rather than being hardcoded in the script. 
#sql #sqlserver #dba #dbadmin

handbookofsuresh.blogspot.com/2025/01/dynami…

sureshsimkumar reposted

SQL Injection in SQL Server: Prevention and Best Practices SQL Injection (SQLi) is a security vulnerability that allows attackers to manipulate SQL queries by injecting malicious SQL code into input fields. handbookofsuresh.blogspot.com/2025/02/sql-in…

sureshsimkumar's tweet image. SQL Injection in SQL Server: Prevention and Best Practices 
SQL Injection (SQLi) is a security vulnerability that allows attackers to manipulate SQL queries by injecting malicious SQL code into input fields. 
handbookofsuresh.blogspot.com/2025/02/sql-in…

sureshsimkumar reposted

New Logical Function "GREATEST" in SQL Server 2022 The GREATEST function in SQL Server, introduced in SQL Server 2022, returns the maximum value from a list of expressions. handbookofsuresh.blogspot.com/2025/02/new-lo…

sureshsimkumar's tweet image. New Logical Function "GREATEST" in SQL Server 2022 

The GREATEST function in SQL Server, introduced in SQL Server 2022, returns the maximum value from a list of expressions. 
handbookofsuresh.blogspot.com/2025/02/new-lo…

sureshsimkumar reposted

"GENERATE_SERIES" in SQL server GENERATE_SERIES function is a new table-valued function that generates a series of numbers in a specified range. It simplifies the process of creating sequential nos. without the need for recursive queries or temp tables. handbookofsuresh.blogspot.com/2025/02/new-fu…

sureshsimkumar's tweet image. "GENERATE_SERIES" in SQL server 
GENERATE_SERIES function is a new table-valued function that generates a series of numbers in a specified range. It simplifies the process of creating sequential nos. without the need for recursive queries or temp tables.
handbookofsuresh.blogspot.com/2025/02/new-fu…

United States Trends

Loading...

Something went wrong.


Something went wrong.