Additional Articles

Webinar: Redgate Database Lifecycle Management (DLM) Demo

by Additional Articles

Redgate

SSC's Steve Jones will show you how Redgate's DLM solution works to improve your database development and deployment processes. You'll see how to version control your databases from SSMS to track and understand changes, include your database in your Continuous Integration process to get quick feedback, automate your database deployment process to have safe, reliable, repeatable deployments, and more.

2015-10-19 (first published: 2015-10-15)

4,162 reads

Idle Connection Resiliency

by Additional Articles

Microsoft MSDN

SQL Server 2014

Describes the idle connection resiliency feature, which allows ODBC and SqlClient data access applications to maintain their connections to SQL Server 2014 or an Azure SQL Database.

2015-10-16

2,930 reads

Integration Services Logging Levels in SQL Server 2016

by Additional Articles

MSSQLTips.com

Integration Services (SSIS)

At the time of writing, SQL Server 2016 preview (CTP 2.3) has been released and there are some changes for the Integration Services (SSIS) Catalog logging levels.

2015-10-15

3,310 reads

Azure SQL Database - Row-Level Security

by Additional Articles

Database Journal

Azure SQL database

One of the benefits of using Azure-based Platform-as-a-Service and Software-as-a-Service offerings, is considerably quicker access to newly developed capabilities. In this article Marcin Policht focuses on row-level security, included in both Azure SQL Database V12 and SQL Server 2016 Community Technology Preview 2 (CTP2).

2015-10-14

3,552 reads

SQL Server 2014 and Windows Azure Blob Storage Service: Better Together

by Additional Articles

Microsoft MSDN

SQL Server 2014

This technical article will cover in depth SQL Server 2014 Data Files on Azure Blob storage service, starting from step-by-step configuration

2015-10-13

2,489 reads

Power BI Desktop Web Queries to Screen Scrape Data from Websites

by Additional Articles

MSSQLTips.com

Power BI

I have heard the new Power BI Desktop can screen scrape data off websites; how does that process work?

2015-10-12

3,473 reads

Storing Passwords in a Secure Way in a SQL Server Database

by Additional Articles

MSSQLTips.com

Storing passwords

Measures such as using special characters and numbers within a password are of little use to security if passwords are then stored in an insecure way. Sergey Gigoyan explains how to encrypt and store passwords in a SQL Server database.

2015-10-09

5,878 reads

SQL and R

by Additional Articles

SimpleTalk

R Platform

There is plenty that is novel and perhaps foreign to a new R user, but it's no reason to abandon your hard-earned SQL skills! In this article, Casimir Saternos explains that not only can you easily retrieve data from SQL Sources for analysis and visualisation in R, but you can also use SQL to create, clean, filter, query and otherwise manipulate datasets within R, using a wide choice of relational databases.

2015-10-08

6,620 reads

Follow-Up on Cursor Options

by Additional Articles

SQLPerformance.com

Cursor Options

In this follow-up to a previous article, Aaron Bertrand reiterates that – while you should never just accept the defaults – you really should think about which options are most applicable to your scenario.

2015-10-07

5,494 reads

Automatic UNDO in Oracle

by Additional Articles

Database Journal

Oracle

Automatic UNDO Management isn't voodoo or black magic, although it can seem that way when it isn't clearly understood. How does Oracle decide how many UNDO segments to create at startup, and what is the underlying goal of the process? David Fitzjarrell investigates.

2015-10-06

3,322 reads

All authors

Additional Articles

Webinar: Redgate Database Lifecycle Management (DLM) Demo

Idle Connection Resiliency

Integration Services Logging Levels in SQL Server 2016

Azure SQL Database - Row-Level Security

SQL Server 2014 and Windows Azure Blob Storage Service: Better Together

Power BI Desktop Web Queries to Screen Scrape Data from Websites

Storing Passwords in a Secure Way in a SQL Server Database

SQL and R

Follow-Up on Cursor Options

Automatic UNDO in Oracle

Blogs

PlanTrace Now Supports PostgreSQL

A New Word: the Kinder Surprise

Crash-Consistent Snapshot Cloning - Hyper-V Edition

Forums

BCA KCU HARAPAN INDAH CSTelpon : 0853-73737551

BCA KCP Daan Mogot Dua TLP/WA 08216977701

Bank Central Asia Tlp/Wa 08216366654

Question of the Day

The Distance Metric