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

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

SQL Server Graph Databases – Part 2: Querying Data in a Graph Database

Along with Graph Databases, Microsoft has introduced the new MATCH function for querying them. Robert Sheldon explains how to use the new function.  Read more...
By Additional Articles 2018/04/19 | Source: SimpleTalk | Category: sql server graph database
Rating: (not yet rated)  Rate this |   Briefcase | 2,537 reads

5 challenges to scaling DevOps at enterprise level

Many large enterprises launch small DevOps initiatives within certain departments, but subsequently find that scaling DevOps across the organization faces a number of challenges that must be overcome.  Read more...
By 2018/04/19 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,966 reads

Stairway to Columnstore Indexes Level 5: Adding New Data To Columnstore Indexes

Earlier levels have shown how Columnstore Indexes work effectively with static data. In most tables however, data is hardly ever static. We are constantly inserting new rows, and updating or deleting existing rows. If you think about what this means for a columnstore index, you will realize that this comes with some unique challenges.  Read more...
By Hugo Kornelis 2018/04/18 (first published: 2015/11/04) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,623 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2018/04/18 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 103,502 reads

Why sp_prepare Isn’t as “Good” as sp_executesql for Performance

Erik Darling shows how execution plan estimates suffer.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,674 reads

Good Security Needs Layers

A good security system needs layers since our applications and platforms don't exist in a vacuum.  Read more...
By Steve Jones 2018/04/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 34 reads

Fixing system database corruption with setup.exe

Corruption of the system databases is a serious matter. Setup.exe is a brute force method of replacing them.  Read more...
By Kenneth Fisher 2018/04/17 | Source: SQLServerCentral.com | Category: database corruption
Rating: |  Discuss |   Briefcase | 656 reads

Machine Learning Challenges

Machine Learning is an exciting branch of computer science, but it doesn't solve all our problems.  Read more...
By Steve Jones 2018/04/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 47 reads

Recover Data in SQL Server AWS RDS with the Help of BACPAC

With Amazon RDS, it’s easy to have a SQL Server running in minutes. There are some limitations, though. Seth Delconte explains a workaround to overcome one of the limitations: the inability to restore a second copy of a database to recover missing data.  Read more...
By Additional Articles 2018/04/17 | Source: SimpleTalk | Category: aws
Rating: (not yet rated)  Rate this |   Briefcase | 2,132 reads

Effective Database Testing with SQL Test and SQL Cover

A well-established technique for improving application code quality, during software development, is to run unit tests, in conjunction with a code coverage tool. The aim is not only to test that your software components behave as you would expect, but also that your suite of tests gives your code a thorough workout.  Read more...
By 2018/04/17 | Source: Redgate | Category: testing
Rating: (not yet rated)  Rate this |   Briefcase | 2,192 reads

SQL Server From .Net: Making A Connection

A basic introduction for developers about creating a connection from .Net to SQL Server, and some of the options available.  Read more...
By Tim Wellman 2018/04/16 | Source: SQLServerCentral.com | Category: ado.net
Rating: |  Discuss |   Briefcase | 599 reads

In Depth Learning at the PASS Summit

The pre-conference sessions for the 2018 PASS Summit were released.  Read more...
By Steve Jones 2018/04/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 38 reads

Desperation on the Forums

Grant talks about the challenges of helping people in online forums and getting them to learn rather than grab the first solution.  Read more...
By Grant Fritchey 2018/04/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 97 reads

Using T-SQL to Detect Stock Price Reversals with the RSI

Rick Dobson explains the Relative Strength Index (RSI), and shows how to create a TSQL script that computes the RSI for a stock closing price series.  Read more...
By Additional Articles 2018/04/16 | Source: MSSQLTips.com | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 2,705 reads

Redgate’s SQL Privacy Summit – London, 18 May

Are you responsible for data privacy and protection of SQL Server databases in your organization? Then you might be interested in Redgate’s brand new conference, the SQL Privacy Summit, taking place in London on Friday 18 May.  Read more...
By 2018/04/16 | Source: Redgate | Category: event
Rating: (not yet rated)  Rate this |   Briefcase | 1,847 reads

SSIS Design Pattern - Staging Fixed Width Flat Files

Learn how to load fixed width flat files to staging tables in this article from Samuel Vanga.  Read more...
By Samuel Vanga 2018/04/13 (first published: 2015/10/06) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 5,260 reads

How to find a specific text string in a SQL Server Stored Procedure, Function, View or Trigger

How can I accurately find which SQL Server Stored Procedures, Views or Functions are using a specific text string, which can be a table name or anything like a string starting with 'XYZ'?  Read more...
By Additional Articles 2018/04/13 | Source: MSSQLTips.com | Category: stored procedures
Rating:  Rate this |   Briefcase | 4,633 reads

Believing the Data

Data is becoming the source of truth, but we need to learn to accept that.  Read more...
By Steve Jones 2018/04/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 63 reads

Considering Other Views

When we build software, are we empathetic to how others (literally) view our software?  Read more...
By Steve Jones 2018/04/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 57 reads

SQL Server on Amazon RDS vs SQL Server on Amazon EC2

Exploring briefly the difference between using Amazon Machine Images running SQL Server and using SQL Server instances on Amazon's Relational Database Service.  Read more...
By Kenneth Igiri 2018/04/12 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 720 reads
<< Newer    Items 21 to 40 of 16737    Older >>