Additional Articles

The Basics of Good T-SQL Coding Style – Part 4: Performance

by Additional Articles

SimpleTalk

T-SQL

There are several obvious problems with poor SQL Coding habits. It can make code difficult to maintain, or can confuse your team colleagues. It can make refactoring a chore or make testing difficult. The most serious problem is poor performance. You can write SQL that looks beautiful but performs sluggishly, or interferes with other threads. A busy database developer adopts good habits so as to avoid staring at execution plans. Rob Sheldon gives some examples.

2017-10-05

6,056 reads

Understanding Azure Data Factory – A Cloud Based Integration Service

by Additional Articles

SQLServerCentral

Azure Data Factory

Azure Data Factory is a cloud based data integration service. This helps you to define, schedule and manage data pipelines to transfer and transform the data from disparate on premise and cloud data sources. Read on to learn more.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2017-10-04

2,470 reads

Data in Motion and Data at Rest

by Additional Articles

SimpleTalk

StreamInsight

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

Should DBAs learn Linux?

by Additional Articles

Brent Ozar Blog

SQL Server on Linux

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

SQL Prompt Tip: how to control when the suggestion box pops up

by Additional Articles

Redgate

RedGate

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

Implementing SQL Server Failover Clustering in Azure

by Additional Articles

SQLServerCentral

failover

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2017-09-29

3,141 reads

Representing a simple hierarchical list in SQL Server with JSON, YAML, XML and HTML

by Additional Articles

SimpleTalk

JSON

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

How to use a Project in SQL Server Management Studio

by Additional Articles

MSSQLTips.com

SQL Server Management Studio

Matteo Lorini shows how to setup a project in SSMS to organize files.

2017-09-27

4,539 reads

What If Week: What Would You Fix Or Change?

by Additional Articles

Brent Ozar Blog

SQL Server

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

SQLCLR in Practice: Creating a Better Way of Sending Email from SQL Server

by Additional Articles

SimpleTalk

SQLCLR

SQLCLR is now considered a robust solution to the few niche requirements that can't be met by the built-in features of SQL Server. Amongst the legitimate reasons for avoiding SQLCLR, there is the fear of getting bogged down in code with special requirements that is difficult to debug. Darko takes a real example, extending the features of sp_send_dbmail, to demonstrate that there need be few terrors in SQLCLR.

2017-09-25

7,840 reads

All authors

Additional Articles

The Basics of Good T-SQL Coding Style – Part 4: Performance

Understanding Azure Data Factory – A Cloud Based Integration Service

Data in Motion and Data at Rest

Should DBAs learn Linux?

SQL Prompt Tip: how to control when the suggestion box pops up

Implementing SQL Server Failover Clustering in Azure

Representing a simple hierarchical list in SQL Server with JSON, YAML, XML and HTML

How to use a Project in SQL Server Management Studio

What If Week: What Would You Fix Or Change?

SQLCLR in Practice: Creating a Better Way of Sending Email from SQL Server

Blogs

A New Word: Gnossienne

Exploring DiskANN: Part I: Understanding the Algorithm before the disk

Learning Tool – Deepstash

Forums

Alamat BCA KCP Pondok Bambu Tlp:0821-8200-233

Alamat BCA KCP Klender Telp:0821-8200-203

Alamat BCA KCP Pulogadung Trade Centre Tlp:08218200174

Question of the Day

The Data API Builder MCP Server Tools