(Ed Elliott) The ScriptDom is an api for taking t-sql scripts, converting them into an AST or taking an AST and generating t-sql.

(Edwin Sarmiento) In a previous tip on Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 1, we have seen how to install and configure a SQL Server 2008 instance on a Windows Server 2008 Failover Cluster. We now have a new requirement to provide high availability to our SQL Server Ana

(Chris Webb) In a year’s time there will be a great opportunity for someone to present a session on “Power BI Development Best Practices” at the PASS Summit. Before then, we will all have to work out what those best practices actually are – probably the hard way.

(Melissa Coates) The Power BI Desktop tool now attempts to utilize bi-directional relationships when it can. If any ambiguity exists, some of your relationships may become inactive. If you are seeing inactive relationships (the dotted line), take a look in Advanced properties to see if the “cross fi

(Pinal Dave) Datetime datatype stores date and time part. If you have only date value, You can add time part to a datetime variable using direct literal value and + operator.

(Ed Elliott) This is probably the last contributor that I am going to add to the DacFx deployment contributors project (https://github.com/DacFxDeploymentContributors/Contributors/) for a little while, if anyone else has one they want to contribute please feel free. I have been pretty pleased with h

(Jack Vamvas) Question: We have been having issues with an application. We have a potential solution that involves using the spatial data type in SQL 2008 R2

(Greg Larsen) With the introduction of SQL Server 2016 you now have a new way to encrypt columns called Always Encrypted. With Always Encrypted, data is encrypted at the application layer via ADO.NET.

(Daniel Farina) You heard the news about the forthcoming release of SQL Server and its new features and improvements. One of the areas where there are enhancements is SQL Server Management Studio. In this tip I will show you those new features.

(Jason Brimhall) For me, some of the most fun stuff with SQL Server is diving deep into the internals. Diving into the internals is not always an easy adventure. Sometimes, it requires a lot of trial and error sometimes.