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

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

When Does Index Size Change Index Choice?

Erik purposely fragments indexes trying to slow down queries.  Read more...
By Additional Articles 2018/02/15 | Source: Brent Ozar Unlimited Blog | Category: indexes
Rating: (not yet rated)  Rate this |   Briefcase | 2,652 reads

Calculating DTU's for Azure SQL Database

This calculator will help you determine the number of DTUs for your existing SQL Server database(s) as well as a recommendation of the minimum performance level and service tier that you need before you migrate to Azure SQL Database.  Read more...
Rating: |  Discuss |   Briefcase | 529 reads

Valentines Day for Data Professionals

Today Steve Jones asks about how your relationship is at work.  Read more...
By Steve Jones 2018/02/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 62 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's 2016 In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2018/02/14 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 45,029 reads

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,551 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 | 559 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,226 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,696 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,324 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

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 | 50 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,311 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,940 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,964 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 | 65 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,924 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,273 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,408 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 | 63 reads
<< Newer    Items 21 to 40 of 16552    Older >>