SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

<< Newer    Items 61 to 80 of 16539    Older >>
 

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,338 reads

IoT Increases Efficiency

IoT can help us better manage our world.  Read more...
By Steve Jones 2018/01/29 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 52 reads

How do the Experts Become Experts?

How does one become better at some endeavor?  Read more...
By Kathi Kellenberger 2018/01/29 | Source: SQLServerCentral.com | Category: editorials
Rating: (not yet rated) |  Discuss |   Briefcase | 42 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,180 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,353 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,469 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,530 reads

Are You Always Up?

This week Steve discusses uptime, RPO and RTO.  Read more...
By Steve Jones 2018/01/26 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 39 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,236 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 | 724 reads

Are You Patched?

With bugs in modern CPUs, are you patching your systems?  Read more...
By Steve Jones 2018/01/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 47 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 | 2,969 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,547 reads

Effectiveness

Today Steve Jones notes that your software should handle the load and work, but it needs to get done as well.  Read more...
By Steve Jones 2018/01/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 188 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,606 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 2018/01/24 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 35,182 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,548 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 | 435 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,074 reads

Allowing Failure

Sometimes it is better to allow things to fail.  Read more...
By Ben Kubicek 2018/01/23 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 69 reads
<< Newer    Items 61 to 80 of 16539    Older >>