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

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

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,006 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 | 573 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 | 94 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,530 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,676 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,243 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,427 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 | 56 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 | 706 reads

Monitor Query Performance Using Query Store in SQL Server

The Query Store captures a history of queries, execution plans, and runtime statistics, which persist within SQL Server and can be reviewed later.  Read more...
By Additional Articles 2018/04/12 | Source: Database Journal | Category: query performance
Rating:  Rate this |   Briefcase | 3,641 reads

Extending DevOps to the database: branching and merging

This webinar will focus on branching and merging with Visual Studio Team Services (VSTS) as part of a DevOps approach to database development. It will also show how Redgate tools plug into VSTS to enable the build, test and deployment of your database changes. There will also be plenty of time to ask Grant and Arneh questions.   Read more...
By 2018/04/12 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 4,020 reads

IoT Success

The use of IoT is growing in businesses.  Read more...
By Steve Jones 2018/04/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 37 reads

Row-Level Security Predicate Functions - Level 2 of the Stairway to Row Level Security

In this level, we dive deeper into predicates and the various ways to structure them in an RLS environment.  Read more...
By Steve Jones 2018/04/11 | Source: SQLServerCentral.com | Category: row-level security (rls)
Rating: |  Discuss |   Briefcase | 589 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2018/04/11 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 74,140 reads

Software Testing Skills Must Shift with AI

Artificial intelligence (AI) is touching many parts of our lives and careers. Rama Anem discusses the impact of AI on software testing and how testers’ skills must adapt.  Read more...
By Additional Articles 2018/04/11 | Source: SimpleTalk | Category: artificial intelligence (ai)
Rating: (not yet rated)  Rate this |   Briefcase | 2,651 reads

The Best Ever

Steve wants to know which version of SQL Server you like the best.  Read more...
By Steve Jones 2018/04/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 56 reads

TRIM() in T-SQL

The T-SQL language expanded in SQL Server 2017 with the TRIM() function.  Read more...
By Steve Jones 2018/04/10 | Source: SQLServerCentral.com | Category: trim()
Rating: |  Discuss |   Briefcase | 1,787 reads

“Full Stack” Means “Part Time” – or Why DBAs Might Wanna Learn DevOps

Brent Ozar explains that if you're going to do continuous integration or deployment, you've got a rocky road ahead of you.  Read more...
By Additional Articles 2018/04/10 | Source: Brent Ozar Unlimited Blog | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 4,458 reads
<< Newer    Items 21 to 40 of 16728    Older >>