Category Archives: SQL Server

TSQL2sday #94–SQL Server and PowerShell

T-SQL Tuesday (#tsql2sday), I’ve been absent for a few, figured it was time to jump back in! SQL and PowerShell, what a great combination. First, let me thank the sponsor, you can find his site from the following link. One … Continue reading

Posted in PowerShell, SQL Server | Leave a comment

Installing Power BI Report Server

Thought I’d post my initial impressions of installing Power BI Report Server. Unless you’ve been disconnected from the web for any length of time, you’ve heard of Power BI. In May 2017, Microsoft released the Power BI Premium service tier, … Continue reading

Posted in Power BI Report Server, PowerBI, SQL, SQL Server | Leave a comment

Properly configure SQL Server ConfigMgr database

Ideally, this will take place before you install ConfigMgr! First, estimate size(s) of the databases: SCCM SUSDB TempDB – see prior article for more detail How? Use the  SCCM DB Sizing estimator! Shown is an example of the Database sizing … Continue reading

Posted in ConfigMgr, SQL, SQL Server | 6 Comments

Supported SQL Server versions for SCCM CB upgrades

Had a question recently on what version of SQL Server is supported for upgrade to SCCM CB (current branch). Scenario was this; client was running SQL 2012 SP2 for their SCCM 2012 R2. However, in order to upgrade to SCCM  … Continue reading

Posted in ConfigMgr, SQL Server | 4 Comments

SQL Backup to URL (Azure Storage account)

How to backup up a copy of an on premise database, or Azure SQL Server database to an Azure Storage account. Notes: Any names that need to be added at time of creation are indicated with <>, such as <sqlstorageaccountname> … Continue reading

Posted in Azure SQL Server, SQL Server | Leave a comment

Azure SQL Migration Tools

In preparing a presentation for data migration to Azure, thought I’d share some of my research. There are other methods not specified here, but this should be a good start! Each toolset includes notes about that tool, and where to … Continue reading

Posted in Azure SQL Server, Migration, SQL Server | Tagged , | Leave a comment

SCCM File Backup Considerations

Everyone (hopefully) is aware that the SCCM database needs to be backed up. And, that there a number of other components that need to be backed up in order to have everything on hand in case there is a need … Continue reading

Posted in ConfigMgr, SCCM, SQL Server | 1 Comment