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

<< Newer    Items 21 to 40 of 16548    Older >>
 

SQL Server Machine Learning Services – Part 4: Finding Data Anomalies with Python

Python is widely used to analyze data. One such use is to find anomalies or outliers. In this article, Robert Sheldon demonstrates how to create a support vector machine (SVM) to score test data so that outliers can be viewed on a scatter plot.  Read more...
By Additional Articles 2018/02/14 | Source: SimpleTalk | Category: python
Rating: (not yet rated)  Rate this |   Briefcase | 2,484 reads

Restore a Database with CDC Enabled

In this post, I’m going to talk about an issue that I found while restoring a backup of CDC enabled database to different SQL instance. You may receive below warning message that includes information about the cause of the warning, which can help you to resolve the issue.  Read more...
Rating: |  Discuss |   Briefcase | 552 reads

Cloud Safe

DR should always be on our mind, especially in the cloud.  Read more...
By Steve Jones 2018/02/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 40 reads

Updating an expired SQL Server TDE certificate

Simon Liew explains how to generate a new TDE certificate to replace the previous, and also looks at the steps needed if the database is in an Availability Group.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,140 reads

How to monitor the impact of patching on SQL Server performance

In this article, Redgate use the Spectre/Meltdown bugs as means to demonstrate how you can use a tool like SQL Monitor to assess the impact of patching on your SQL Server estate.  Read more...
By 2018/02/13 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,635 reads

A Simple Introduction to Dynamic SQL

Dynamic SQL is essentially normal SQL written in such a way that you end up with a “customised” SQL script at run-time.  Read more...
By Paulo de Jesus 2018/02/12 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 1,314 reads

Production Scripts

Many of us have scripts that we run in SQL Agent jobs, but Steve wonders if we really treat them like production code.  Read more...
By Steve Jones 2018/02/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 57 reads

How to Implement Dynamic Data Masking in Azure SQL Database and SQL Server

Anoop Kumar shows you the SQL Commands (T-SQL) to secure PII/PHI data using the SQL Server Dynamic Data Masking (DDM) feature and explores DDM's built in functions to mask all critical data elements. DDM restricts unauthorized users from accessing critical data with no changes in the application.  Read more...
By Additional Articles 2018/02/12 | Source: Database Journal | Category: dynamic data masking
Rating: (not yet rated)  Rate this |   Briefcase | 2,271 reads

Database Taming

Sometimes a database can seem to be as willful as a colt. Taming it requires an iron nerve, and unflinching eye contact. Occasionally though, you need to know when to jump the fence and regroup.  Read more...
By Phil Factor 2018/02/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 49 reads

Baselining a ReadyRoll project from an existing database

When creating a new ReadyRoll project, the schema of your production environment can also be imported as a baseline. Further work can be built on top of the baseline in a sandbox development environment and, when you’re happy with the changes, the project can be deployed to production.  Read more...
By 2018/02/12 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,883 reads

The COUNT Function in T-SQL

The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not return the desired result. For the big tables, the counting of the rows could cause blocking as well as take some more time.  Read more...
By Igor Micev 2018/02/09 (first published: 2016/07/12) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,938 reads

What to Read in 2018

Steve loves to read all sorts of books and is asking what books you'd read professionally or for fun in 2018.  Read more...
By Steve Jones 2018/02/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 64 reads

Azure Cosmos DB Consistency Levels

The majority of traditional database management systems are responsible for making sure that any changes to their data are consistently reflected in the results of subsequent queries. Azure Cosmos DB extends the range of consistency options by providing support for bounded-staleness, session, and consistent prefix models.  Read more...
By Additional Articles 2018/02/09 | Source: Database Journal | Category: cosmosdb
Rating: (not yet rated)  Rate this |   Briefcase | 1,857 reads

Bringing DevOps to the database. Part 2: Continuous delivery

Many application developers already use continuous integration to automatically test their code, and release management tools to automate application deployment. Database developers can join them.  Read more...
By 2018/02/09 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,223 reads

Webinar: How the GDPR will impact your software delivery processes

With the GDPR enforcement date looming, organisations are focusing on how data is used internally. This webinar will explain the principals of data protection, translate the GDPR jargon, and cover the steps you'll need to consider to ensure compliance in your software delivery process.  Read more...
By 2018/02/09 | Source: Redgate | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 4,250 reads

The Learning Choice

R or Python? Or both? Neither? Where should you spend your learning effort?  Read more...
By Steve Jones 2018/02/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 62 reads

Adaptive Query Processing – Interleaved Execution

Interleaved Execution allows SQL Server's query optimizer to get accurate cardinality estimates in places where it couldn't before.  Read more...
Rating: |  Discuss |   Briefcase | 594 reads

Mobile Report Publisher – Dashboards Everywhere

The new feature, Mobile Reports, was added to SSRS in 2016. It provides the ability to create attractive and useful dashboards that can run on devices and most browsers. Robert Cain shows you how to get started building Mobile Reports with the Mobile Report Publisher.  Read more...
By Additional Articles 2018/02/08 | Source: SimpleTalk | Category: ssrs
Rating: (not yet rated)  Rate this |   Briefcase | 2,959 reads

Introducing database automation with the SQL Toolbelt

In this post, Mary Robbins explains how Absa bank improved development efficiency and minimized risk by implementing SQL Toolbelt.  Read more...
By 2018/02/08 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,367 reads

Hint Word Search

This is a word search for most (but not all) of the hints available in T-SQL.  Read more...
By Kenneth Fisher 2018/02/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 63 reads
<< Newer    Items 21 to 40 of 16548    Older >>