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

Stairway to Advanced T-SQL Level 6: Creating Rows Of Data Using The UNPIVOT Operator

The UNPIVOT operator does just the opposite of the PIVOT operator, which we looked at in the previous level. By using the PIVOT operator we can take multiple rows of data and create as single row as output. The UNPIVOT operator will take values from a single row and will create multiple rows. Microsoft introduced the UNPIVOT operator when they rolled out SQL Server 2005. In this level I will be showing you different examples of how to use the UNPIVOT operator.  Read more...
By Gregory Larsen 2018/02/07 (first published: 2015/06/24) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,005 reads

How to use the SQL Prompt snippet placeholders for selecting and copying text

There are four SQL Prompt snippet placeholders that are all about selection and copying of text. These placeholders are very handy if, for example, you have two blocks of code that need to be part of a snippet. One part you hold on the clipboard, and the other part is a block of snippet text, selected using the $SELECTEDTEXT$ placeholder.  Read more...
By 2018/02/07 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,964 reads

Heaps, Deletes, and Optimistic Isolation Levels

Erik shows that heaps have even more drawbacks under optimistic concurrency.  Read more...
By Additional Articles 2018/02/07 | Source: Brent Ozar Unlimited Blog | Category: heaps
Rating: (not yet rated)  Rate this |   Briefcase | 2,483 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 2018/02/07 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 101,217 reads

SSIS Package with a Derived Column

I created this article to demonstrate the use of derived columns inside a ForEachLoop Container for a client requirement for some auxiliary marketing reports. I found the Data Conversion tool useful to escape the problem of mismatched data types, which is an issue with versions of Microsoft SSIS.  Read more...
By Thomas Stricker 2018/02/06 | Source: SQLServerCentral.com | Category: derived columns
Rating: |  Discuss |   Briefcase | 670 reads

Realistic, simulated data for testing, development and prototypes

This article proposes a scheme for using Redgate SQL Data Generator (SDG) as a ‘data generation and translation’ tool. We generate the data using a free copy of SQL Server Express, and then use standard bulk copy mechanisms to translate it to various formats, then distribute it out to the different data technologies and platforms that require a copy of the data. The tool becomes a mechanism to support ‘polyglot persistence’.  Read more...
By 2018/02/06 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,373 reads

SQL Server Replication for Temporal Tables

In this tip, Ameena Lalani looks at how you can setup replication to include temporal history data.  Read more...
By 2018/02/06 | Source: MSSQLTips.com | Category: replication
Rating: (not yet rated)  Rate this |   Briefcase | 2,119 reads

Building a Custom Blocked Process Report

Blocking in SQL Server is normal behavior, but excessive blocking can lead to many complaints and is a symptom of poor performance. SQL Server contains a vast amount of information that can help when troubleshooting performance issues like blocking, but understanding and gathering that information when you need it is a lot of work. Darko Martinovic explains his solution for a custom blocking report.  Read more...
By Additional Articles 2018/02/06 | Source: SimpleTalk | Category: monitoring
Rating:  Rate this |   Briefcase | 2,783 reads

Configure Read Only Routing

The advantage of Setting the readable secondary as Read-Intent Only will allow the secondary server to serve the read-only workload only if the connection string of the application contains Application Intent=Readonly parameter.   Read more...
By Ganapathi varma Chekuri 2018/02/05 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 565 reads

Add a SQL Server Database to an Existing Always On Availability Group

In this tip, Manvendra Singh will cover how to add another database to an existing Always On Availability Group.  Read more...
By Additional Articles 2018/02/05 | Source: MSSQLTips.com | Category: availability group (ag)
Rating: (not yet rated)  Rate this |   Briefcase | 2,009 reads

Bringing DevOps to the database. Part 1: Version control

Continuous delivery, continuous integration, automated release management – the phrases alone are enough to make the talk about DevOps for the database sound more complicated than it actually is - this post explains that the key is to start small.  Read more...
By 2018/02/05 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,019 reads

Install and Configure SQL Server 2017 Availability Groups on Linux - Part 3

In this tip, Edwin Sarmiento looks at how to create the Always On Availability Group with a listener name when using SQL Server on Linux.  Read more...
By Additional Articles 2018/02/02 | Source: MSSQLTips.com | Category: sql server 2017
Rating: (not yet rated)  Rate this |   Briefcase | 2,544 reads

Liberating the DBA from SQL Authentication with AD Groups

It's 15 years after the beginning of the century. Time to eliminate the security exposure of SQL logins, and implement integrated security. Active Directory Groups make this easy for the DBA.  Read more...
By John F. Tamburo 2018/02/02 (first published: 2015/12/21) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 6,188 reads

Free webinar: Change your SQL Server troubleshooting from reactive to proactive with a monitoring tool

Redgate’s James King and Ben Emmett will demonstrate how to troubleshoot your SQL Server estate, and discuss how it shouldn’t be about reacting to problems when they occur, but rather having the tools to make proactive decisions to plan ahead, identify potential disruptions, fix common problems and make improvements.   Read more...
By 2018/02/01 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 4,870 reads

Adaptive Query Processing – Batch Mode Memory Grant Feedback

Explore Batch Mode Memory Grant Feedback that was introduced in SQL Server 2017  Read more...
Rating: |  Discuss |   Briefcase | 511 reads

Has Your Database Been Backed up in the Last 24 Hours?

As a DBA your #1 responsibility is to make sure that each of your SQL Server databases are backed up. This tip provides a couple of TSQL scripts that will identify the last backup of each database.  Read more...
By 2018/02/01 | Source: Database Journal | Category: backup
Rating: (not yet rated)  Rate this |   Briefcase | 3,009 reads

Stairway to DAX and Power BI - Level 13: Simple Context Manipulation: Introducing the DAX All() Function

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX All() function, discussing its syntax, basic uses and operation. He then provides hands-on exposure to All(), focusing largely upon its most basic uses in manipulating filter context.  Read more...
By Bill Pearson 2018/01/31 | Source: SQLServerCentral.com | Category: stairway series
Rating: (not yet rated) |  Discuss |   Briefcase | 354 reads

Historical Stock Prices and Volumes from Python to a CSV File

Python is a versatile language that is gaining more popularity as it is used for data analysis and data science. In this article, Rick Dobson demonstrates how to download stock market data and store it into CSV files for later import into a database system.  Read more...
By Additional Articles 2018/01/31 | Source: SimpleTalk | Category: python
Rating: (not yet rated)  Rate this |   Briefcase | 2,548 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2018/01/31 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 72,404 reads