(Sergey Gigoyan) In this tip we compare Serializable and Snapshot transaction isolation levels. Both Serializable and Snapshot isolation levels exclude concurrency issues such as Dirty Reads, Non-repeatable Reads and Phantoms – which are also called phenomena in a RDBMS.

(Thomas LaRock) Database servers have a lot of moving parts, as do the applications built on top of any database platform. That’s why when it comes time to rebuild a server, or migrate systems to use new servers, it can be difficult to get everything correctly configured the first time through.

(Chris Webb) I’ve been meaning to look at Azure Data Catalog for a long time but somehow never got round to it until now. I’m not sure why – perhaps it’s because there’s so much other cool stuff happening in the world of Power BI and Azure, and Azure Data Catalog seems a bit, um, boring in compariso

(Manoj Pandey) Sometimes it get difficult or time-taking to get each and every SQL Job details, its schedule and other information. Also checking all these information in SSMS is time taking specially when your machine is running a client, and the server is located in some remote place.

(Pinal Dave) My friend was researching with SQL Agent parameters and after sometime he called me and told that he is not able to start SQL Agent service. Here was the error in SSMS which is about failed to initialize a SQL Agent log.

(Prashanth Jayaram) The requirement is to backup individual database and after successful backup the script should retain the most recent file and delete the rest from a directory for that specific database.

(Mark Broadbent) The new Azure Portal represents a huge improvement over the old Classic Azure Portal in terms of User eXperience and performance.

(Dave Ballantyne) Sometimes it does feel that a problem is a database problem until proven otherwise. When this does occur I have had to put a lot of time and effort into demonstrating the hows and whys. One of the easiest ( and most common ) scenarios of this is related to ASYNC_NETWORK_IO waits.

(Scott Murray) What are some of the functions in SSRS that allow me to interact with parameters?

(Pinal Dave) When there is an availability group, the replica would be either in primary state or secondary state – when its online in failover cluster manager. Resolving is an intermediate state when the transition is happening from primary to secondary or vice versa.