SQL Server - MSSQL - Environment

Here is the concept to create MSSQL - Environment with Expiry

SQL Server - CHW

 'CHW' I mean to say Cumulative Updates and Hotfix detail with Window Update Links

SQL Server - Query to find Duplicate Records in a table

Query to find duplicate records

SQL Server - HotFixes (Logshipping)

HotFixes  - Logshipping

SQL Server Events and Notification

- SQL Server Database Mail

- SQL Server Mail Operator

- SQL Server Push Notification

https://learn.microsoft.com/en-us/sql/relational-databases/native-client/features/working-with-query-notifications?view=sql-server-ver16

- SQL Server Events

Additionally,

SQL Server MVP

Related Article

https://mvp.microsoft.com/en-us/overview

List of Microsoft Cloud Partner.

Related Article/s

https://partner.microsoft.com/en-US/

https://learn.microsoft.com/en-us/partner-center/find-a-partner

Best Regards

Amit Vaid

SQL Server - Performance DashBoard

Performance DashBoard

SQL Server - Bulk Insert Best Practices & Books Online

Bulk Insert Best Practices & Books Online

SQL Server - Enable Trace Profiler (Query Analyser)

Using SSMS Query Analyser

SQL Server - Tech Antons

Tech Antons

Antons is derived from the word 'Antonym' which is another way of normal practice from SQL Server Technical Best Practices.

It is suggested to run below maintenance activities on daily basis which should take around 15-30 mnts.

SQL Server - Disaster Recovery and High Availability Updates

Disaster Recovery and High Availability Updates

Related Article..

https://support.microsoft.com/en-au/topic/kb5007182-cumulative-update-14-for-sql-server-2019-67b00a61-4f30-4a36-a5db-b506c47e563b

SQL Server - Collation Settings

In this article we will learn on how to change the collation settings at database level.

Use [Poland-Showroom-DB]

SELECT name, collation_name FROM sys.databases WHERE name = 'Poland-Showroom-DB';

SQL Syntax

-- make sure database in Single user mode

ALTER DATABASE [Poland-Showroom-DB] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

-- change collation to Polish_CI_AS

ALTER DATABASE [Poland-Showroom-DB] COLLATE Polish_CI_AS;

-- allow database in operational mode

ALTER DATABASE [Poland-Showroom-DB] SET MULTI_USER

Here is the related article to cross verify the Windows and SQL Language Code Identifiers (LCID).

https://learn.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-ver16

Best Regards

Amit Vaid

SQL Server - Browser Service 'Disabled'

Browser Service is 'disabled'

IMPACT
If the SQL Server Browser service isn't running, the following connections do not work:

Any component that tries to connect to a named instance without fully specifying all the parameters (such as the TCP/IP port or named pipe).
Any component that generates or passes server\instance information that could later be used by other components to reconnect.
Connecting to a named instance without providing the port number or pipe.
DAC to a named instance or the default instance if not using TCP/IP port 1433.
The OLAP redirector service.
Enumerating servers in SQL Server Management Studio or Azure Data Studio.

How to enable Browser Service


Related Article

https://learn.microsoft.com/en-us/sql/tools/configuration-manager/sql-server-browser-service?view=sql-server-ver16

SQL Server - Ultimate 'Group By' Clause

 SQL Server Group By Clause

SQL Server - TimeStamp AutoUpdate

Trigger for Insert and Update

SQL Server Architecture with ACID Properties

SQL Server Architecture with ACID Properties

Related Article

https://amit-sqldbasupport.blogspot.com/2022/11/sql-server-architecture.html

Acid Properties

https://learn.microsoft.com/en-us/windows/win32/cossdk/acid-properties

Common Fatal Errors

Related Article

https://social.technet.microsoft.com/wiki/contents/articles/53891.sql-server-troubleshooting-common-db-corruption-causes.aspx

https://learn.microsoft.com/en-us/dynamics-nav/troubleshooting--a-fatal-error-occurred.-the-connection-to-sql-server-cannot-be-established

https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/database-engine-error-severities?view=sql-server-ver16

https://support.microsoft.com/en-us/topic/kb3173976-fix-fatal-error-when-you-run-a-query-against-the-sys-sysindexes-view-in-sql-server-2016-a4803f29-0c24-6813-82c5-8a540b96011b

Best Regards

Amit Vaid

SQL Server - Top Recommendations

 SQL Server - Top Recommendations

1. TempDB - The Number of Logical CPUs, the number of Tempdb Data files it should be.

2. Target Memory counter should not exceed maximum allocated memory. Anyhow we should continuously monitor its spike before allocating more memory.

3. Page Life Expectancy value should be more than 300 as good sign.

4. Buffer Cache Hit Ratio - More than 90%

5. Continuously capture/watch the number of active virtual log files for the database to be able to analyze the overall need for Log file initial size.

6. DBCC Checkdb should run for all the database fortnightly/weekly.

7. Verify Backups - It's necessary that Backup set should be valid once finished (but takes some more time).

For rest other missing recommendations, we will continuously work on this article and provide some more info to improve the performance and proactive monitoring of your databases.

Best Regards

Amit Vaid

SQL Server - Substring Function (Very Useful)

 Use of SUBSTRING function....

Related Article

https://learn.microsoft.com/en-us/sql/t-sql/functions/trim-transact-sql?view=sql-server-ver16

SQL Server - Monitoring Magnets

SQL Server - Monitoring Magnets

SQL Server - Blocking and Huge Tempdb

Blocking and Huge Tempdb

https://learn.microsoft.com/en-us/troubleshoot/sql/performance/understand-resolve-blocking

https://support.microsoft.com/en-us/topic/how-to-shrink-the-tempdb-database-in-sql-server-ea0a95c2-eff8-7075-9ee2-2ee42226ca1c

SQL AWAITING COMMAND

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/26f36dd3-e5c0-452f-8513-d8c78c3e3e09/sql-awaiting-command-sleeping-bloking-most-of-the-running-processes-wthout-genrating-any-deadlock?forum=sqldatabaseengine

SQL Server Important Tools Links

https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16

Additionally

Example of GroupBy Clouse

USE [NewAmondsShop]

SQL Server - Shared Memory Protocol

Connecting from Another Computer

By using the Shared memory protocol, Management Studio will connect to the Database Engine.

https://learn.microsoft.com/en-us/sql/relational-databases/lesson-2-connecting-from-another-computer?view=sql-server-ver16

Additionally,

Please also read about Digital Signature.

https://learn.microsoft.com/en-us/sql/t-sql/statements/add-signature-transact-sql?view=sql-server-ver16

Additionally,

Please also learn below concept for security reasons.

We may have to change SQL Server default port from 1433 to any other unknown number. 

Best Regards

Amit Vaid

SQL Server - 'JAR'

HANDI (T-SQL) 'JAR'

- Joins

- Attributes

- ROW_Number

Related Articles...

https://learn.microsoft.com/en-us/sql/relational-databases/performance/joins?view=sql-server-ver16

https://learn.microsoft.com/en-us/sql/master-data-services/attributes-master-data-services?view=sql-server-ver16

https://learn.microsoft.com/en-us/sql/t-sql/functions/row-number-transact-sql?view=sql-server-ver16

Best Regards

Amit Vaid