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

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

The Digital Twin

GE is using lots of data, and machine learning to predict when specific systems will fail by nurturing digital twins.  Read more...
By Steve Jones 2017/07/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 38 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's new 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 2017/07/19 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 37,929 reads

7 Things Every SQL Server DBA Should Know About Linux

In this tip John Grover will help you make the transition to SQL Server on Linux by explaining the things you need to know.  Read more...
By Additional Articles 2017/07/19 | Source: MSSQLTips.com | Category: linux
Rating: (not yet rated)  Rate this |   Briefcase | 2,843 reads

SQL Data Mask: new masking features, constants and composition

Find out what's new, what's next, and what's coming soon to Redgate's free prototype tool, SQL Data Mask. Don't forget to let them know what you think - if you want to help shape what data masking by Redgate should look like, the team are always available to talk!  Read more...
By 2017/07/19 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 3,069 reads

Configuring Backups Using Veritas Netbackup with AGs

A short description of our experience with Veritas Netbackup on MS SQL Server AG Groups. This article does not give a full description of the procedure for configuring netbackup but highlights a few pitfalls which we think some people will find very useful.   Read more...
By Kenneth Igiri 2017/07/18 | Source: SQLServerCentral.com | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 253 reads

Simple SQL: Attribute Splitting

If the design of a relational database is wrong, no amount of clever DML SQL will make it work well. Dr. Codd’s Information Principle is that you have, inside the entity tables, the columns that model the attributes of that entity. The columns contain scalar values. Tables that model relationships can have attributes, but they must have references to entities in the schema. You split those attributes at your peril. Joe Celko explains the basics.  Read more...
By Additional Articles 2017/07/18 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 2,855 reads

Getting Close to the 2017 RTM

SQL Server 2017 has its first RC. 
By Steve Jones 2017/07/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 63 reads

Short Names

Today Steve Jones talks about the short cuts that developers might take, many of which aren't necessarily helpful.  Read more...
By Steve Jones 2017/07/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 77 reads

Azure DWH part 11: Data Warehouse Migration Utility

There is a new utility to import data from SQL Server on premises or Azure SQL to Azure SQL Data Warehouse (ASDW)  Read more...
Rating: |  Discuss |   Briefcase | 271 reads

Potholes in the Road of Progress

Phil Factor looks at some technologists more famous for thwarting progress than for their own creations.  Read more...
By Phil Factor 2017/07/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 58 reads

Getting Started with Azure SQL Data Warehouse - Part 6

Azure SQL Data Warehouse is Microsoft’s new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. In this installment, Arshad Ali covers the different ways to load data into SQL Data Warehouse.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,725 reads

Are your automated tests slowing you down?

Slow, unreliable tests prevent teams doing great work, and make continuous delivery impossible. So what can you do to improve your automated tests?  Read more...
By Additional Articles 2017/07/17 | Source: Redgate | Category: testing
Rating: (not yet rated)  Rate this |   Briefcase | 2,343 reads

Stairway to Advanced T-SQL Level 7: Ordering Your Data Using Ranking Functions

In SQL Server there are 4 different ranking functions: RANK, DENSE_RANK, NTILE, and ROW_NUMBER. These ranking functions were introduced in SQL Server 2005. In this stairway level I will be reviewing each of these different ranking functions, and will show you how to use them by providing a few examples.  Read more...
By Gregory Larsen 2017/07/14 (first published: 2015/09/02) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,450 reads

Cool Projects

This week Steve Jones wants to know what type of really interesting projects you are working on. Is there something you really enjoy and look forward to building?  Read more...
By Steve Jones 2017/07/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 231 reads

Deploying, Securing, and Updating Power BI Reports

Before Excel and other data-linked spreadsheets, business reports needed to be hand-crafted by IT experts, and changes were arbitrated slowly via change control. Power BI was designed to take the liberation that Excel pioneered to the max, by allowing 'power' users to not only to create Power BI desktop reports, graphics and visualisations in Power BI App, but then link and publish these to the Power BI app. These in turn can be given row level security and have their underlying data kept up-to-date so that users can log in and see the relevant and appropriate data in a browser. Saurabh Desai shows how.  Read more...
By 2017/07/14 | Source: SimpleTalk | Category: power bi
Rating:  Rate this |   Briefcase | 2,800 reads

What do you do when you make a mistake?

We all make mistakes, what you do next is what is important.  Read more...
By Ben Kubicek 2017/07/13 | Source: SQLServerCentral.com | Category: mistake
Rating: (not yet rated) |  Discuss |   Briefcase | 48 reads

Power BI - Rename Table Column headings

Trick to rename column headings on a Power BI Table visual  Read more...
By Daniel Taylor 2017/07/13 | Source: SQLServerCentral.com | Category: power bi
Rating: |  Discuss |   Briefcase | 489 reads

Performance Myths: Oversizing string columns

Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.  Read more...
By Additional Articles 2017/07/13 | Source: SQLPerformance.com | Category: performance
Rating:  Rate this |   Briefcase | 5,157 reads

Free prototype tool to audit SQL Server permissions

Redgate have just released SQL Census, a prototype tool from the Foundry division that makes auditing SQL Server user access permissions much easier. In this post Ally Parker shows how it works, tells us what's up next in the tool's development development, and explains how you can download it for free.  Read more...
By 2017/07/13 | Source: Redgate | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 3,599 reads

Unlimited PTO

A guest editorial from Andy Warren looking at the unlimited amount of vacation time from his company.  Read more...
By Andy Warren 2017/07/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 85 reads
<< Newer    Items 21 to 40 of 15933    Older >>