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
SQL Server Management Studio Query DesignerAfter a while, when you think you’re stuck between derailed tables and columns, you might want to visualize the tables we have and the…Apr 6, 2022Apr 6, 2022
TEMPDBIn SQL Server, tempdb is used for transient operations. Tempdb configuration should be very good for maximum performance, especially on…Apr 6, 2022Apr 6, 2022
Force Order QueryWhen querying data, SQL Server uses more than one query endpoint. One of them is FORCE ORDERApr 6, 2022Apr 6, 2022
DAX keyboard shortcuts in Power BIDax, the function language that allows us to perform calculations for analytical operations in Power BI, has useful shortcuts that will…Apr 5, 2022Apr 5, 2022
DAX keyboard shortcuts in Power BIDax, the function language that allows us to perform calculations for analytical operations in Power BI, has useful shortcuts that will…Apr 5, 2022Apr 5, 2022
DAX keyboard shortcuts in Power BIDax, the function language that allows us to perform calculations for analytical operations in Power BI, has useful shortcuts that will…Apr 5, 2022Apr 5, 2022
What’s Sp_Lock?You can also see the details of the SQL server when blocking occurs or by using the sp_lock procedure to see which objects are block in the…Apr 5, 2022Apr 5, 2022
WAL Concept at PostgreSQLWAL (Write Ahead Logging) is PostgreSQL’s Transaction-Log retention system. WAL is the process of registering transaction logs. PostgreSQL…Apr 5, 2022Apr 5, 2022
Read Only RoutingIn the SQL Server AlwaysOn structure, the primary server responds regardless of the purpose for which the request comes (read or change)…Apr 5, 2022Apr 5, 2022
QUERY STOREWhen examining the performance of a query in SQL Server, the first thing that comes to our mind is to look at the execution plan of the…Apr 5, 2022Apr 5, 2022