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

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

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,433 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,354 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,357 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 | 58 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,040 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,035 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 | 55 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,328 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 | 23 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,132 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,238 reads

Data Decisions or Instinct?

Should decisions be made on instinct or with data?  Read more...
By Steve Jones 2018/03/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 157 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,262 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,528 reads

Elevation of Privileges

The elevation of privileges is a large security problem and Steve Jones discusses his fears. Would you know if someone successfully attacked your instance?  Read more...
By Steve Jones 2018/03/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 150 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 | 928 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,236 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,224 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,083 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/02/28 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 91,898 reads
<< Newer    Items 41 to 60 of 16632    Older >>