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

Network Issue or THREADPOOL waits?

Tara Kizer talks identifying THREADPOOL waits and what you can do about them.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,026 reads

Azure DWH part 25: Auditing and threat detection

In this new article, we will show how to audit the Data Warehouse Activities.  Read more...
By Daniel Calbimonte 2018/01/30 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 234 reads

The 2018 State of Database DevOps report

In this year's survey, over 700 IT professionals across a range of sectors, in organizations of every size around the globe were asked about their plans to adopt DevOps, how they thought the database fitted into the picture, and what they thought the biggest challenges were.  Read more...
By 2018/01/30 | Source: Redgate | Category: devops
Rating:  Rate this |   Briefcase | 2,641 reads

SQL Server Machine Learning Services – Part 3: Plotting Data with Python

One of the advantages of running Python from SQL Server is the ability to create graphics to assist in analysis of data. Robert Sheldon demonstrates matplotlib, a 2D plotting library, widely used with Python to create quality charts.  Read more...
By Additional Articles 2018/01/29 | Source: SimpleTalk | Category: python
Rating: (not yet rated)  Rate this |   Briefcase | 3,448 reads

Sending table form HTML emails from a SQL Server database engine

The solution which helps to smiplify delivery of a table content in the HTML form using Database mail  Read more...
By Evgeny Garaev 2018/01/29 | Source: SQLServerCentral.com | Category: database mail
Rating: |  Discuss |   Briefcase | 1,622 reads

The top 7 business benefits of establishing DevOps in your organization

Any change within an organization requires an investment of time, expertise and money. Therefore, it is natural that leaders should assess the potential of DevOps in terms of what it will deliver: Managers should ask the question: What is to be gained by changing our current way of doing things?  Read more...
By 2018/01/29 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,584 reads

How to Upgrade SQL Server

What steps should you take in upgrading SQL Server to SQL 2014  Read more...
By Rudy Panigas 2018/01/26 (first published: 2015/10/15) | Source: SQLServerCentral.com | Category: sql server upgrade
Rating: |  Discuss |   Briefcase | 6,581 reads

The Database DevOps Challenges SQL Clone Solves

With its PowerShell integration, SQL Clone becomes an important component in a broader database DevOps toolchain - Tony Davis explains in detail.  Read more...
By 2018/01/26 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,563 reads

How Can DevOps Concepts Provide Value in Digital Transformation Projects?

For some of us, DevOps means startups, cloud, fast-moving social media applications and Extreme Programming (XP). What about large corporate IT initiatives, Digital Transformation projects, and business process re-engineering? Can DevOps be relevant and appropriate? Mohammad Rizvi argues from experience that it most certainly can be.  Read more...
By 2018/01/26 | Source: SimpleTalk | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,730 reads

Adaptive Query Processing – Batch Mode Adaptive Join

Let's explore how SQL Server 2017 automatically adapts between nested loop and hash join operators  Read more...
Rating: |  Discuss |   Briefcase | 802 reads

Finding code smells using SQL Prompt: the SET NOCOUNT problem

SQL Prompt implements two static code analysis rules to check code for potential misuse of the SET NOCOUNT command. In this post, Phil Factor explains the issue.  Read more...
By 2018/01/25 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,905 reads

Create Size Based Backups for SQL Server 2017

Microsoft has never documented how the database log works, such as its format, its logging mechanism/algorithm, etc. But SQL Server 2017 has introduced a few improvements in some DMVs that expose more details about the status of data and log changes, and we can use the new information to design a better backup strategy.  Read more...
By 2018/01/25 | Source: MSSQLTips.com | Category: backup
Rating: (not yet rated)  Rate this |   Briefcase | 3,302 reads

Stairway to Database Design Level 7: Triggers

In levels one to four, we built the tables, base and virtual, of a schema. Levels five and six dealt with stored procedures. This level deals with a feature you need to avoid as much as possible; this is article is on Triggers.  Read more...
By Joe Celko 2018/01/24 (first published: 2011/09/30) | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,762 reads

How to Change the Default Backup Directory

When you install a SQL Server instance you have the opportunity to identify the default location for your instance database backups. Overtime you might decide you want to change the default location for database backups. This tip shows you two different ways to change the default location for your database backups.  Read more...
By 2018/01/24 | Source: Database Journal | Category: backup
Rating: (not yet rated)  Rate this |   Briefcase | 2,830 reads

Free eBook: Inside the SQL Server Query Optimizer

This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.  Read more...
By Press Release 2019/01/09 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 52,704 reads

Azure DWH part 24: Elastic queries

This article will explain what is an elastic query and show an example.  Read more...
By Daniel Calbimonte 2018/01/23 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 477 reads

Validation, Verification, and Modification

A proper database design is very important, and changes to fix problems after the fact are expensive. In this article, Joe Celko discusses three aspects of database design that are often overlooked: validation, verification, and modification.  Read more...
By 2018/01/23 | Source: SimpleTalk | Category: database design
Rating: (not yet rated)  Rate this |   Briefcase | 3,416 reads