Author
Mazidi Amin 13 posts 0 comments
I make SQL Server faster and more reliable. Database administration isn’t about passing a certified exam, or about pointing and clicking your way through a crisis. Database administration is about applying the right solution at the right time, avoiding risk, and making robust choices that get you home each night in time for dinner with your family .
My areas of specialty are:
• SQL Server 2019-2008 performance tuning.
• Designing high availability and disaster recovery solutions.
• Securing SQL Server
• SSIS , SSAS
• Designing Data warehouse
Hello everybody, in this article we want to show you how to configure Microsoft SQL Server Password Policy, Expiration Policy and Account Lockout Policy, this is simple but has a few nuances.
First of all, What is Password Policy?…
Run SQL Server Linux container images with Docker
In this article i will explain how you can Pull and run the SQL Server Linux container image with commonly used parameter.
To install on Docker, first download the images related to SQL Server:
docker pull…
How to Add logfile to suspect database when full log size?
Adds a log file to a file group when recovery cannot complete on a database due to insufficient log space (error 9002). After the file is added, sp_add_log_file_recover_suspect_db turns off the suspect setting and completes the recovery of…
How to Adds a data file to a filegroup when recovery cannot complete on a database
Adds a data file to a filegroup when recovery cannot complete on a database due to insufficient space on the file group (error 1105). After the file is added, this stored procedure turns off the suspect setting and completes the recovery of…
SQLSERVER 2017 CU3 and later: Query Store notice
Query Store notice
If you use the Query Store feature, and you have previously installed Cumulative Update 2 (CU2) (14.0.3008.27), the following requirement applies to you:
After you install Cumulative Update 3 (CU3) (14.0.3015.40) or a…
SQL Server 2019 now available on Ubuntu 18.04, supported on SLES 12 SP5
SQL Server 2019 package native to Ubuntu 18.04 ecosystem, fully supported for production use, starting with CU3.…
Resource Governor
SQL Server Resource Governor is a feature than you can use to manage SQL Server workload and system resource consumption. Resource Governor enables you to specify limits on the amount of CPU, physical IO, and memory that incoming…
Features are restricted to specific editions of SQL Server
sys.dm_db_persisted_sku_features :
dynamic management view to list edition-specific features that are enabled in the current database.
If no features that may be restricted by a specific edition are used by the database, the view…
Space usage information for the transaction log
sys.dm_db_log_space_usage Returns space usage information for the transaction log.
Column name
Data type
Description
database_id
smallint
Database ID.
total_log_size_in_bytes
bigint
The size of the log…
Determing the position of the last VLF in transaction log before shrinking the log file
sys.dm_db_log_info
Returns Virtual log file (VLF) information of the transaction log. Note all transaction log files are combined in the table output. Each row in the output represents a VLF in the transaction log and provides information…