Category Archives: SQL Server

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

Optimizing SCCM Databases Revisited

Since Optimizing ConfigMgr databases was published in May 2013, I have received some tremendous feedback, all positive. The basics of that original post have not changed, Ola Hallengrens Index Optimization scripts, hands down, is the best solution for 99% of … Continue reading

Posted in ConfigMgr, SQL Server | 7 Comments

Why you should not use the ConfigMgr rebuild index task

Rebuilding the database indexes is a good thing, yes? Absolutely. Why not use the ConfigMgr rebuild index maintenance task? When the maintenance task works, and I have proof that some of the time it fails to run on ConfigMgr: It … Continue reading

Posted in ConfigMgr, SQL Server | 2 Comments

SQL Server 2005 End of Life resources

Received an email today from Microsoft with some useful links and resources.   Extended support for SQL Server 2005 ended on April 12, 2016, which means you’ll no longer get security updates and hotfixes and could be at risk of … Continue reading

Posted in SQL Server, SQL Server 2014, SQL Server 2016 | Leave a comment

Upgrade from Oracle to SQL Server – free licenses

Just learned about an attractive offer from Microsoft to migrate Oracle, DB2 and a few others to SQL Server 2016 and get free licenses. You’ll need to purchase SA (Software Assurance), however, the cost savings can be fairly substantial! SQL … Continue reading

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