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

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

Azure DWH part 23: Data Mining

SQL Server on-premises includes a module to create Data Mining models. We will show how to create them using ASDW.  Read more...
By Daniel Calbimonte 2018/01/09 | Source: SQLServerCentral.com | Category: data
Rating: |  Discuss |   Briefcase | 242 reads

Is This Data Science?

An analysis of salaries uses statistics to determine significance of the data. Is this data science?  Read more...
By Steve Jones 2018/01/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 55 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free ebook Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible.  Read more...
By Additional Articles 2018/01/09 | Source: SimpleTalk | Category: in-memory oltp
Rating:  Rate this |   Briefcase | 3,206 reads

GDPR: Why We Stopped Selling Stuff to Europe

The EU’s new General Data Protection Regulation (GDPR) is a set of rules that give consumers rights about how their data is stored, used, and deleted. In this post Brent Ozar provides some handy resources, and sparks some interesting debate.  Read more...
By 2018/01/09 | Source: Brent Ozar Unlimited Blog | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 4,545 reads

How to Change the File Extension for a Data File

This is a fix to primary data file that is created with a different file extension or accidentally renamed to a different file extension  Read more...
By Sadan Kumar Budde 2018/01/08 | Source: SQLServerCentral.com | Category: data file
Rating: |  Discuss |   Briefcase | 653 reads

6 reasons why your development team needs SQL Prompt

While SQL Prompt cannot turn an unskilled database programmer into a SQL hero, it will drive up the productivity of a typical multi-skilled development team, and reduce reliance on specialist database developers.  Read more...
By 2018/01/08 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,439 reads

It's the Engineers

The staff that build your systems are more important than your choice of technology.  Read more...
By Steve Jones 2018/01/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 66 reads

Implementing Azure SQL Database Virtual Network Service Endpoints and Rules

In previous articles, Marcin Policht has described the main characteristics of two new features known as Virtual Network service endpoints and Azure SQL Database virtual network rules. In this article, he focuses on the details of implementing this functionality.  Read more...
By 2018/01/08 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 1,739 reads

Critical SQL Server Patches for Meltdown and Spectre

Everyone needs to learn about these hardware bugs and apply patches as soon as possible.  Read more...
By Steve Jones 2018/01/22 (first published: 2018/01/05) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 3,667 reads

Nasty Fast PERCENT_RANK

Alan Burstein discusses a better performning alternative to PERCENT_RANK that works on SQL Server versions 2005+  Read more...
By Alan Burstein 2018/01/05 (first published: 2016/06/07) | Source: SQLServerCentral.com | Category: percent_rank
Rating: |  Discuss |   Briefcase | 5,091 reads

It's Time to Patch and Upgrade

With bugs in our CPUs, everyone needs to plan on patching or upgrading.  Read more...
By Steve Jones 2018/01/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 69 reads

Questions about Data Masking That You Were Too Shy to Ask

The General Data Protection Regulation (GDPR) will be in effect in May of 2018. Data masking is one technique that can help your organization comply with this and other regulations. William Brewer answers those questions about data masking that you were too shy to ask.  Read more...
By Additional Articles 2018/01/05 | Source: SimpleTalk | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 3,471 reads

A Brief History of Data Analysis

Take a look at Data Analysis from ancient times to current days  Read more...
By Pete Revell 2018/01/04 | Source: SQLServerCentral.com | Category: data analysis
Rating: |  Discuss |   Briefcase | 887 reads

Using Better Tools

Some companies don't want to use tools, but that doesn't make sense to Steve Jones.  Read more...
By Steve Jones 2018/01/04 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 77 reads

SQL Server Machine Learning Services – Part 1: Python Basics

Python is a very popular language used for many purposes including machine learning. SQL Server 2017 supports Python with its Machine Learning Services component. Robert Sheldon explains how to get started using Python in SQL Server in the first article of this series.  Read more...
By Additional Articles 2018/01/04 | Source: SimpleTalk | Category: machine learning (ml)
Rating: (not yet rated)  Rate this |   Briefcase | 5,399 reads

If you hear these phrases, you might need Microsoft Visual Studio Team Services

There are so many features in Microsoft Visual Studio Team Services that it can be difficult to wrap your head around what all they do and if you’re utilizing the tool to its fullest potential.  Read more...
By 2018/01/04 | Source: Redgate | Category: visual studio team services
Rating: (not yet rated)  Rate this |   Briefcase | 3,465 reads

Stairway to MDX - Level 4: The Order() Function: Beyond Cube Hierarchies

Bill Pearson continues his examination of the versatile Order() function, focusing upon its use in providing dataset sorts that reach beyond dimensional hierarchies  Read more...
By Bill Pearson 2018/01/03 (first published: 2011/08/26) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,035 reads

No Magical DevOps

DevOps isn't magic. It's just a way of getting better at how you build software.  Read more...
By Steve Jones 2018/01/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 44 reads

How to Turn on Instant File Initialization

Not having instant file initialization turned on slows down the process of adding pages to your database, because prior to allocating the data pages to your database, SQL Server needs to zero out the newly allocated pages.  Read more...
By Additional Articles 2018/01/03 | Source: Database Journal | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 2,922 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2018/01/03 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 87,952 reads
<< Newer    Items 41 to 60 of 16459    Older >>