Microsoft (StreamInsight), and Azure Stream Analytics represent a very different model for processing data. They are concerned with processing complex event streams of data (CEPs) from such things as sensors to deduce significant patterns and apply filters. Joe Celko discusses the background to an intriguing technology of complex event processing to establish the difference between data at rest, and data on the move.
2017-10-03
3,971 reads
Brent Ozar looks at the similarities between SQL Server on Linux and SQL Server on Windows Core from back in 2012, and asks whether DBAs should bother learning it.
2017-10-02
4,169 reads
By default, SQL Prompt shows code auto-completion suggestions automatically, and continuously. 90% of the time this is exactly what you want, but there are other times where you just need a bit of space - Phil Factor shows how.
2017-10-02
2,880 reads
Deploying IaaS solutions in Microsoft Azure offers benefits that leverage agility, resiliency, and scalability built into the underlying platform. However, when dealing with business-critical workloads, customers typically want to also provide high-availability and disaster recovery capabilities in a manner that they can control. Trying to implement this approach in the cloud by following the procedures applicable in on-premises datacenters frequently presents challenges. This article focuses on these differences in the context of deployment of SQL Server Failover Clustering in Azure.
2017-09-29
3,141 reads
This post is going to walk you through the process of creating an SQL Management Server.
2017-09-28
9,062 reads
How difficult can it be to produce a simple hierarchical list in JSON, YAML, XML and HTML from a SQL Server table that represents a simple hierarchy within an organisation. Well once you know, it is easy and William Brewer is on a mission to tell you how.
2017-09-28
6,087 reads
Matteo Lorini shows how to setup a project in SSMS to organize files.
2017-09-27
4,539 reads
In Azure SQL Data Warehouse we can use BCP to export or import the data. In this article, we will show how to do it.
2017-09-26
2,206 reads
Brent Ozar, Erik Darling, and Tara Kizer think about what they would change or fix if they had access to SQL Server’s source code.
2017-09-26
3,774 reads
A note of caution on the use of sp_helptext to script out objects.
2017-09-25
2,803 reads
It is Friday, the queries are running, and nobody is watching the bill. That...
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Comments posted to this topic are about the item Midjourney, Healthcare?
Comments posted to this topic are about the item Changes, Happiness, and a Few...
Comments posted to this topic are about the item BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers