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

Quality-Driven Software Development

While software is among the most widely used products in human history, it also has one of the highest failure rates due to poor quality. In this article, Cynthia Dzikiti explains how quality should be part of all aspects of the software lifecycle.  Read more...
By Additional Articles 2018/03/05 | Source: Redgate | Category: software development
Rating: (not yet rated)  Rate this |   Briefcase | 2,459 reads

Misuse of the scalar user-defined function as a constant

If you use an unverified scalar function, then the query will be grindingly slow because you will be executing it on every row whether it has a parameter or not. This post explains the issue in more depth, and shows how SQL Prompt code analysis rules can help you avoid it altogether.   Read more...
By 2018/03/05 | Source: Redgate | Category: redgate
Rating:  Rate this |   Briefcase | 4,602 reads

Query to Excel Stored Procedure

Transform your query result into an Excel file using this technique.  Read more...
By Darko Martinovic 2018/03/05 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 2,262 reads

SQL Server Machine Learning Services – Part 5: Generating multiple plots in Python

Visualization is often the first step in analyzing data. Python makes visualization easy. In this article, Robert Sheldon demonstrates how to generate multiple charts from one dataset using Python with SQL Server Machine Learning Services.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,506 reads

The top 7 benefits of DevOps for CEOs

If you were asked what the benefits of DevOps are, you could probably name two or three straight away. Maybe four or five. But – and here’s the thing – what if the person down the corridor was asked the same question? Someone who works in the same place, but does a different job.  Read more...
By 2018/03/02 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,699 reads

Scripting Environments in SSIS

Demo and script on how to script out SSIS Environments and their associated variables  Read more...
By Jeff Jordan 2018/03/02 (first published: 2016/01/21) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 6,647 reads

PASS Marathon GDPR in partnership with Redgate

This special edition of the PASS Marathon series will focus on the General Data Protection Regulation (GDPR). You’ll learn how the legislation impacts SQL Server data professionals around the globe and practical steps you can take to help ensure you’re ready for when GDPR enforcement takes effect on May 25th.  Read more...
By 2018/03/01 | Source: PASS | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 2,459 reads

Staying Current on Power BI Dashboards

Power BI Dashboards can be kept current using simple DAX formulas in your data models. Save yourself time and energy by understanding how dashboard tiles work on PowerBI.com and what can be done to set your dashboards to a current period.  Read more...
By Angel Abundez 2018/03/01 | Source: SQLServerCentral.com | Category: powerbi
Rating: |  Discuss |   Briefcase | 1,092 reads

Object Security in Analysis Services Tabular 2017

Koen Verbeeck looks at how to hide tables or columns in Analysis Services Tabular 2017 for certain users so they are not able to use them in reports or query them.  Read more...
By Additional Articles 2018/03/01 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 2,527 reads

How to build a DevOps roadmap to kickstart your digital transformation journey

By harnessing the concept of agility to a methodology that enables constant software innovation, DevOps allows organizations to respond dynamically to changing market conditions and rising customer expectations.  Read more...
By 2018/02/28 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,572 reads

Stairway to Columnstore Indexes Level 3: Building The Columnstore

The performance increase columnstore indexes grant when reading data from the index is offset by the expensive process required to build the index. In this Stairway level, Hugo Kornelis walks you through the steps SQL Server takes when building (or rebuilding) a columnstore index.  Read more...
By Hugo Kornelis 2018/02/28 (first published: 2015/06/10) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,502 reads

How to Enable Transparent Data Encryption

By default, SQL Server does not encrypt data in a SQL Server database in an encrypted format. When SQL Server 2008 was introduced, Microsoft implemented Transparent Data Encryption (TDE). When TDE is enabled on a database SQL Server will encrypt the database as data is written to the disk.  Read more...
Rating:  Rate this |   Briefcase | 2,504 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2018/12/05 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 101,596 reads

How to Survive as a Lone DBA

Database administrators have enormous responsibility whether they manage one or hundreds of servers. Monica Rathbun tells us how she survived as the Lone DBA for 56 database servers for over a decade. While many DBAs work on teams instead of alone, she has great advice for all.  Read more...
By Additional Articles 2018/02/27 | Source: SimpleTalk | Category: dba
Rating: (not yet rated)  Rate this |   Briefcase | 4,492 reads

Azure DWH part 27: Creating your ASDW in Cloud Shell using Bash

In this article, we will show how to create an ASDW in Bash using the Cloud Shell.  Read more...
By Daniel Calbimonte 2018/02/27 | Source: SQLServerCentral.com | Category: bash
Rating: |  Discuss |   Briefcase | 210 reads

Customizing the SQL Prompt built-in snippets: a better ‘ata’ snippet

Snippets are a great feature of SQL Prompt - they save coding time, and introduce standards and consistency to the way you build code modules. But did you know you can customize them? Phil Factor shows how by using ALTER TABLE ADD as an example.  Read more...
By 2018/02/27 | Source: Redgate | Category: redgate
Rating:  Rate this |   Briefcase | 2,812 reads

How to Suck at Database Administration

Tara Kizer outlines 15 telltale signs that you aren't a very good senior DBA.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 5,660 reads

So what is a Data Privacy Impact Assessment and why should organizations care?

If you’ve read anything about the upcoming General Data Protection Regulation (GDPR), you’ll probably have seen the phrase Data Privacy Impact Assessment (DPIA) used. This article explains exactly what it is, and outlines the four areas its expected to address.  Read more...
By 2018/02/26 | Source: Redgate | Category: data privacy
Rating: (not yet rated)  Rate this |   Briefcase | 2,907 reads

Transaction Replication: Multiple Publishers, Single Subscriber

How to configure multiple publishers and single subscriber replication?  Read more...
By Suresh Kumar 2018/02/26 | Source: SQLServerCentral.com | Category: transactional replication
Rating: |  Discuss |   Briefcase | 496 reads