Additional Articles

All authors

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

The Best of Both Worlds: Using Excel and Power BI Together

by Additional Articles

SimpleTalk

Excel

Excel and Power BI work well together. This allows you to use the two tools together to provide for many types of business workflow and BI practices. You can publish an Excel file to Power BI to share with others, analyse a Power BI dataset in Excel or import either an Excel workbook or Excel data to Power BI. You can gain the workgroup power and business-orientation of Power BI without losing the ease and versatility of Excel. Saurabh shows how.

2017-09-22

6,233 reads

Purging Old Database Mail Items

by Additional Articles

Database Journal

Database Mail

Are you purging the old database mail items stored in msdb? In this tip, Greg Larsen shows you how to purge database mail.

2017-09-21

3,011 reads

Investigating the Cause of SQL Server High CPU Load Conditions When They Happen

by Additional Articles

SimpleTalk

Performance

Any DBA who is trying to find the cause of an intermittent problem with a server or database dreams of being able to use a query or procedure take a snap of the relevant variables at the point when the problem occurred. Laerte takes an example of a slow-running query hogging resources to show that you can run queries when a WMI alert is fired, and save the results for later inspection, whenever it happens.

2017-09-20

4,188 reads

Searching and finding a string value in all columns in a SQL Server table

by Additional Articles

MSSQLTips.com

SQL Server

Sometimes there is a need to find if a string value exists in any column in your table. Although there are system stored procedures that do a "for each database" or a "for each table", there is not a system stored procedure that does a "for each column".

2017-09-19

5,197 reads

How to Drop All Your Indexes – Fast

by Additional Articles

Brent Ozar Blog

drop indexes

You probably shouldn't be doing this, but if you need to, Brent Ozar has a script for that.

2017-09-18

4,758 reads

SQL Server R Services: Digging into the R Language

by Additional Articles

SimpleTalk

SQL Server R Services

It is not just the analytic power of R that you get from using SQL Server R Services, but also the great range of packages that can be run in R that provide a daunting range of graphing and plotting facilities. Robert Sheldon shows how you can take data held in SQL Server and, via SQL Server R Services, use an R package called ggPlot that offers a powerful graphics language for creating elegant and complex plots.

2017-09-15

6,981 reads