Some of our SQL Servers contain tables with summarized data (summarized on a weekly / monthly / quarterly basis). Previously this data was emailed as a flat file attachment to the recipients. I was asked to convert this in such a way that the email itself contains the table data. This way the recipients would be able to look at the data in a tabular format, making it easier for readability. Hence we arrived at the question of how to send email from SQL Server with data in a tabular format.

An nHibernate Head Scratcher

by David Poole

SQLServerCentral.com

Performance Tuning

An interesting mystery on why some nHibernate performance issues might exist on your systems. Read this piece from SQL Server expert David Poole and look to see if this is a problem you can easily solve in your environment.

Smart Energy Doesn't Seem So Smart

by Steve Jones

SQLServerCentral.com

Editorial

Quite a few utility companies and energy producers have ha data breeches in the last year, yet most of them don't have good tools to detect the intrusions or the support of executive management. Steve Jones talks about this being a problem in many companies.

SQL Injection Everywhere

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones talks about the possibility of SQL Injection, or other security issues from malformed input, affecting our lives in new and annoying ways.

A SQL Server Hardware Nugget A Day – Day 7

by GlennBerry

SQLServerCentral.com

Blogs

For Day 7 of this series, I will talk about the incredibly useful CPU-Z utility, which is available for free...

Database Design Example: Curriculum Vitae

by Additional Articles

InformIT

Database Design

I’ve explained the database design process in a series of articles that you can find here. In this tutorial, I’ll put that information to good use and design a database from the start of the process to the finish. To keep this example to a single article, I’ll not repeat the information from those previous articles, so make sure you look those over before reading this one.

Methods For Converting a Stored Procedure

by Eli Leiba

SQLServerCentral.com

T-SQL

An interesting use of T-SQL to run a stored procedure as part of a SELECT statement to get a result set to be used and combined with other tables. From Eli Leiba, learn how you can build a stored procedure into your queries.

The Standard Edition Wish List

by Steve Jones

SQLServerCentral.com

Editorial

This Friday Steve Jones asks what you would like to see in Standard Edition. Is there one feature that would make a big difference to you?

Am I a sysadmin? (or other SQL Server role)

by Steve Jones

SQLServerCentral.com

Blogs

How do you check if you are a sysadmin? It’s fairly easy to do in Management Studio. You can go...

Continuous Integration for SQL Server Databases

by Additional Articles

SimpleTalk

software development

When it comes to the subject of putting databases into source control, Troy Hunt is no shrinking violet. “Database source control is no longer negotiable”. In this article, published originally in his Blog, Troy explains how to do Continuous Integration from a database that is in a Version Control System (VCS).

Send email in a tabular format using SQL Server database mail

An nHibernate Head Scratcher

Smart Energy Doesn't Seem So Smart

SQL Injection Everywhere

A SQL Server Hardware Nugget A Day – Day 7

Database Design Example: Curriculum Vitae

Methods For Converting a Stored Procedure

The Standard Edition Wish List

Am I a sysadmin? (or other SQL Server role)

Continuous Integration for SQL Server Databases

Blogs

Future-Proofing: How to Stay Ahead in FinOps

Introducing the SQL Server on Kubernetes Operator

Advice I Like: Rewards from Work

Forums

Removing TDE

Poor Names

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

Question of the Day

Removing TDE