SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2019/01/01 to 2019/01/08

Azure Data Explorer

Read this white paper to get a better understanding of the architecture and technology powering Azure Data Explorer, a fast and highly scalable data exploration service.  Read more...
By Additional Articles 2019/01/08 | Source: Microsoft MSDN | Category: azure data explorer
Rating: (not yet rated)  Rate this |   Briefcase | 2,278 reads

Azure DWH part 29: MicroStrategy Desktop with Azure

In this article, we will show how to connect MicroStrategy Desktop with ASDW.   Read more...
By Daniel Calbimonte 2019/01/08 | Source: SQLServerCentral.com | Category: microstrategy
Rating: |  Discuss |   Briefcase | 255 reads

Factors Behind Successfully and Repeatedly Executing Digital Transformation Programs at a Lightning Pace

IT transformation projects often fail due to poor planning, poor communication and more. In this article, Mohammad Rizvi explains how to be successful and give your customer a great experience.  Read more...
By Additional Articles 2019/01/08 | Source: SimpleTalk | Category: .net
Rating: (not yet rated)  Rate this |   Briefcase | 2,602 reads

Bootstrap 4 and Self-validating Forms

Validating the user input of a web form is important for security and data quality. In this article, Dino Esposito explains how to validate a form and add undo capability with Bootstrap 4.  Read more...
By Additional Articles 2019/01/07 | Source: SimpleTalk | Category: .net
Rating: (not yet rated)  Rate this |   Briefcase | 2,392 reads

Keep Column Headers Visible in SSRS

Keep column headers visible while scrolling down the page of SSRS reports.   Read more...
Rating: |  Discuss |   Briefcase | 806 reads

"Surely this one will get a clustered index scan."

In which SQL Server stubbornly insists on doing key lookups way, way past the tipping point.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,906 reads

Understanding Peer-to-Peer Transactional Replication, Part 3

We've gone through the basics of Peer-to-Peer Transactional Replication (PPTR). Now, we will blow it up! We will then fix it and show you how you how to triage and repair PPTR. When you remain calm and take some easy steps, you can stabilize PPTR with ease.  Read more...
By John F. Tamburo 2019/01/04 (first published: 2016/01/07) | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 2,373 reads

SSRS Reporting Basics: When is SSRS the Right Tool?

SSRS has undergone a number of changes over the past few versions. It remains a very popular reporting tool in companies large and small. In this article, Eugene Meidinger recounts the history of SSRS and explains when it’s the best tool to use.   Read more...
By Additional Articles 2019/01/03 | Source: SimpleTalk | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 4,121 reads

Working with SQL Server Stored Procedures and .NET

Learn how to build a simple .NET application that uses SQL Server stored procedures to retrieve and update data from a database.  Read more...
By Additional Articles 2019/01/03 | Source: MSSQLTips.com | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,956 reads

Workplace Encounter: Effects of TLS 1.2

In this article we share a recent experience we had with implementing TLS 1.2 ONLY support on our databases and particularly with respect to its effect on Transaction Log Shipping sessions.  Read more...
By Kenneth Igiri 2019/01/03 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 779 reads

Review Minimum SQL Server Security Practices

In this tip we look at different things you should consider when developing your database systems to ensure you are also thinking about security best practices as well.  Read more...
By Additional Articles 2019/01/02 | Source: MSSQLTips.com | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 2,795 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.  Read more...
By Press Release 2019/03/13 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 80,534 reads

Replicate NetSuite Data to Azure SQL (SSIS in Azure Data Factory)

With Azure Data Factory V2 Integration Runtimes (ADFv2 IR), you can deploy enterprise replication tasks to the Azure cloud.  Read more...
Rating: |  Discuss |   Briefcase | 188 reads

Update an Azure SQL Data Mart with ADLS files

In this tip we learn how to update the Azure SQL Data Mart in an automated way.  Read more...
By Additional Articles 2019/01/01 | Source: MSSQLTips.com | Category: azure data lake
Rating: (not yet rated)  Rate this |   Briefcase | 1,758 reads

Real-time performance monitoring for Azure SQL Database Managed Instance

This article was co-authored by Dimitri Furman and Denzil Ribeiro Reviewed by: Danimir Ljepava, Borko Novakovic, Jovan Popovic, Rajesh Setlem, Mike Weiner Introduction In our ongoing engagements with the SQL DB Managed Instance preview customers a common requirement has been to monitor database workload performance in real time.  Read more...
By Additional Articles 2019/01/01 | Source: SQLCAT | Category: managed instances
Rating: (not yet rated)  Rate this |   Briefcase | 2,288 reads

Generate a SSIS-package that reads from Twitter using Biml

Learn how to use Biml to create a SSIS-package with a Script component that can read from Twitter.  Read more...
By Johan Åhlén 2019/01/01 (first published: 2016/04/28) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 2,878 reads