Aashish @aa_sh_is_h

Exploring Web ! Planet Earth Joined May 2023

Tweets

65
Followers

7
Following

51
Likes

61

Aashish @aa_sh_is_h

2 years ago

[D60] - Identify the performance capabilities of Azure SQL - Configure and maintain the performance features of Azure SQL - Monitor and troubleshoot performance in Azure SQL - Improve performance with intelligent insights #60DaysOfLearning2023 #LearningWithLeapfrog #LSPPD60

0 0 3 88 0

Download Image

Aashish @aa_sh_is_h

2 years ago

[D59] - Manage and deliver access management and authorization. - Protect, encrypt, and mask data. - Manage and monitor security for your Azure SQL Database. #60DaysOfLearning2023 #LearningWithLeapfrog #LSPPD59

0 0 5 103 0

Download Image

Aashish @aa_sh_is_h

2 years ago

[D58] - Deploy and verify Azure SQL by using common tools and interfaces. - Configure Azure SQL after deployment. - Load data into Azure SQL. #60DaysOfLearning2023 #LearningWithLeapfrog #LSPPD58

0 0 1 63 0

Download Image

Aashish @aa_sh_is_h

2 years ago

[D57] Started preparing for [Microsoft Certified: Azure Fundamentals] Exam - Introduction to Azure SQL, - Describe cloud service types, - Describe the benefits of using cloud services. #60DaysOfLearning2023 #LearningWithLeapfrog #LSPPD57

0 0 3 88 0

Download Image

Aashish @aa_sh_is_h

2 years ago

[D56] SQL Server Reporting Services (SSRS) - a reporting tool provided by Microsoft which is used to produce formatted reports such as graphs, tables of data, and charts. - Why SSRS? - What is Data visualization? #60DaysOfLearning2023 #LearningWithLeapfrog #LSPPD56

0 0 1 45 0

Download Image

Aashish @aa_sh_is_h

2 years ago

[D55] - How SSIS works? - Operational Data - ETL #60DaysOfLearning2023 #LearningWithLeapfrog #LSPPD55

0 0 1 25 0

Download Image

Aashish @aa_sh_is_h

2 years ago

[D54] SQL Server Integration Service - What is Data Integration? - Advantages of Data Integration: - Why SSIS? #60DaysOfLearning2023 #LearningWithLeapfrog #LSPPD54

0 0 3 38 0

Download Image

Aashish @aa_sh_is_h

2 years ago

[D53(54)] - STUFF() Function : used to delete a portion of characters of a specific length #60DaysOfLearning2023 #LearningWithLeapfrog #LSPPD53

0 0 0 16 0

Download Image

Aashish @aa_sh_is_h

2 years ago

[D52(53)] - SQL Server Collation : predefined set of rules that determine how data is saved, accessed, and compared. - Instance level collation - Database level collation - Column level collation - Query level collation #60DaysOfLearning2023 #LearningWithLeapfrog #LSPPD52

0 0 0 14 0

Download Image

Aashish @aa_sh_is_h

2 years ago

[D51(52)/60] - SQL Server System Dirty Read. #60DaysOfLearning2023 #LearningWithLeapfrog #LSPPD51

0 0 0 20 0

Download Image

Aashish @aa_sh_is_h

2 years ago

[D51(50)/60] SQL Server System Functions - TRY_PARSE - Convert datetime to string, - Convert string to datetime, - Convert datetime to date, #60DaysOfLearning2023 #LearningWithLeapfrog #LSPPD50

0 0 1 17 0

Download Image

Aashish @aa_sh_is_h

2 years ago

[D50 (49)] SQL Server System Functions - ISNUMERIC - IIF - TRY_CAST - TRY_CONVERT #60DaysOfLearning2023 #LearningWithLeapfrog #LSPPD49

0 0 1 14 0

Download Image

Aashish @aa_sh_is_h

2 years ago

[D48/60] SQL Server System Functions - CAST Function - CONVERT Function - CHOOSE Function - ISNULL Function #60DaysOfLearning2023 #LearningWithLeapfrog #LSPPD48

0 0 1 11 0

Aashish @aa_sh_is_h

2 years ago

[D47/60] [SQL Server] - Removing user-defined functions - Practiced some SQL exercises #60DaysOfLearning2023 #LearningWithLeapfrog #LSPPD47

0 0 0 10 0

Download Image

Aashish @aa_sh_is_h

2 years ago

[D46/60] SQL Server Table Variables - Creating, Executing, Modifying a table-valued function - Multi-statement table-valued functions (MSTVF) #60DaysOfLearning2023 #LearningWithLeapfrog #LSPPD46

0 0 0 11 0

Download Image

Aashish @aa_sh_is_h

2 years ago

[D45/60] SQL Server Table Variables - Inserting, Querying data into the table variables - Using table variables in user-defined functions #60DaysOfLearning2023 #LearningWithLeapfrog #LSPPD45

0 0 1 23 0

Download Image

Aashish @aa_sh_is_h

2 years ago

[D44/60] SQL Server User-defined Functions - Allow you to encapsulate complex formula or business logic and reuse them in every query. #60DaysOfLearning2023 #LearningWithLeapfrog #LSPPD44

0 0 1 19 0

Download Image

Aashish @aa_sh_is_h

2 years ago

[D43/60] - Dynamic SQL in SQL Server A programming technique where you build SQL query as a string and execute it dynamically at runtime. #60DaysOfLearning2023 #LearningWithLeapfrog #LSPPD43

0 0 2 29 0

Download Image

Aashish @aa_sh_is_h

2 years ago

[D42/60] Handling Exceptions in Stored Procedure: - TRY CATCH - RAISERROR - THROW #60DaysOfLearning2023 #LearningWithLeapfrog #LSPPD42

0 0 1 12 0

Download Image

Aashish @aa_sh_is_h

2 years ago

[D41/60] Stored Procedure: - Cursor: An object that enables traversal over the rows of a result set. It allows you to process individual row returned by a query #60DaysOfLearning2023 #LearningWithLeapfrog #LSPPD41