SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,891,410 DBAs, developers and SQL Server users

Rss
Headlines today   September 26, 2017

Azure DWH part 16: BCP to import and export data

In Azure SQL Data Warehouse we can use BCP to export or import the data. In this article, we will show how to do it.  Read more...
By Daniel Calbimonte 2017/09/26 | Source: SQLServerCentral.com | Category: bcp
Rating: (not yet rated) |  Discuss |   Briefcase | 69 reads

What If Week: What Would You Fix Or Change?

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.  Read more...
By Additional Articles 2017/09/26 | Source: Brent Ozar Unlimited Blog | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 402 reads
Previous headlines

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 | 921 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: (not yet rated)  Rate this |   Briefcase | 2,542 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 | 5,844 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,486 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: (not yet rated)  Rate this |   Briefcase | 2,798 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 | 936 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 | 1,862 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 | 1,598 reads
 

From the SQLServerCentral Blogs

Power BI Custom Visuals Class (Module 69 – Heatmap)

In this module you will learn how to use the Heatmap Custom Visual.  The Heatmap is useful for show data...  Read more...
By Devin Knight 2017/09/26 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 507 reads

The Tabular Model Documenter is now a Power BI Template

A while back I created the Tabular Model Documenter Power BI model that can connect to your SSAS Tabular or...  Read more...
By meaganl 2017/09/26 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 472 reads
Question of the Day

Compressing Integers

By Steve Jones 2017/09/26 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 159 reads

I've got a table of integers only and I want to put one trillion rows in the table for some testing. However, I'm worried about space. Which table should I...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
58968 371253 SSC Guru  
2.
Jeff Moden
52465 340920 SSC Guru  
3.
Steve Jones - SSC Editor
33443 225228 SSC Guru  
4.
Lynn Pettis
22919 150874 SSC Guru  
5.
Ed Wagner
20543 95066 SSC Guru  
Latest forum posts