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

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

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 | 67 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,461 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 | 879 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 | 75 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,377 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,446 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,032 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,900 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,935 reads

The top 10 considerations when designing a data platform

Designing a data platform for a new product or service is a fascinating and exciting challenge. It’s also a daunting one.  Read more...
By 2018/01/03 | Source: Redgate | Category: data platform
Rating: (not yet rated)  Rate this |   Briefcase | 3,364 reads

Automatic Plan Correction

SQL Server 2017 lets you solve parameter sniffing problems - Automatically!  Read more...
By Wayne Sheffield 2018/01/02 (first published: 2017/11/20) | Source: SQLServerCentral.com | Category: automatic plan correction
Rating: |  Discuss |   Briefcase | 977 reads

Understanding Your Value

Data can help you understand the value you bring to a company as a data professional.  Read more...
By Steve Jones 2018/01/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 85 reads

Create Size-based Backups for SQL Server 2017

Jeffrey Yao explains how to generate backups based on the amount of data that has changed for differential and transaction log backups.  Read more...
By Additional Articles 2018/01/02 | Source: MSSQLTips.com | Category: sql server 2017
Rating: (not yet rated)  Rate this |   Briefcase | 3,132 reads

How you can improve your SQL with code analysis in SQL Prompt

You could think of the code analysis feature in SQL Prompt as a machine-assisted code review. The rules that are used to check your code point out questionable areas that might be missed during regular testing.  Read more...
By 2018/01/02 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,615 reads

Happy New Year 2018

Today starts 2018  Read more...
By Steve Jones 2018/01/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 22 reads

PowerShell Tool Time: Controlling Our Tools

The next installment of the Powershell Tool Time series shows you how to manage backup files by   Read more...
By Mike Fal 2018/01/01 (first published: 2015/09/16) | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 4,554 reads

Can you prevent deletes and inserts without a WHERE clause from running?

Erik writes a script to do what it says on the tin.  Read more...
By Additional Articles 2018/01/01 | Source: Brent Ozar Unlimited Blog | Category: delete
Rating: (not yet rated)  Rate this |   Briefcase | 4,372 reads

Sizing New Servers

Steve Jones talks hardware, which he mostly doesn't worry about for SQL Servers.  Read more...
By Steve Jones 2018/01/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 37 reads

Level 4 - Building the Hyper-V VM

In this level of the Stairway to Server Virtualization, learn how to build a Hyper-V virtual machine for SQL Server.  Read more...
By David Klee 2017/12/29 (first published: 2015/10/07) | Source: SQLServerCentral.com | Category: virtualization
Rating: |  Discuss |   Briefcase | 4,580 reads
<< Newer    Items 41 to 60 of 16448    Older >>