(Grant Fritchey) T-SQL provides lots of functions that help to make data entry through T-SQL much more powerful. Over time you won’t be typing everything into T-SQL directly as we’ll do here. You’ll be able to use stored procedures and parameters to automate the use of scripts. These will also be ge

(Hannes du Preez) You can handle errors in T-SQL almost the same way as in C# or Visual Basic. You can make use of a Try and catch block to trap errors and provide feedback on the error.

(Arun Sirpal) Six months ago how you would go about setting up Active geo replication for your SQL Databases would be different to today, yes things (naturally) do change but for this specific area it has changed for the better – again something that you would expect right?

(Pinal Dave) Those who are my regular clients would know that I am very active in replying to emails. My average time of response is around 24 minutes. Many of the emails are for suggestions and I don’t get much time to help everyone, but I do reply to them letting them know the alternatives.

(Chris Webb) Last week I was working on a Power BI custom data connector for a customer and I came across a problem that has been bothering me for a while.

(Troy Ault) Over the past few months several individuals/customers have asked me for updated examples of the latest xSQLServer Resource. As of this post, the current version is 8.2.0.0. Throughout this post I will provide reference to configurations which are actually calling composite resources.

(Thomas LaRock) Last month there were a plethora of announcements coming out of Microsoft Ignite. So many announcements that it was hard to keep up with everything. James Serra (blog | @JamesSerra) did a good job detailing the data platform announcements here.

(Koen Verbeeck) With the release of SQL Server 2016, several improvements were shipped for Analysis Services Tabular. A couple of key enhancements were made to the DAX language; the scripting and querying language for Tabular models. In this tip, we’ll give an overview of these new features.

(Pinal Dave) In my lab setup, I already have a 2 node windows 2012 R2 cluster. I already had one SQL server 2012 instance is working fine without issues. However, when I was trying to install a new additional SQL 2012 instance, the installation reached till the last phase and getting failed with err

(Edwin Sarmiento) In a previous tip on Implementing Database Mirroring in SQL Server 2005 across domains, we have seen how we can configure Database Mirroring to achieve local high availability for SQL Server databases that are not joined to an Active Directory domain. We need to upgrade our SQL Ser