(Pinal Dave) Recently SQL Complete add-in was updated, which I use when writing SQL queries in SSMS. In the product history I saw that a several features were added, such as code refactoring or automatic semicolon insertion.

(Edwin Sarmiento) In part 1 of this tip series, we discussed the preliminary steps for setting up a Windows Failover Cluster for SQL Server Analysis Services. In this tip, we will look at how to add a secondary node to the cluster for SQL Server Analysis Services.

(Pinal Dave) You might have seen on Facebook that I have completed the new setup of my machines. Since I use VMs to do my tests. To have a domain, I made a VM as domain controller and another as a member server.

(K. Brian Kelley) I know that best practices say to secure the SQL Server sa account. However, I’m not sure what all I should to do to protect my SQL Servers. What steps should I take?

(Pinal Dave) Cloud is inevitable. With various innovations happenings in this area, SQL Server is not left behind. It is becoming a first class citizen when it comes to moving to cloud.

(John Pertell) In the last few posts I’ve gone over installing the components you need to run R in a SQL 2016 instance as well as some simple scripts that played with one of the data sets that’s included with R. Today we’ll start working with data stored inside a SQL database.

(Kenneth Fisher) The transaction log is made up of one or more files that are used sequentially. So in other words if you have multiple log files then new log information will only be written within one of those files at a time.

(Ed Elliott) When developing stored procedures in SSDT it is important to know when you have written a query that is potentially slow or has a high IO or CPU cost but there is no real way other than examining the the tables you are querying and understanding the data volumes and indexes whether they

(Ghanesh Prasad) You created a report for your client and the report default sorting is in descending order which was applied at the dataset level. But what if the client wants to see the data in ascending order? Or what if the client wants to be able to switch back and forth as needed?

(Karen Lopez) I have a couple of presentations where I describe how generalized data modeling can offer both benefits and unacceptable costs. In my Data Modeling Contentious Issues presentation, the one where we vote via sticky notes, we debate the trade-offs of generalization in a data model and d