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

<< Newer    Items 41 to 60 of 16641    Older >>

The DBA's Essential Index Monitoring and Maintenance Tasks

Indexes can be the most critical part of any database. they can drastically improve performance or they can ruin it. Wise management is the key to success.  Read more...
By John F. Tamburo 2018/03/09 (first published: 2016/02/15) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,372 reads

Introduction to the Biml Language

Biml or Business Intelligence Markup Language is an open-source XML dialect to generate Integration Services (SSIS) packages. Take a look at this Biml tutorial to learn how you can use Biml to generate SSIS packages.  Read more...
By Additional Articles 2018/03/09 | Source: MSSQLTips.com | Category: biml
Rating: (not yet rated)  Rate this |   Briefcase | 3,103 reads

The top 7 benefits of DevOps for CIOs

When CEOs consider the benefits of DevOps and whether or not they should introduce it, their viewpoint will be influenced by their ongoing concerns with lowering costs and increasing revenues. As a result, factors like gaining a faster time to market and creating higher quality products will be top of the agenda. It’s a different story for CIOs because their focus is more on processes that can increase the throughput of the IT department, or how skilled IT staff can be recruited and retained.  Read more...
By 2018/03/09 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,564 reads

TDE with Automatic Database Seeding

Transparent Data Encryption on an Availability Group and Automatic Database Seeding  Read more...
By Evgeny Garaev 2018/03/08 | Source: SQLServerCentral.com | Category: availability group (ag)
Rating: |  Discuss |   Briefcase | 535 reads

Azure Cosmos DB Partitioning

One of the most important design decisions that must be made when planning deployment of Azure Cosmos DB involves logical partitioning of data that will populate target collections, graphs, or tables. Selecting the optimal partitioning model has both performance and pricing implications. In this article, we will explore the rationale behind these implications and review the partitioning options.  Read more...
By Additional Articles 2018/03/08 | Source: Database Journal | Category: azure cosmos db
Rating: (not yet rated)  Rate this |   Briefcase | 2,177 reads

Abolish Disjointed Time

The European Parliment is considering getting rid of daylight savings time.  Read more...
By Steve Jones 2018/03/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 58 reads

A General SQL Server Crossword

Crossword puzzle based on terms from SQL Server. 
By Kenneth Fisher 2018/03/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 77 reads

Stairway to U-SQL Level 19: Azure Data Lake Metadata with PowerShell

Need to inspect your Data Lake objects and files? Want to automate the process? Find out how with PowerShell.  Read more...
By Mike McQuillan 2018/03/07 | Source: SQLServerCentral.com | Category: azure
Rating: (not yet rated) |  Discuss |   Briefcase | 220 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2018/03/07 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 93,831 reads

Questions About Data Breaches that You Were Too Shy to Ask

News reports about data breaches are common occurrences. Even the companies that exist to keep our data safe are not immune. William Brewer answers the question about data breaches that you may be too shy to ask.  Read more...
By Additional Articles 2018/03/07 | Source: SimpleTalk | Category: security
Rating:  Rate this |   Briefcase | 2,504 reads

SQL Provision adds fully integrated data masking

SQL Provision launched in January, offering users blazingly fast database copying, with a light storage footprint, centralized management, and the ability to mask any sensitive data, prior to distribution. This new release takes compliant provisioning one step further, by integrating data masking directly into SQL Clone’s image creation process, rather than running it as a separate step prior to the image creation.  Read more...
By 2018/03/07 | Source: Redgate | Category: provisioning
Rating: (not yet rated)  Rate this |   Briefcase | 2,366 reads

Understanding Machine Learning

This article describes about the understanding Machine Learning and bits of Artificial Intelligence as it’s a superset of Machine Learning.  Read more...
By Narendra Bhogavalli 2018/03/06 | Source: SQLServerCentral.com | Category: machine learning
Rating: |  Discuss |   Briefcase | 1,376 reads

Predictions for the Future

Steve Jones looks forward with a few predictions for how the world might change for SQL Server professionals.  Read more...
By Steve Jones 2018/03/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 60 reads

The Many Levels Of Concurrency

When designing for high concurrency, most people look to the hardware for answers. And while it’s true that it plays an important role, there’s a heck of a lot more to it.  Read more...
By Additional Articles 2018/03/06 | Source: Brent Ozar Unlimited Blog | Category: concurrency
Rating: (not yet rated)  Rate this |   Briefcase | 3,051 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,052 reads

Decouple the Tools

The decoupling of some tools from SQL Server seems to be working. Perhaps Microsoft should decouple them all.  Read more...
By Steve Jones 2018/03/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 56 reads

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

Opportunity or Restriction?

There is opportunity in complying with the new GDPR regulations.  Read more...
By Steve Jones 2018/03/05 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 24 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 | 3,154 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,254 reads
<< Newer    Items 41 to 60 of 16641    Older >>