Improve you knowledge and skill set with this FREE Database Health Monitor training and Q&A. This training will be held every month on different days of the week and times so to fit a variety of schedules. Steve will demonstrate tips, tricks and features of this power house tool. Each month he will cover a different topic which will be …
Monthly Database Health Monitor Training with Q+A Read more »
Securing SQL Server: Transparent Data Encryption Mon, 30 Jan 2023 Transparent Data Encryption (TDE) is a feature of Microsoft SQL Server that enables the encryption of a databases data and log files, as well as the encryption of backups, to protect sensitive data from unauthorized access. TDE encrypts the dat Read more… Complete Access to all our Online SQL Server …
Transparent Data Encryption (TDE) is a feature of Microsoft SQL Server that enables the encryption of a databases data and log files, as well as the encryption of backups, to protect sensitive data from unauthorized access. TDE encrypts the data at the page level, meaning that the data is encrypted as it is written to the disk and decrypted when …
Securing SQL Server: Transparent Data Encryption Read more »
If you are one of our Managed Service clients, you have 100% free access to all current and future online courses. And yes, new classes are consistently being added! Here is a current list of all online courses available now: Getting started with SQL Server Microsoft TSQL JOIN Types SQL Server Backup and Restore Using Database Health Monitor Ransomware Awareness …
Complete Access to all our Online SQL Server Courses Read more »
Primary keys are an essential element of database design and are used to uniquely identify each record in a table. In SQL Server, primary keys are implemented using a constraint that ensures that each row in a table has a unique value for the designated primary key column. There are several benefits to using primary keys in SQL Server. First …
Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application requests data from the database, the request is placed in a queue and the client application must wait for its turn to access the data. The time that the query spends …
SQL Server Wait Type: PREEMPTIVE_OS_QUERYREGISTRY Read more »
In SQL Server, the fill factor is a configuration option that determines how much space is left on each page of an index when it is created or reorganized. The fill factor specifies the percentage of space that will be filled on each page, with the remaining space left as free space. The fill factor is specified as a percentage …
You call us in the middle of the night, and within 2 hours we’re on the issue with our Highly Available Support Managed Service! Just another perk of this service. This service also includes the following: Contact us today to capitalize on our current Sale going on through the month of January! You get your first 12 months of our …
Synonyms in SQL Server are a useful feature that allow developers to create an alias or alternate name for an object in the database. This can be especially helpful when working with complex or large databases, as it allows developers to use more descriptive or intuitive names for objects instead of the default names assigned by the system. There are …
To find the most used data files on SQL Server, you can use the sys.dm_io_virtual_file_stats dynamic management view. This view contains statistics about the I/O activity of all the data files in the database. To use this view, you can run the following query: This query returns the following columns: The query orders the results by the num_of_bytes_written column in …
Query to find the most used data files on SQL Server Read more »