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

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

Welcome to Redgate tools for SQL Operations Studio

Built on top of Visual Studio Code, SQL Operations Studio is a free lightweight tool for modern database development and operations that runs on Windows, macOS and Linux. It’s been designed for developers without a deep knowledge of database administration, so that they can manage databases and maintain them.  Read more...
By 2018/05/17 | Source: Redgate | Category: sql operations studio
Rating: (not yet rated)  Rate this |   Briefcase | 2,434 reads

What is the Machine Learning Server? Level 2 of the Stairway to ML Services

In Level 2, we look at the architecture and structure of the Machine Learning Services server process.  Read more...
Rating: |  Discuss |   Briefcase | 686 reads

The Value of Data

Data can be valuable, and there's a new book that compares the value of data today to that of oil in the previous century. Steve Jones has a few thoughts on why we should consider this to be the case.  Read more...
By Steve Jones 2018/05/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 145 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2018/05/16 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 96,092 reads

Calculating Employee Attrition with DAX – Part 2

In part 1, we described the requirements for calculating attrition and also demonstrated one method that doesn’t rely on writing DAX code at all. In the second part of this tip, we introduce alternative methods of creating a calculation in DAX to calculate the number of employees that have left the company.  Read more...
By Additional Articles 2018/05/16 | Source: MSSQLTips.com | Category: dax
Rating: (not yet rated)  Rate this |   Briefcase | 2,134 reads

Does the Tone matter?

Does the tone of communication matters to you that much that it affects your work in some way?  Read more...
By Nitin Bhojwani 2018/05/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 78 reads

Covering Indexes: Not Just for SELECT but also for UPDATE statements

Covering indexes help UPDATE performance also  Read more...
By Mike Byrd 2018/05/15 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,121 reads

Pseudonymizing your data with SQL Data Generator

SQL Data Generator was, as its name suggests, intended to generate the data for databases, as required for testing, development work and training. However, it is perfectly at home with using the original data as the default source of the new data, and then substituting in fake data for any column that you want to mask - here's how.  Read more...
By 2018/05/15 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 2,794 reads

Calculating Employee Attrition Rate with DAX – Part 1

In many businesses, the HR department needs reports on the employee attrition. This is the number of people that leave the company (depending on the reason they leave; the terminology can also be dismissals or turnover). Suppose you have a table with your employee data, where you also store a possible termination date. How do you calculate the number of people who have left the company using the DAX query language?  Read more...
By Additional Articles 2018/05/15 | Source: MSSQLTips.com | Category: dax
Rating: (not yet rated)  Rate this |   Briefcase | 2,299 reads

How do you deal with disappointment?

Disappointment is hard, but you get to choose how you react to it.  Read more...
By Ben Kubicek 2018/05/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 82 reads

Auto assign Column Data Types for Flat file Source Import

A tip to auto detect data types for flat file sources in SSIS. Never manually enter them ever again!   Read more...
Rating: |  Discuss |   Briefcase | 800 reads

SQL Server Graph Databases – Part 4: Working with Hierarchical Data in a Graph Database

The Graph Database feature, new with SQL Server 2017, can be used to represent hierarchies. In this article of the series, Robert Sheldon demonstrates how to represent hierarchies in data with complex relationships.  Read more...
By Additional Articles 2018/05/14 | Source: SimpleTalk | Category: sql server graph database
Rating: (not yet rated)  Rate this |   Briefcase | 3,273 reads

Strange Filtered Index Problem

What I thought was a strange filtered index problem but turned out to be a DB settings problem  Read more...
By Mike Good 2018/05/11 (first published: 2015/08/26) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,454 reads

Interviewing Avatars

Maybe you'll be able to send your avatar to an initial phone screen one day.  Read more...
By Steve Jones 2018/05/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 56 reads

Create Azure VMs with PowerShell Part 1

Azure virtual machines are created for many reasons, even just to have an environment to quickly test something out. In this article, Robert Cain demonstrates the first few steps in automating the process with PowerShell. He shows how to gather information needed and set up a resource group, storage and networking needed for the VM.  Read more...
By Additional Articles 2018/05/11 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,444 reads

Automatic Provisioning of Developer Databases with SQL Provision

This article shows a simple proof-of-concept workflow that allows an organization to provision full size databases for developers, using production like data that has been masked automatically as part of the provisioning process.  Read more...
By 2018/05/11 | Source: Redgate | Category: provisioning
Rating: (not yet rated)  Rate this |   Briefcase | 2,741 reads

Power BI Desktop on the Mac

By Steve Jones 2018/05/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 27 reads

One Million Tables

A quick experiment to create one million tables in a database.  Read more...
By Steve Jones 2018/05/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,289 reads

Setting up SQL Server on Red Hat Linux in AWS - Part 1

In this post, Pinakin Patel looks at the preliminary steps you need to peform to build an instance in AWS to run SQL Server on Red Hat Linux.  Read more...
By Additional Articles 2018/05/10 | Source: MSSQLTips.com | Category: sql server on linux
Rating: (not yet rated)  Rate this |   Briefcase | 2,926 reads

SQL Compare Snapshots: a lightweight database version control and rollback mechanism

SQL Compare snapshots provide an easy way to keep track of changes during development work, whether they are small changes between iterations, or significant changes between releases. Snapshots can be used to quickly generate rollback scripts during releases even in environments which are isolated by infrastructure design for security reasons.  Read more...
By 2018/05/10 | Source: Redgate | Category: version control
Rating: (not yet rated)  Rate this |   Briefcase | 2,663 reads
<< Newer    Items 21 to 40 of 16820    Older >>