Clustering SSAS Part 2
Learn how to add a secondary node to a Windows Failover Cluster for SQL Server Analysis Services.
Edwin M. Sarmiento is the Managing Director of 15C, a consulting and training company that specializes on designing, implementing and supporting SQL Server infrastructures. He is a Microsoft SQL Server MVP and Microsoft Certified Master from Ottawa, Canada specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack ranging from Active Directory to SharePoint and anything in between. He is very passionate about technology but has interests in music, professional and organizational development, and leadership and management matters when not working with databases. Edwin lives up to his primary mission statement: "To help people and organizations grow and develop their full potential."
- MSSQLTips Awards: Champion Award (100+ tips) - 2017 | Author of the Year Contender - 2020, 2017
Clustering SSAS Part 1
In this tip we look at how to build a cluster for SQL Server Analysis Services.
Determine Minimum Possible Size to Shrink SQL Transaction Log File
I want to shrink the SQL Server transaction log file to reclaim disk space and reduce the number of virtual log files (VLFs) after I have scheduled regular transaction log backups. I checked the log file free space and ran DBCC SQLPERF (LOGSPACE) to verif
Introduction to Azure PowerShell Modules for the SQL Server DBA Part 2
Our organization is starting to deploy more virtual machines on Azure for both testing and DR environments. I would like to create and administer Azure virtual machines using Windows PowerShell. In this tip we show you how.
Modify SSRS Rendering Format In SharePoint-Integrated Mode
In a previous tip on Making Adjustments to SQL Server Reporting Services Configuration Files, we've seen how we can modify the rendering format of a Reporting Services report by making changes to the RSReportServer.config file. However, this does not work
Installing, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 4
In this fourth part of the series we look at additional PowerShell commands that can be used to install, configure and manage a Windows cluster for SQL Server.
Installing, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 3
In a previous tip on Install SQL Server 2008 on a Windows Server 2008 Cluster Part 2, we've seen how to install and configure a Windows Server 2008 Failover Cluster in preparation for installing a SQL Server 2008 failover clustered instance. This time, I
Installing, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 2
In a this tip I show how to use Windows PowerShell to install, configure and manage a Windows Server Failover Cluster from the command-line.
Introduction to Azure PowerShell Modules for the SQL Server DBA Part 1
Our organization is starting to deploy more virtual machines on Azure for both testing and DR environments. I would like to create and administer Azure virtual machines using Windows PowerShell. How do I get started? In this tip we cover several PowerShel
Force Start a Windows Server Failover Cluster Without a Quorum
The 2-node Windows Server Failover Cluster (WSFC) running my SQL Server failover clustered instance suddenly went offline. It turns out that my quorum disk and the standby node in the cluster both went offline at the same time. I could not connect to the
SQL Server Networking High Availability and Disaster Recovery Best Practices Webcast Q and A
We hosted a webcast on SQL Server and Networking High Availability/Disaster Recovery Best Practices on July 16th. We received several great questions we didn't have time to answer, so we wanted to take this opportunity to answer the questions via a tip.
Configuring TDE for SQL Server Always On Availability Groups
I want to implement TDE on my SQL Server 2012 databases and join them in an Availability Group. This can't be done using the SSMS GUI, so in this tip we walk through step by step how this can be done using T-SQL.
Installing, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 1
In a previous tip on Install SQL Server 2008 on a Windows Server 2008 Cluster Part 2, I've seen how to install and configure a Windows Server 2008 Failover Cluster in preparation for installing a SQL Server 2008 failover clustered instance. This time, I w
Check If a SQL Server Database Is In Pseudo-Simple Recovery Model Using Windows PowerShell
I wanted to know if my databases are really in FULL recovery model. I've heard about this recovery model called pseudo-simple where the database still behaves like it is still in SIMPLE recovery model until a full database backup is taken. How do I know i
Check DBCC CHECKDB Last Execution using PowerShell
I want to check when DBCC CHECKDB was last executed on all of my SQL Server databases. However, most of the solutions I see online involve the creation of temporary tables and/or a combination of techniques to get the date and time of the last DBCC CHECKD
Configure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using PowerShell
In a previous tip on Configure SQL Server 2012 AlwaysOn Availability Group Read-Only Routing using T-SQL, we have seen how we can configure read-only routing and to automatically redirect the read-only workloads to a secondary replica after a failover. In
Configure SQL Server Always On Availability Groups Read-Only Routing
In a previous tip on New SQL Server AlwaysOn Feature - Part 1 configuration, we have seen how we can configure AlwaysOn Availability Groups. AlwaysOn Availability Groups promise to maximize your IT investments by allowing read-only workloads on the second
Disable or Enable SQL Server Agent Jobs using PowerShell
In a previous tip on Disabling or Enabling SQL Server Agent Jobs, we have seen how we can disable or enable SQL Server Agent Jobs using T-SQL. However, in order to properly disable the SQL Server Agent jobs, we need to use the sp_update_job stored procedu
Check SQL Server Virtual Log Files Using PowerShell
In a previous tip on Monitor Your SQL Server Virtual Log Files with Policy Based Management, we have seen how we can use Policy Based Management to monitor the number of virtual log files (VLFs) in our SQL Server databases. However, even with that most of
SQL Server 2012 Multi-Subnet Cluster Part 4
In a previous tip on Install SQL Server 2008 on a Windows Server 2008 Cluster Part 1, we have seen how to install and configure a SQL Server 2008 on a Windows Server 2008 Failover Cluster. We now have a new requirement to deploy a SQL Server 2012 instance
SQL Server 2012 Multi-Subnet Cluster Part 3
In a previous tip on Install SQL Server 2008 on a Windows Server 2008 Cluster Part 1, we have seen how to install and configure SQL Server 2008 on a Windows Server 2008 Failover Cluster. We now have a new requirement to deploy a SQL Server 2012 instance o
SQL Server 2012 Multi-Subnet Cluster Part 2
In this tip we continue to look at how to install a multi-subnet cluster for SQL Server.
SQL Server 2012 Multi-Subnet Cluster Part 1
In a previous tip on Install SQL Server 2008 on a Windows Server 2008 Cluster, we have seen how to install and configure a SQL Server 2008 on a Windows Server 2008 Failover Cluster. We now have a new requirement to deploy a SQL Server 2012 instance on a m
Installing SQL Server 2012 on Windows Server Core Part 3
Windows Server Core has been around since Windows Server 2008. I have been wanting to install SQL Server 2008 on Windows Server Core but could not do so because it wasn't officially supported. However, SQL Server 2012 now is. In this tip series we walk th