(Jagmeet Chaudhary) This is the first post in a two part series which I am planning to write on full text search .In this post I will give a brief introduction on full text search and explain how to configure it in SQL Server 2012.

MDX is a language that enables to query multidimensional databases similar to the way SQL is used to query relational databases.

(John Savill) Q: I’m trying to connect to SQL Server via SQL Server Management Studio on the local SQL Server machine. Even though I’m a systems admin on the machine, the logon fails; why?

(Pinal Dave) The next in line in this series of reports is the “Memory Consumption” Report from SQL Server Management Studio. This is a goldmine of a report in my humble opinion and lesser respected.

(Benjamin Athawes) On 9th July 2014, Microsoft published an article titled Microsoft Azure Continues to Deliver Rapid Innovation in the Cloud . Amongst other announcements, that article introduced the idea of templates within Azure Infrastructure as a Service (IaaS) for multi-machine/tier applicatio

(Jeff Sanders) In my early testing I wanted to always seed my Local Database. By default the db was only dropped and reseeded if you changed the models. There is a simple code change to do this.

(Dwain Camps) A lot of numbers that we use everyday such as Bank Card numbers, Identification numbers, and ISBN codes, have check digits. As part of the routine data cleansing of such codes we must check that the code is valid- but do we?

(Rick Dobson) My company receives names in a variety of different formats from business partners. The formatting for names varies substantially across business partners. However, the names need to be parsed into one consistent format to help with tracking details associated with persons.

(Mihail Mateev) In a series of articles will look at how to use Node.js with some of the most popular products and platforms like SQL Server, MongoDB, Microsoft Azure, how to create applications using jQuery, jQuery UI and Ignite UI with Node.js

(Tim Ford) One of the most important things to know as a database administrator when you get that dreaded call from someone in your organization or a client that “my database is slow,” is to understand what is currently running on the server in question.