(Grant Fritchey) In the previous Database Fundamentals, I argued that you should be learning T-SQL, yet the very next post I’m showing you how to use the GUI. What’s up?

(Kenneth Fisher) Last month your homework was to set up your own lab. Now it’s time to put a sample database or two on at least one SQL instance. Microsoft has provided copies of AdventureWorks for years and recently switched over to Wide World Importers.

(Pinal Dave) If you take the normal approach to create a linked server to SQL Azure Database, then you would end up in below error message.

(Jack Vamvas) Question: I can see error messages in the SQL Server Error Log such as “AppDomain xxxxxxxxxxxxx is marked for unload due to memory pressure”.

(Arun Sirpal) Did you know that SQL Server tracks suspect pages and puts the details into the msdb database in a table called suspect_pages? Well it does, but the question I want answering is what happens if the page within the suspect pages table is fixed?

(Kun Cheng) Most people familiar with Azure SQL DB (aka SQL Database) are aware of the firewall setting requirements of SQL DB, which are very important to lock down connections to SQL DB on Azure.

(Melissa Coates) This post is a continuation of the blog where I discussed using U-SQL to standardize JSON input files which vary in format from file to file, into a consistent standardized CSV format that’s easier to work with downstream. Now let’s talk about how to make this happen on a schedule w

(Pinal Dave) I have already made a post on SQL SERVER – UDF – Remove Duplicate Chars From String where I showed you a method of removing duplicate characters form alphanumeric string. The UDF uses WHILE LOOP to extract the numbers.

(Chris Webb) Something that I have vaguely known about for years (for example from Mosha’s post here), but somehow never blogged about, is that using the Root() function in MDX calculations is not great for performance.

(Kenneth Fisher) There are a fair number of options settings. ANSI_NULLS, ARITHABORT, QUOTED_IDENTIFIER, etc. Each session has its own set of configurations. They are initially set based on the user settings system configuration, then the various connection programs (SSMS for example) can override t