.NET

Dino Esposito in .NET

Multi-Step Input Forms in ASP.NET MVC

It is a common problem with a web page that a form is too complex to fit easily on the...

16 September 2016 13 min read

Blogs

Dennes Torres in Blogs

Careful With Trustworthy Setting

Trustworthy database setting is an easy solution for some problems in the server, especially cross database access. However, this setting...

16 September 2016 2 min read

Database Administration

William Brewer in Database Administration

Database Cloud Backup Cribsheet

Several database backup providers are now offering ‘Database Backup to the Cloud’, or ‘Backup As A Service’ (BaaS). There is...

12 September 2016 14 min read

Blogs

Tony Davis in Blogs

JSON and the Arguments

Now that we’re getting better support for storing JSON (JavaScript Object Notation) in databases, what is it really giving us?...

08 September 2016 3 min read

.NET

Igor Kolosovskyi in .NET

Is JavaScript Single-Threaded?

Developing JavaScript for web pages can be perplexing. You will get errors that seem to make no sense, You will...

08 September 2016 10 min read

Database DevOps

Hari Yadav in Database DevOps

Master Data Services – The Basics

Master Data Services (MDS) is Microsoft's platform for supporting Master Data Management (MDM). A system like MDS, if properly maintained,...

07 September 2016 16 min read

Anju Garg

Oracle Database 12.1.0.2c : Hot Cloning of Non-Container Databases

In the initial release of Oracle 12c (12.1.0.1c), a non-Container Database (non-CDB) could be converted to a pluggable database (PDB)...

05 September 2016 7 min read

Jonathan Lewis

Text Indexes

The Oracle database has many features that are not spoken of frequently and a recent note by Connor McDonald reminded...

05 September 2016 14 min read

Aman Sharma

Oracle SQL Query Parsing: Hard Parse vs Soft Parse, Cursor Caching, Library Cache, and Query Transformation

Oracle SQL query parsing explained - the query processing workflow from SQL statement to execution plan, the difference between hard...

05 September 2016 14 min read

PowerShell

Nicolas Prigent in PowerShell

PowerShell Just Enough Administration (JEA): Role Capabilities, Session Configurations, and Constrained Endpoints for Least-Privilege Admin

PowerShell Just Enough Administration (JEA) - implementing least-privilege delegated administration with role capability files, session configuration files, and constrained JEA...

05 September 2016 16 min read

Database Administration

Shel Burkow in Database Administration

In-Memory OLTP: Row Visibility in SQL Server’s MVCC

SQL Server's In-memory OLTP is fast, due to its multi-valued concurrency control (MVCC). MVCC avoids the need for locks by...

05 September 2016 15 min read

Jonathan Lewis

Massive Deletes – Part 4

In the previous installment of this series I produced some figures highlighting the main differences between doing a large delete...

05 September 2016 10 min read

T-SQL Programming

Uwe Ricken in T-SQL Programming

DELETE Operation in SQL Server HEAPs

You should stick to using tables in SQL Server, rather than heaps that have no clustered index, unless you have...

05 September 2016 14 min read

David Njoku

JSON For Absolute Beginners: Part 2 – Why Use Oracle?

In this short series of articles, we’ll be talking about JSON and its integration with the Oracle database. The first...

02 September 2016 5 min read

David Njoku

JSON For Absolute Beginners: Part 1- Introduction

Hi, meet my friend JSON. Chances are you’ve heard of it, perhaps you have a vague idea of what it’s...

02 September 2016 5 min read

Blogs

Phil Factor in Blogs

Using Computed Columns and Scalar Functions in SQL Server for Text Transformations and Anagrams

Use SQL Server computed columns with scalar functions to precompute text transformations - shown through two worked examples: finding textonyms...

31 August 2016 14 min read

Blogs

Dennes Torres in Blogs

Creating schemas without DBO permission

One result of having the correct care with the access permissions in our databases is the need to avoid the...

31 August 2016 2 min read

Blogs

Tony Davis in Blogs

Why is Uninstalling SQL Server Such a Pain?

A developer friend of mine recently, upon the briefest mention of SQL Server, descended unexpectedly into a rant about the...

30 August 2016 3 min read

.NET

Tom Fischer in .NET

C# Interactive Window and .csx Scripts in Visual Studio: REPL for .NET

C# Interactive Window and .csx script files let you explore .NET APIs and prototype code without a full compile-run cycle....

26 August 2016 16 min read

.NET

Dino Esposito in .NET

Taking Pictures from HTML

Sometimes a request from a user who doesn't appreciate the limitations of the technology can jolt you into discovering that...

25 August 2016 12 min read

Register for Simple Talk

Articles

Multi-Step Input Forms in ASP.NET MVC

Careful With Trustworthy Setting

Database Cloud Backup Cribsheet

JSON and the Arguments

Is JavaScript Single-Threaded?

Master Data Services – The Basics

Oracle Database 12.1.0.2c : Hot Cloning of Non-Container Databases

Text Indexes

Oracle SQL Query Parsing: Hard Parse vs Soft Parse, Cursor Caching, Library Cache, and Query Transformation

PowerShell Just Enough Administration (JEA): Role Capabilities, Session Configurations, and Constrained Endpoints for Least-Privilege Admin

In-Memory OLTP: Row Visibility in SQL Server’s MVCC

Massive Deletes – Part 4

DELETE Operation in SQL Server HEAPs

JSON For Absolute Beginners: Part 2 – Why Use Oracle?

JSON For Absolute Beginners: Part 1- Introduction

Using Computed Columns and Scalar Functions in SQL Server for Text Transformations and Anagrams

Creating schemas without DBO permission

Why is Uninstalling SQL Server Such a Pain?

C# Interactive Window and .csx Scripts in Visual Studio: REPL for .NET

Taking Pictures from HTML