With the launch of Microsoft Fabric, a unified analytics platform, many professionals are asking if it can replace traditional tools like SQL Server. While Microsoft Fabric is a game-changer for modern analytics, it is not designed to replace SQL Server. Instead, it complements SQL Server by adding advanced capabilities for large-scale data processing and analytics. Let’s explore the differences and how they work together. What is Microsoft Fabric? Microsoft Fabric is a fully integrated analytics platform that brings together data ingestion, engineering, integration, machine learning, and visualization under one ecosystem. Key components include: It’s a cloud-native platform designed for end-to-end… Read more
Tag: SQL Server
Keyboard shortcuts for SQL Server Management Studio (SSMS)
Here are some useful keyboard shortcuts for SQL Server Management Studio (SSMS) that can enhance your productivity: These shortcuts can save you time and make your SQL Server management tasks more efficient.
ACID Properties
In the context of database transaction processing, the acronym ACID refers to the four key properties of a transaction: • Atomicity • Consistency • Isolation • Durability Atomicity : All changes to data are performed as if they are a single operation. That is, all the changes are performed, or none of them are.For example, in an application that transfers funds from one account to another, the atomicity property ensures that, if a debit is made successfully from one account, the corresponding credit is made to the other account. Consistency : data is in a consistent state when a transaction starts and when… Read more
Types of SQL Server Backup -1 : FULL Backup
The most common types of SQL Server backups are complete or full backups, also known as database backups. These backups create a complete backup of your database as well as part of the transaction log, so the database can be recovered. This allows for the simplest form of database restoration, since all of the contents are contained in one backup. A full backup can be completed either using T-SQL or by using SSMS Create a full backup of the AdventureWorks database to one disk file T-SQL BACKUP DATABASE AdventureWorks TO DISK = ‘C:\AdventureWorks.BAK’ GO SQL Server Management Studio Right click… Read more
SQL Server Backup Types
The different types of backups that you can create are as follows: Full backups Differential backups File backups File group backups Partial backups Copy-Only backups Mirror backups Transaction log backups we will discuss one by one in detail in next posts.
SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio
By default, SQL Server system objects are listed in Object Explorer in Management Studio. These system objects include system database, system tables/views/procedures and so on. SQL Server Management Studio provides an option to hide these objects from Object Explorer to prevent *accidental* use. To enable this option follow below steps. Step1: Go to Tools > Options Step2: Navigate to Environment > Startup Step3: Check Hide system objects in Object Explorer and click OK: Step4: An confirmation message will be displayed saying that changes will take effect after Management Studio is restarted, click on OK to continue: Once you restart SQL Server Management Studio, you will notice that system objects are no longer listed in… Read more