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

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

Setting up R in SQL 2016 – Avoiding Pitfalls

Setting up R in SQL 2016 proved to be trickier than expected, but here is how to avoid the frustrations.  Read more...
By Paulo de Jesus 2017/06/15 | Source: SQLServerCentral.com | Category: r services
Rating: |  Discuss |   Briefcase | 806 reads

Securing the Things

The Internet of Things is coming, and bringing lots of data, but security needs to be included as well.  Read more...
By Steve Jones 2017/06/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 29 reads

Questions About SQL Server Collations You Were Too Shy to Ask

Of course we all like our colleagues to think that we know everything there is to know about SQL Server Collations. However, the truth is that it is a rather complicated topic to fully understand and the cost of getting collation wrong can be great. If only one could ask certain questions on forums or at conferences without blushing. Help is at hand, because Robert Sheldon once again makes the complicated seem simple by answering those questions that you were too shy to ask.  Read more...
By Additional Articles 2017/06/15 | Source: SimpleTalk | Category: collation
Rating: (not yet rated)  Rate this |   Briefcase | 3,452 reads

Data classification: understanding and protecting your data

What is data classification? Why go to the effort of classifying your data? Jonny Roberts explains.  Read more...
By 2017/06/15 | Source: Redgate | Category: classification
Rating: (not yet rated)  Rate this |   Briefcase | 2,713 reads

Stairway to U-SQL Level 15: U-SQL Global Scalar Functions With C#

In this article, see how to created shared functions using C# assemblies in U-SQL.  Read more...
By Mike McQuillan 2017/06/14 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 389 reads

A Bad First Day

A bad first day, as a developer crashes a production database.  Read more...
By Steve Jones 2017/06/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 104 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2017/06/14 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 83,622 reads

Setting Variables in Calling T-SQL Code While Using sp_executesql

In this tip, Greg Larsen shows you how to set variables in your calling T-SQL code when using sp_execute sql.  Read more...
By Additional Articles 2017/06/14 | Source: Database Journal | Category: variables
Rating: (not yet rated)  Rate this |   Briefcase | 3,249 reads

What is normal? Finding outliers with R

How do you currently set alerting thresholds? What is normal? And more importantly, what is truly abnormal? We will explore these questions.  Read more...
By Nick Burns 2017/06/13 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 816 reads

Software Has Bugs

All software has bugs, according to Steve Jones.  Read more...
By Steve Jones 2017/06/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 53 reads

UNION ALL Optimization

Paul White digs into row goals as he explains some interesting and inconsistent behavior with UNION ALL queries in SQL Server.  Read more...
By Additional Articles 2017/06/13 | Source: SQLPerformance.com | Category: union all
Rating: (not yet rated)  Rate this |   Briefcase | 5,304 reads

SQL Data Mask: masking configurations and reports

SQL Data Mask is the latest prototype to come out of the Foundry, Redgate’s research and development division. It copies your database while anonymizing personal data, and you can use it to mask your databases right now, free of charge. This blog post from Developer Santiago Arias explains what's new in the latest update.  Read more...
By 2017/06/13 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 2,831 reads

Two Approaches to Addressing Circular References in SSDT

Both options have their advantages and disadvantages. Neither is universally right for all situations. Understand the differences before picking the model that works for your situation.  Read more...
By Hakim Ali 2017/06/12 | Source: SQLServerCentral.com | Category: ssdt
Rating: |  Discuss |   Briefcase | 716 reads

Guilty of Over-Customising

Am I guilty of over-customising software? Read this and let us know what you think.  Read more...
By Nitin Bhojwani 2017/06/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 73 reads

The Value of Surveys

Phil Factor on the perils of trying to squeeze good insights out of bad surveys.  Read more...
By Phil Factor 2017/06/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 36 reads

Scala and Apache Spark in Tandem as a Next-Generation ETL Framework

Scala and Apache Spark might seem an unlikely medium for implementing an ETL process, but there are reasons for considering it as an alternative. After all, many Big Data solutions are ideally suited to the preparation of data for input into a relational database, and Scala is a well thought-out and expressive language. Krzysztof Stanaszek describes some of the advantages and disadvantages of a scala-based approach to implementing and testing an ETL solution.  Read more...
By Additional Articles 2017/06/12 | Source: SimpleTalk | Category: scala
Rating:  Rate this |   Briefcase | 3,833 reads

Guide to enhancing privacy and addressing GDPR requirements with the Microsoft SQL platform

A new whitepaper published today gives Microsoft SQL customers technical guidance for how to approach GDPR compliance with Microsoft SQL technologies.  Read more...
By Additional Articles 2017/06/12 | Source: Microsoft MSDN | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 4,268 reads

Have production-level PostgreSQL experience?

Redgate are doing some early stage research around PostgreSQL, and would really like to hear about your experiences. If you think you can help, check out their short survey.  Read more...
By 2017/06/12 | Source: Redgate | Category: postgresql
Rating: (not yet rated)  Rate this |   Briefcase | 1,740 reads

They Call Me Andy Null

Who's on first, null edition.  Read more...
By Andy Warren 2017/06/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 104 reads

Understanding OPENJSON and FOR JSON in Azure and SQL 2016

An example of exporting and importing table data with JSON in Azure and SQL Server 2016.  Read more...
By Ryan Loftin 2017/06/09 (first published: 2016/05/05) | Source: SQLServerCentral.com | Category: openjson
Rating: |  Discuss |   Briefcase | 2,638 reads
<< Newer    Items 41 to 60 of 15858    Older >>