Design and Implement Complex Event Processing By Using Azure Stream Analytics (15-20%) Ingest data for real-time processing What is Stream[…]
Read moreLatest Posts
Exam 70-774: Perform Cloud Data Science with Azure Machine Learning
Prepare Data for Analysis in Azure Machine Learning and Export from Azure Machine Learning Import and export data to and[…]
Read moreLeadership Tips set – 1
Approach-ability : Spend time with the team informally Do one on one with the team Use informal language outside meeting[…]
Read moreSQL Server -DBA Must Know commands
Following are couple of DBA must know commands. –Get the db details EXEC SP_HELPDB ‘Db_name’ –know the definition of the objects EXEC SP_HELPTEXT ‘object_name’ –Identify the size of database and table EXEC SP_SPACEUSED –Know the details of the disk drives EXEC MASTER..XP_FIXEDDRIVES —Quick view of SQL server sessions EXEC SP_WHO2 –It’s advanced version of sp_who2 but not shipped with SQL server.Get it from the following link. EXEC SP_WHOISACTIVE[…]
Read moreExam 70-461 Notes – Set Theory
Ordered list of returned result set is called Cursor. Without “order by” clause query doesn’t return results in particular order even[…]
Read moreSQL Server Tuning – Top 10 high memory consuming Queries
Problem Statement: Script to find top 10 high memory consuming Queries. Solution: SELECT TOP 10 Object_name(qt.objectid) AS ‘SP Name’, Substring(qt.text, ( qs.statement_start_offset / 2 ) + 1, ( ( CASE qs.statement_end_offset WHEN -1 THEN Datalength(qt.text) ELSE qs.statement_end_offset END[…]
Read moreAzure 70-775: Big Data Engineering with HDInsight
1) Administer and Provision HDInsight Clusters Deploy HDInsight clusters Create a cluster in a private virtual network, create a cluster[…]
Read more