What are @@IDENTITY, SCOPE_IDENTITY and IDENT_CURRENT? What are the differences?They allow us to find the last identity value produced when working with tables containing identity columns.Apr 6, 2022Apr 6, 2022
XP_LOGININFOxp_logininfo is a system stored procedure that allows you to see the contents and types of permissions for user groups defined in SQL…Apr 6, 2022Apr 6, 2022
Grouping Data in Power BIAs 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…Apr 6, 2022Apr 6, 2022
Auto Update StatisticsSQL Server Query Optimizer uses statistics during query compilation to help determine the optimal query plan. By default, if the optimizer…Apr 6, 2022Apr 6, 2022
BACKUP OPTIONS IN AZURE SQL VIRTUAL MACHINES- Method 1 — Create a different disk on the virtual machine and make backups onto it — Method 2 — Importing SQL backups onto Azure…Apr 6, 2022Apr 6, 2022
Easy access to color codes with PowerToys.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…Apr 6, 2022Apr 6, 2022
What is Plan Guide?Plan Guide can be described as a predefined plan for SQL Server.Apr 6, 2022Apr 6, 2022
Using SQL Server ProfilerSQL Server Profiler is an interface used to track incoming connections to SQL Server, analyze and reuse trace results. In any problem with…Apr 6, 2022Apr 6, 2022
How is connection authorized for SQL Integration Services (SSIS)?First, the user to be authorized must be a Windows user, not a SQL local user.Apr 6, 2022Apr 6, 2022
How to be selective about space attributributable in Azure?A common mistake made by administrators and developers when creating a search index is to select all available properties for fields…Apr 6, 2022Apr 6, 2022
