xp_logininfo is a system stored procedure that allows you to see the contents and types of permissions for user groups defined in SQL Server. To see members of user-defined groups in SQL Server:

xp_logininfo @acctname = ‘AccounName’, @option = ‘members’

you can run .

For example, if a windows administrators group is added to SQL Server, users who can connect to the server with that group;

exec xp_logininfo @acctname = ‘BUILTIN\Administrators’, @option = ‘members’

you can view it by using .

--

--

As data grows, it becomes harder to make sense of observations. The size of the data size in the images we use does not provide the readability that should be in a visual report. Here we take a data grouping approach and we can increase readability by grouping the data…

--

--

SQL Server Query Optimizer uses statistics during query compilation to help determine the optimal query plan. By default, if the optimizer notices that a statistic is out of date due to too many changes in a table, it updates the statistics just before the query assembly can continue.

To activate the Auto Update Statistics feature, you can activate the Auto update Statistics feature in the following script or Database features.

ALTER DATABASE [DatabaseName]

SET auto_update_statistics ON WITH no_wait

Go

--

--

- Method 1 — Create a different disk on the virtual machine and make backups onto it
— Method 2 — Importing SQL backups onto Azure Storage
— Method 3 — Making backups of databases with Azure Backup Service
— Method 4 — Retrieval of backups using file snapshot command

--

--

We want to use custom colors in some images in Power BI reports. Especially when using custom colors that we create from the manual color palette in other visuals, we need to access the corresponding color area from the formatting menu and then the color code.

Instead of these long operations, we can use the PowerToys tool developed by Microsoft. All we have to do is activate the Color Picker feature and set a keyboard shortcut, among many nice features of the PowerToys app.

Then you can easily access all the color codes on your screen, not just Power BI. You can download the Power Toys app from the link

below.https://docs.microsoft.com/en-us/windows/powertoys/install

--

--

Plan Guide can be described as a predefined plan for SQL Server.

Execution Plan occurs according to the parameters that I added in this Guide.

This allows you to perform Performance Fixes without interfering with the query.

Örnek : EXEC sp_create_plan_guide

@name = N’Guide-PLE’,

@stmt = N’SELECT TOP 1 *

FROM [dbo].[DOCple]

ORDER BY 1 DESC’,

@type = N’SQL’,

@module_or_batch = NULL,

@params = NULL,

@hints = N’OPTION (MAXDOP 1)’

Sonuç :

--

--

SQL Server Profiler is an interface used to track incoming connections to SQL Server, analyze and reuse trace results. In any problem with the server, the recordings that fall to the monitor can be recorded and reviewed again.

SQL Server Profiler can be opened from within the SSMS through the…

--

--

A common mistake made by administrators and developers when creating a search index is to select all available properties for fields instead of just selecting the required properties. For example, a field must be full-text searchable, or you can skip it when you set the searchable attribute.

In summary, the consequences of excessive attribution are as follows:

1. Creates a larger surface that each query must cover.

2. Increases operating costs due to additional storage.

In most cases, it exceeds the attributable and limits the properties of the field.

--

--