SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2014/05/27 to 2014/06/03

Semi-blocking Transformations in SQL Server Integration Services SSIS

In a SSIS data flow, there are multiple types of transformations. On one hand you have synchronous and asynchronous transformations, but on the other hand you have non-blocking, semi-blocking and fully-blocking components. In this tip, Koen Verbeeck takes a closer look on the performance impact of semi-blocking transformations in SSIS.  Read more...
Rating:  Rate this |   Briefcase | 2,623 reads

Extracting data with headers using PowerShell

This article provides a short PowerShell script to extrace data from a database using PowerShell.  Read more...
By Louis Li 2014/06/03 | Source: SQLServerCentral.com | Category: extracting data
Rating: |  Discuss |   Briefcase | 4,161 reads

PowerShell One-Liners: Collections, Hashtables, Arrays and Strings

The way to learn PowerShell is to browse and nibble, rather than to sit down to a formal five-course meal. In his continuing series on PowerShell one-liners, Michael Sorens provides Fast Food for busy professionals who want results quickly and aren't too faddy. Part 3 has as its tasty confections - Collections, Hashtables, arrays and strings.  Read more...
By Additional Articles 2014/06/02 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 4,745 reads

Cursor-Killing: Retrieving Recently Modified Data

Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? In the next part of an ongoing series, we look at ways to efficiently retrieve recently modified data.  Read more...
By Edward Pollack 2014/06/02 | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 6,375 reads

Microsoft Azure Storage Queues Part 1: Getting Started

Microsoft Azure Queues are a ready-to-use service that loosely connects components or applications through the cloud. This article is the first part in a five-part series about Microsoft Azure Cloud Services by Roman Schacherl.  Read more...
By Additional Articles 2014/05/30 | Source: Just Azure | Category: storage queues
Rating: (not yet rated)  Rate this |   Briefcase | 2,296 reads

Report Builder or Reporting Services?

Should you be using Report Builder 3.0 or SQL Server Reporting Services 2008 R2 to build reports? Here's the 411!  Read more...
By Andy Owl 2014/05/30 (first published: 2012/03/27) | Source: SQLServerCentral.com | Category: report builder
Rating: |  Discuss |   Briefcase | 24,026 reads

DAX Relationships

Learn how relationships work in Powerpivot workbooks and how you can build them using the DAX language.  Read more...
By Michael Carper 2014/05/29 | Source: SQLServerCentral.com | Category: dax
Rating: |  Discuss |   Briefcase | 2,578 reads

Survey: Which new database platforms are you adopting?

Database technologies are always improving, which database platforms will you be using tomorrow? Red Gate wants to stay ahead to make sure you have the tools you need to do awesome work. Help us by completing this short survey.  Read more...
By Press Release 2014/06/12 (first published: 2014/05/29) | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 5,390 reads

Branching and Merging: Ten Pretty-Good Practices

After experiencing 'merge misery' personally, Konrad Lukasik came up with 10 well-tested ways of making branches and merges a stress-free part of application development.  Read more...
By Additional Articles 2014/05/29 | Source: SimpleTalk | Category: source control
Rating:  Rate this |   Briefcase | 7,170 reads

Stairway to SQLCLR Level 3: Security (General and SAFE Assemblies)

In the third level of our Stairway to SQLCLR, we look at the various mechanisms in place to help us control Security. In this Level we will focus on SAFE mode and see how secure SQLCLR is by default.  Read more...
By Solomon Rutzky 2014/05/28 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,100 reads

Transparent Data Encryption (TDE) in SQL Server

There are several ways to implement encryption in SQL Server; Arshad Ali focuses on Transparent Data Encryption (TDE), which was introduced in SQL Server 2008 and is available in later releases.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,176 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/04/18 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 103,890 reads

Moving to New Hardware

We are getting a front end upgrade for SQLServerCentral.  Read more...
By Site Owners 2014/05/27 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 1,108 reads

Optimizing Transaction Log Throughput

As a DBA, it is vital to manage transaction log growth explicitly, rather than let SQL Server auto-growth events "manage" it for you. If you undersize the log, and then let SQL Server auto-grow it in small increments, you'll end up with a very fragmented log. This article demonstrates how this can have a significant impact on the performance of any SQL Server operations that need to read the log.  Read more...
By Additional Articles 2014/05/27 | Source: SimpleTalk | Category: transaction log
Rating:  Rate this |   Briefcase | 3,842 reads

Cursor-Killing: Accessing Data in the Next Row

Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? This first part in an ongoing series of cursor-killing handles inter-row analysis.  Read more...
By Edward Pollack 2015/12/18 (first published: 2014/05/27) | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 22,033 reads