SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2017/09/18 to 2017/09/25

When sp_HelpText is not so helpful!

A note of caution on the use of sp_helptext to script out objects.  Read more...
By Andy Robertson 2017/09/25 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,132 reads

Extending DevOps practices to SQL Server databases with ReadyRoll from Redgate

In this webinar, Microsoft MVP Steve Jones and Redgate’s Arneh Eskandari will show you how Redgate’s Database DevOps solution can work to improve your database development and deployment processes. You'll see a demo of the following Redgate tools - ReadyRoll, DLM Automation and DLM Dashboard - and see how they plug into GIT. There will also be plenty of time to ask Steve and Arneh questions.   Read more...
By 2017/09/25 (first published: 2017/09/14) | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 8,247 reads

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.  Read more...
By Additional Articles 2017/09/25 | Source: SimpleTalk | Category: sqlclr
Rating:  Rate this |   Briefcase | 5,244 reads

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

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.  Read more...
By Additional Articles 2017/09/22 | Source: SimpleTalk | Category: excel
Rating:  Rate this |   Briefcase | 4,366 reads

Insert Stored Procedure Results Into New Table Without Using OPENQUERY

OPENQUERY arrives with a lot of baggage. Try this alternative technique to inserting stored procedure results into a new table.  Read more...
By Orlando Colamatteo 2017/09/22 (first published: 2016/03/22) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,832 reads

Use SQL Server? Redgate would like to hear from you

Redgate are running a survey to better understand trends in adoption of different technologies and platforms. Completing this survey will take just a few minutes, and as a thank you for your time, they will be giving away a $100 Amazon gift card to one randomly selected participant who completes the survey by October 10.  Read more...
By 2017/09/21 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 2,470 reads

SQL Server 2016 SSIS Basics - Install SQL Server Data Tools

Step-by-step instructions for downloading and installing SQL Server Data Tools (SSDT) for SQL Server 2016.  Read more...
Rating: |  Discuss |   Briefcase | 1,056 reads

Purging Old Database Mail Items

Are you purging the old database mail items stored in msdb? In this tip, Greg Larsen shows you how to purge database mail.  Read more...
By Additional Articles 2017/09/21 | Source: Database Journal | Category: database mail
Rating: (not yet rated)  Rate this |   Briefcase | 2,762 reads

Stairway to U-SQL Level 17: Executing U-SQL Jobs with PowerShell

Automate your Data Lake with PowerShell! Learn how PowerShell can be used to execute U-SQL scripts, as well as a few other little tricks.  Read more...
By Mike McQuillan 2017/09/20 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 446 reads

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

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.  Read more...
By Additional Articles 2017/09/20 | Source: SimpleTalk | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 3,663 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2017/09/20 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 96,418 reads

Benchmark your Database DevOps maturity level

Whether you’re only just starting to explore the advantages of DevOps or you’re already fully immersed in the journey, including the database brings additional advantages. Take a few minutes to complete our Database DevOps Maturity Assessment and you’ll better understand how advanced your current processes are, receive recommendations for improvements, and see how your maturity level compares with that of your peers.  Read more...
By 2017/09/28 (first published: 2017/09/19) | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 3,369 reads

Moving beyond principal components analysis

Principal components analysis is a standard, but usually terrible, technique for visualising complex data. We're using network diagrams to solve this problem.  Read more...
By Nick Burns 2017/09/19 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 456 reads

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

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".  Read more...
By Additional Articles 2017/09/19 | Source: MSSQLTips.com | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 4,479 reads

Redgate wants your opinion

Have you tried or used SQL Prompt? Redgate is running some research on SQL Prompt pricing. Please help by filling in their short survey for the chance to win one of three licenses of SQL Prompt or a Redgate point-tool if your choice.  Read more...
By 2017/09/18 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,152 reads

The Instance ID MSSQLSERVER Is Already In Use

This article will explain how to fix "The Instance ID 'MSSQLSERVER' Is Already In Use By SQL Server Instance 'MSSQLSERVER.INACTIVE' Error.   Read more...
By Nisarg Upadhyay 2017/09/18 | Source: SQLServerCentral.com | Category: mssqlserver
Rating: |  Discuss |   Briefcase | 720 reads

How to Drop All Your Indexes – Fast

You probably shouldn't be doing this, but if you need to, Brent Ozar has a script for that.  Read more...
By Additional Articles 2017/09/18 | Source: Brent Ozar Unlimited Blog | Category: drop indexes
Rating: (not yet rated)  Rate this |   Briefcase | 4,342 reads