Have you ever surfed the internet and felt overwhelmed by personalized advertisements that appear to know your every desire? Have you ever been amazed at how accurate some weather forecasts can be? These actions are based on data processing. EsProc SPL and SQL (note, SPL stands for Structured Processing Language and SQL stands for Structured Query Language). SQL is a major language widely encountered and used for data manipulation within relational databases. While EsProc SPL is another effective tool for data processing, especially suited for complex computations and in-memory operations, it is less commonly encountered.

etaoin shrdlu

by Grant Fritchey

SQLServerCentral

Technology

Grant looks back at etaoin shrdlu. Read more to find out what that means.

Bad Stored Procedures

by Steve Jones

SQLServerCentral

Stored procedures can be poorly written, but Steve prefers them over embedded code.

Calculating Elapsed Times (SQL Spackle)

by Dwain Camps

SQLServerCentral.com

SQL elapsed times

Calculating elapsed time between time values can be an interesting problem that is easily solved even when data anomalies are present.

Setup Excel as Front End Application for SQL Server

by Additional Articles

MSSQLTips.com

Uncategorized

In this article, we walk through how to set up a simple Excel interface to work with SQL Server data to insert, update, delete, and select data.

When Do We Worry About Scalability?

by Steve Jones

SQLServerCentral

Steve has a few thoughts on the tradeoff between getting work done quickly and producing well performing code.

Auditing SQL Server – Part 4 – Database Configuration Audit

by Additional Articles

SimpleTalk

This continues my series on auditing SQL Server. The fist parts covered discovery and documentation, server level hardware audits and SQL Server engine level audits. This section examines database configuration audits.

Microsoft return to PASS Summit 2024 as Sapphire sponsor

by Additional Articles

SQLServerCentral

Get ready to meet Microsoft's experts on-site in the exhibit hall and in multiple educational sessions (including a pre-con, keynote and learning pathway). Watch a sneak peek of Microsoft's learning pathway 'Becoming an Azure SQL DBA – Advancing the Role of the On-Premises SQL Server DBA'

How to Add a New Shared Disk to a WSFC as a SQL Resource

by muhkam

SQLServerCentral

Adding a new shared disk to Windows Server failover Cluster is not a complex process but special care must be taken when you want to use the new disk for any existing SQL Instance. In this article, we will show you all the required steps to add the disk to WSFC and then to properly assign it to an existing SQL role in the WSFC.

Technology and Privacy

by Steve Jones

SQLServerCentral

Data Privacy and Protection

Is data privacy becoming less or more of a problem?

EsProc SPL and SQL, Complimentary , But Different Technologies

etaoin shrdlu

Bad Stored Procedures

Calculating Elapsed Times (SQL Spackle)

Setup Excel as Front End Application for SQL Server

When Do We Worry About Scalability?

Auditing SQL Server – Part 4 – Database Configuration Audit

Microsoft return to PASS Summit 2024 as Sapphire sponsor

How to Add a New Shared Disk to a WSFC as a SQL Resource

Technology and Privacy

Blogs

FIRST_VALUE vs. Min: #SQLNewBlogger

Explicitly Defining Values in an IN Clause VS Putting Them into a Temp Table and Use a Semi-Join

AI Step 1

Forums

funny character shows in one hdg name in ssis flat file connector

Automating DAX Studio...

Cannot install development version.

Question of the Day

More Funny SELECTs