Connect to MySQL Through SSH Using the CData MySQL Driver
Learn how to use the CData MySQL connector to access data across SSH.
2021-08-18
594 reads
Product and Book Reviews
Simple Steps in SQL Change Automation Scripting
Phil Factor demonstrates the bare essentials of SC...
2019-05-22
Book Review: Learn Azure in a Month of Lunches
This book aims to teach you Azure in around 20 hours, how does it fare?
2019-05-07
Book Review: Mastering .NET Machine Learning
This is a review of Jamie Dixon’s book Mastering .NET Machine Learning. For the sake of transparency, Jamie is a friend and if I hated his book I wouldn’t...
2019-04-25
Free SQL Server Load Testing Tools
So you wanna run a load test against SQL Server. One thing I need you to understand first: you have to provide the database and the queries. Almost all...
2019-04-22
HowTo: Install SSIS Framework Community Edition
SSIS Framework Comunity Edition is available from DILM Suite (Data Integration Lifecycle Management Suite). SSIS Framework CE is not only free, it is open source. To install SSIS Framework...
2019-04-22
SQL Clone for Unit Testing Databases
Phil Factor demonstrates how to use SQL Clone to create 'disposable' SQL Server databases, for development and testing work. You can spin up a clone, use it to unit...
2019-04-12
Monitoring your servers and databases: SCOM and SQL Monitor
SCOM is is good at monitoring the status of your servers. SQL Monitor give you a detailed view of your SQL Server instances, and databases, right across your network,...
2019-04-12
Hands-on: First public previews of Chromium-based Edge are now out
It's out now for Windows 10, with other operating systems coming later.
2019-04-08
Idera SQL Diagnostic Manager 6.2 Review
A look at Idera's Diagnostic Manager and how it can help you diagnose performance issues on your server instance.
2010-10-05
1,998 reads
Blogs
Microsoft Announcement: Microsoft Fabric
Yesterday at Microsoft Build, a significant announcement took place—the introduction of Microsoft Fabric, which...
Introduction to SQL Server Query Store
Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and...
Flyway with Multiple Folders
By Steve Jones
A customer asked about how they could organize their migration scripts in different ways...
Forums
Availability Group database went into 'Restoring' state
Dear Friends, Please advise why would one of my Availability Group databases go into...
Access db
Access db wanting to move sql server, how much control does business have over...
Ask SSC