Display SSIS package version on the Control Flow design surface
In this article I will show a simple trick to display version information on the Control Flow surface, so we immediately see which version and build we are modifying.
Starting to Use SQL Server 2017
Today Steve Jones looks forward to the next version of SQL Server, with his curiosity to see if you feel the same way.
Getting Started with Azure SQL Data Warehouse - Part 3
Microsoft introduced Azure SQL Data Warehouse, a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. In this article, Arshad Ali discusses the different types of tables you can create in SQL Data Warehouse, how they impact performance and the best practices around them.
SQL Server on Linux is Just SQL Server
Steve Jones looks at SQL Server on Linux and how this may differ from what most of us have worked with in the past.
Doing Fuzzy Searches in SQL Server
A series of arguments with developers who insist that fuzzy searches or spell-checking be done within the application rather then a relational database inspired Phil Factor to show how it is done. When the database must find relevant material from search terms entered by users, the database must learn to expect, and deal with, both expected and unexpected.
Becoming a Data Scientist
The path to becoming a data scientist isn't simple or easy, but it might be for you.
How to setup a tabular data model in SSAS Azure
Microsoft announced the availability of SQL Server Analysis Services (SSAS) on Azure late last year. Siddharth Mehta walks through how to quickly set up a tabular data model in SSAS Azure.
Building Dynamic React Apps with SQL Server Data
This article demonstrates using React and the CData API Server to build dynamic Web pages using SQL Server data.
Have you ever given up on your brainchild
Have you ever given up on your brainchild? If yes, how did you deal with it?
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
BCA KCP Tomang Raya Tlpn/wa0853.7373-7551
Jl. Tomang Raya No.64, Jatipulo, Kec. Palmerah, Kota Jakarta Barat, Daerah Khusus Ibukota Jakarta...
BCA KCU KEDOYA PERMAI Tlpn/wa0853.7373-7551
Ruko Taman Kedoya Permai, Blok A 1A, No No.4-5, RT.11/RW.5, Kb. Jeruk, Kec. Kb....
BCA KCP Dumai TLP/WA 08216977749
Jl. Jend. Sudirman No.90, A-B, Kec. Dumai Tim., Kota Dumai, Riau 28813
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers