(Jack Vamvas) Question: How can I monitor SQL Server blocked processes with a SQL Server alert and capture the details for analysis. I’d like the alert to trigger when there is more than one blocked process.

(jacob jerry) With Azure SQL Database, you can easily change service tiers and performance levels dynamically without downtime. Basic, Standard, and Premium are the 3 service tiers with multiple performance levels to handle different workloads.

(Ahmad Yaseen) How can we control the number of processors assigned to the SQL Server DBCC CHECKDB command in order not to consume all of the server’s resources when CHECKDB is running?

(Zafar Ali) If your organisation is committed to using Oracle Business Intelligence Enterprise Edition (OBIEE) 10g/11g /12c as their BI solution, you aren’t thereby committed to using Oracle throughout your organisation. You can use a range of data sources including SQL Server, and save a great deal

(Pinal Dave) Over a period, I have learned that fixing an issue is easier if we know which log we should look at and what we should search on google.

(Arshad Ali) Advance Analytics is becoming the norm now. Every organization wants to use the power of advanced analytics to predict future outcomes and take proactive corrective measures to remain competitive and win over its competitors.

(Arun Sirpal) NOLOCK, some say it’s a fast option for queries and will never cause blocking, I say it’s quite dirty and MAY cause blocking.

(Manoj Pandey) In one of my [previous post] I discussed about a new function STRING_SPLIT() introduced in SQL Server 2016, which splits a Sentence or CSV String to multiple values or rows.

(Steve Pucelik) SQL Server is a major component of any SharePoint installation simply because it stores all the configuration, content and really anything SharePoint needs to interact with users. Given this, sufficient thought should be given to:

(Erica Woods) We continue to see an increase in requests for quality communication in candidates, even with highly technical roles. Technical candidates need to have both a strong technical acumen and strong communication/soft skills in order to gain an edge in the job market.