If you need to receive and process a large volume of of packets of data, such as telemetry, or event-log items, it may be worth considering Azure Event hubs. They aren't like traditional messaging but represent more of a stripped down one-way event processing system for large volumes of data. It could represent a good solution to an ever-present problem, but is it ready for production use? Rob Sheldon investigates.
Handle together SQL Server spatial data features and Reporting Service design tools to build a map-based interactive report.
We must learn to deal with the reality of our situation, along with the limitations.
Inadequate storage is one of the most common bottlenecks seen in subsystem performance. There are a number of reasons for poor storage performance, but measuring it and understanding what needs to be measured and monitored is always a useful exercise.
This metric is useful if you want to know exactly how much physical space a particular table is taking up, including the size of its indexes.
DacPacs have been around for a while but DBAs have not, in the past, taken them particularly seriously. Is it time to get involved and influence the way the technology develops?
SQL Server Databases are made up of physical and logical names. This article goes over the logical names, where you might need to know them, and then how to change them.
One important skill is for the DBA or developer of the future is being sure they can present data to clients in a way they can use it.
In this article, Daniel Farina shows how to speed up SSIS package execution by using the Balanced Data Distributor Transformation.
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Hi experts, I have a 3+ TB database on a 2019 sql server which...
Comments posted to this topic are about the item The North Star for the...
Comments posted to this topic are about the item Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers