Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Daily SQL Articles by email:
Sign up
<< 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 >>
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.