Additional Articles

All authors

External Article

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

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

External Article

Data in Motion and Data at Rest

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

External Article

Implementing SQL Server Failover Clustering in Azure

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

External Article

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

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

Blogs

Github Copilot in SSMS can include data in its memory, simple prompt injections ahead

By

SQL Server Management Studio (SSMS) has recently added support for Github Copilot. This is...

Advice I Like: Failure

By

If it fails where you thought it would fail that is not a failure....

Logged in as a member of an Azure AD Group Error while Deploying DACPAC

By

Quite a long title for a short blog post ??While deploying a DACPAC (from...

Read the latest Blogs

Forums

Don't Create Workslop

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Don't Create Workslop

What is the original database name?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What is the original database...

The DBScan algorithm tutorial

By Daniel Calbimonte

Comments posted to this topic are about the item The DBScan algorithm tutorial

Visit the forum

Question of the Day

What is the original database name?

What is returned when this code is run? 

SELECT ORIGINAL_DB_NAME()

See possible answers