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

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

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,267 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,683 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 | 64 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 | 725 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,871 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,545 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 | 39 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 | 607 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,267 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,793 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,800 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 | 61 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,553 reads

How to Programmatically Identify When Your SQL Server Was Last Started

Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.  Read more...
By Additional Articles 2018/04/10 | Source: Database Journal | Category: administration
Rating: (not yet rated)  Rate this |   Briefcase | 3,186 reads

What's Downtime?

Steve asks the question today of how you might measure downtime and the scope you are concerned about.  Read more...
By Steve Jones 2018/04/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 40 reads

Stumbling over Words

Phil Factor argues that the ability to write simply and expressively is a much under-valued skill in IT, and explains the main traps to avoid.  Read more...
By Phil Factor 2018/04/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 75 reads

Avoiding Unexpected Results with DATEDIFF in Year Comparisons

Learn how to avoid unexpected results when using the DATEDIFF function to find the difference between two dates in years.  Read more...
By David Strack 2018/04/09 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,278 reads

Mount SQL Server DMVs and Custom Queries Using DBFS on Linux

With SQL Server now supported on Linux, traditional SQL Server DBAs will need to learn how to work with Linux, and Linux administrators will need to learn how to work with SQL Server. Fortunately, there are several tools available to assist. In this article Prashanth Jayaram describes how to work with the DMV tool which treats queries as files.  Read more...
By Additional Articles 2018/04/09 | Source: SimpleTalk | Category: sql server on linux
Rating: (not yet rated)  Rate this |   Briefcase | 2,240 reads

How to execute a Powershell script via SSIS

Learn how you can execute a PowerShell script via the SSIS execute process task.  Read more...
By Perry Whittle 2018/04/06 (first published: 2015/12/03) | Source: SQLServerCentral.com | Category: execute process task
Rating: |  Discuss |   Briefcase | 5,667 reads
<< Newer    Items 41 to 60 of 16742    Older >>