Azure SQL Limitations compared with a SQL Server Enterprise
In this article, we will compare a traditional SQL Server Enterprise Edition with an Azure SQL Database and see the differences.
2016-07-26
15,119 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
Power BI to Azure SQL and Google Analytics
In this demo, we will give an introduction from 0 about Power BI and how to connect to Azure SQL Databases and Google Analytics
2016-07-05
1,364 reads
Data Mining Part 40: Big Data and Microsoft Data Mining
This article will introduce about big data and HDInsight and Hadoop.
2016-05-10
1,331 reads
Data Mining Part 39: Azure Machine Learning vs Microsoft Data Mining
In earlier chapters, we talked about the Microsoft Data Mining enemies. We will talk now about Microsoft Azure Machine Learning.
2016-05-04
2,024 reads
Data Mining Part 38: Text Mining - The term lookup
In this new article, we will show how to use the SSIS term lookup transformation tool.
2016-04-27
1,991 reads
Data Mining Part 37: The Data Mining query transformation task
This new chapter will show you how to work with the SSIS Data Mining Query Transformation Task
2016-04-14
2,540 reads
New toys in SQL Server 2012
In this article we are going to look two new enhancements: the Insert snippet menu option and the surround with option.
2014-09-01 (first published: 2012-05-15)
18,721 reads
11 Tips to Backup databases with SMO, VB, C# Powershell, Command lines
Sometimes we need to create backups using code. Sometimes we need to do it manually or automatically, programmatically using C#, VB, Powershell.
2012-08-14
7,614 reads
The User Defined Server Roles in SQL Server 2012
This article describes how to create user defined server roles and use stored procedures and queries related.
2012-05-25
4,575 reads
New features in SQL 2012, the contained database
This article describe the problems about the migration of the databases and logins and the new feature contained databases
2012-05-22
10,868 reads
Blogs
Post-quantum key exchange – Insurance policy for your packets
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Plan your 2026
By Brian Kelley
If you don't have a plan, you'll accomplish it. That's not a good thing.
Another Change
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
Forums
Where Your Value Separates You from Others
Comments posted to this topic are about the item Where Your Value Separates You...
Fixing the Error
Comments posted to this topic are about the item Fixing the Error
T-SQL in SQL Server 2025: Encoding Functions
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Fixing the Error
On SQL Server 2025, I have a database that has this collation: SQL_Latin1_General_CP1_CI_AS. I decide I want to run this code:
SELECT UNISTR('*3041*308A*304C*3068 and good night', '*') AS 'A Classic';
I get this error:Msg 9844, Level 16, State 4, Line 24 The char/varchar input type uses an unsupported collation. Only a UTF8 collation is supported with char/varchar input type in UNISTR function.What is the easiest way to fix this error? See possible answers