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
886 reads
Learn how to use the CData MySQL connector to access data across SSH.
2021-08-18
886 reads
Phil Factor demonstrates the bare essentials of SC...
2019-05-22
This book aims to teach you Azure in around 20 hours, how does it fare?
2019-05-07
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
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
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
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
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
It's out now for Windows 10, with other operating systems coming later.
2019-04-08
A look at Idera's Diagnostic Manager and how it can help you diagnose performance issues on your server instance.
2010-10-05
2,011 reads
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
By Kevin3NF
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve...
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
Comments posted to this topic are about the item How a Legacy Logic Choked...
I've written this code, but it is showing right now as 2 rows per...
Comments posted to this topic are about the item Getting In: Running External Code...
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers