Tag: SQL Server

All

#PowerShell – Setting SQL Server Memory ...

Apr 13, 2017

SCCM – Using Multiple SUPs, but clients ...

Feb 2, 2017

PowerShell – My way to prepare a S...

Dec 22, 2016

Preparing to Upgrade SQL Server? Data Mi...

Jul 25, 2017

Preparing to Upgrade SQL Server? Data Mi...

Aug 4, 2017

The Case of Troubleshooting and poor VM ...

Jun 13, 2019

How to Install Microsoft SQL Server 2019...

Dec 26, 2021

All Latest

How to Install Microsoft SQL Server 2019 Latest Cumulative Update

by Cary Sun | Dec 26, 2021 | Windows Server

Today, I am going to show you how to install Microsoft SQL Server Latest Cumulative Update.

The Case of Troubleshooting and poor VM Performance via Windows Admin Center – #MVPHour

by John O'Neill Sr. | Jun 13, 2019 | Windows Admin Center, Windows Server

Hey Checkyourlogs Fans, Today, I wanted to write a very quick post showing how you can use Windows...

Preparing to Upgrade SQL Server? Data Migration Assistant! Part 2 #MVPHour #SQLServer #DMA

by | Aug 4, 2017 | SCCM, Windows Server

Time to dive into Microsoft Data Migration Assistant. In this part of the DMZ log series, we’ll take a look at how we install DMA.

Preparing to Upgrade SQL Server? Data Migration Assistant! Part 1 #MVPHour #SQLServer #DMA

by | Jul 25, 2017 | Design, Windows Server

Datacenter’s and companies everywhere generally rely on a core piece of software to store their data and metrics, SQL Server. It’s nice to keep it up to date, but sometimes, and a lot of the time, if it’s not broken, don’t fix it. SQL Server has been around for quite a while, there are many databases hosted by SQL Server. Microsoft has released many upgrade advisors over the years, but recently the SQL Server team has overhauled their traditional SQL Server Upgrade Advisor and have created a new product – SQL Server Data Migration Assistant (DMA), which is different than SQL Server Migration Assistant (SSMA). To pull off a successful migration or upgrade, you need to do your detective work.

#PowerShell – Setting SQL Server Memory Allocation (Maximum and Minimum)

by | Apr 13, 2017 | Scripts, Windows Server

If you’ve ever run an installation of SQL Server, you’ll know it’s a database, and databases love, love, love memory. By design and by default, Microsoft SQL Server thinks it’s the only process on the system and is therefore given all the available memory and CPUs. As a best practice, I limit this. Here is the script I use to edit these values.

SCCM – Using Multiple SUPs, but clients aren’t switching

by | Feb 2, 2017 | SCCM, Scripts, Windows Server

One of the issues I’ve come across is using Configuration Managers (2012 R2+) feature of being able to deploy multiple Software Update Points (SUP) within a site. This scenario is essentially to avoid using traditional network load balancing (NLB) and offload the work to the clients. One would think, if one SUP is not available it’s pretty simple, switch to the next one in the list. Well this doesn’t always happen as one may expect. Why?

PowerShell – My way to prepare a SQL Server VM

by | Dec 22, 2016 | Scripts, Windows Server

As I get called on a lot of to do SQL Server installations, I’ve come up with what I’ve found works best for me. Every location has different infrastructure, security, networks and their way of doing things. Since I’m the one doing the installation, and I know I’ll get called back in the future at some point to upgrade, troubleshoot or manage the SQL Server environment, I like to have a set of standards. Documentation, I actually do enjoy writing it (yes I may be sick), but having a self-documenting PowerShell script is even better!

SCOM 2012 R2 – Data Warehouse Service Account is not allowed to access Data Warehouse database

by | Oct 23, 2015 | Creative, MVPDays, Uncategorized, Windows Server

Well today I logged into a customer’s site to deal with a SCOM issue in there SCOM 2012 R2 environment. The SCOM environment itself appeared to be working, but the data warehouse wasn’t being populated. This...