December 2019
Transact-SQL syntax not supported in Azure SQL Database
How to migrate database from local SQL database to Azure SQL database
How to find log file used space in SQL server
Log size in percentage with all databases
Top Procedures By Total Logical Writes
Logical writes relate to both memory and disk I/O pressure
Sql Server code template & guideline
Coding standard help to process make smother
Dedicated hosting provider name with Price calculator
dedicated hosting provider for application and database server
How to check the writeable copy of the database in the availability group SQL server
This scripts is useful to check before write any automation process. Writable copy of all availability group
How to add active directory linked server
Here is a sample Active directory linked server. Sample call to retrieve AD Records.
Refresh all views in a database
Updates the metadata for the specified non-schema-bound view. Persistent metadata for a view can become outdated because of changes to the underlying objects upon which the view depends. This scripts help to refresh all view in selected database. Updates all views that have dependencies on a changed object https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-refreshview-transact-sql?view=sql-server-ver15