Search - CodeProject

T-SQL

OLAP for Free

20 Jun 2019 by IChechin license: CPOL

How to implement free OLAP cube in your project

Database » Database » Data Access

OLAP

T-SQL

Is MS SQL SERVER Service Broker responding to read uncommitted data?

21 May 2019 by digimanus license: CPOL

When using SqlDependency is it possible that a detected change leads to 0 rows in the SqlDependency results.

.NET

T-SQL

SqlDependency

Strange Behavior on JSON_VALUE When Table Contains Blank and Non-blank Values (JSON Text is Not Properly Formatted. Unexpected Character '.' is Found at Position 0.)

12 May 2019 by Manjuke Fernando license: CPOL

Observations made for a strange behavior on JSON_VALUE when table contains blank and non-blank values

Web Development » Client Side Scripting » General

T-SQL

SSMS

SQL-Server-2016

Node.js for .NET Developers by WCF

3 Apr 2019 by Mahsa Hassankashi license: CPOL

This article illustrates how to use Node.js by WCF which is written in C# and using node.js as real time communication technology with the aid of C# code to connect MS SQL Server.

Web Development » Web Services » General

, +

WHILE Loops in T-SQL Stored Procedures

13 Mar 2019 by essentialSQL license: MIT

In this lesson, we’re going to learn about the While Loop. So, what is a While Loop? Well, While Loop is set up using a While statement. While statements are used to repeatedly execute a block of SQL statements.

Database » Sql Reporting Services » General

T-SQL

Use hierarchyid to query Hierarchical data

13 Mar 2019 by essentialSQL license: MIT

In this SQL minute we’ll look at how you can use hierarchyid to query hierarchy data. This is a two-part article. In this article we look at how to do one query to get portion of the hierarchy.

T-SQL

Dynamic Pivoting with Cubes and eventhandlers in SQL Server

19 Dec 2018 by digimanus license: CPOL

In this article, the creation of dynamic pivots are explained. This works on SQL Server from version 2005 and above!

Database » Database » Databases

T-SQL

Single Page Application (SPA) for Enterprise App (Angular2 & WebApi) - Part 1 - Overview

20 Nov 2018 by tranthanhtu.vn license: CPOL

How to build the SPA for enterprise application using Angular2 and WebApi (RESTful)

Web Development » Applications & Tools » Applications

, +

Migrate Data from SQL Server to Azure Cosmos DB

8 Nov 2018 by Srinivasa Dinesh Parupalli license: CPOL

Importing Documents from SQL Server to Azure Cosmos DB

Cloud Computing » Azure » General

T-SQL

Move Database File from One Drive to Another Drive

17 Oct 2018 by User-12551084 license: CPOL

Moving database file from one drive to another drive

T-SQL

SSMS

Improving Backup Performance

1 Oct 2018 by Satnam Singh SQL DBA India license: CPOL

Improving backup performance

T-SQL

The Power of Combination Formulas (for design and quality assurance) and Joins (for execution).

11 Sep 2018 by Steven L. Wentworth (12896862) license: CPOL

Using combination arithmetic to improve quality of SQL table design and execution

Database » Database » Sql

T-SQL

Applying Database Principal Throughout the Server (for all Databases) for a Particular User

10 Sep 2018 by Manjuke Fernando license: CPOL

How to give db_datareader access to a specific user across all the databases on a particular SQL Server

Web Development » Site & Server Management » General

T-SQL

SSMS

Automation of SQL Database Mirroring

26 Jul 2018 by Dathuraj Pasarge license: CPOL

Mirroring setup without any DBA effort - on every new DB creation on the SQL Server !!!

T-SQL

Issues after Upgrade to SQL Server 2017 – Cannot Bulk Load Data Into the Table with Primary Key Constraint on it

11 Jul 2018 by Satnam Singh SQL DBA India license: CPOL

Cannot Bulk Load Data Into the Table with Primary Key Constraint on it

Oracle

T-SQL

Using SQLite in C#.VB.Net

25 Jun 2018 by Dirk Bahle license: CPOL

A quick guide to managing 100000'ish records efficiently with SQLite and C#/.Net.

, +

Using NServiceBus in Azure Service Fabric

6 Jun 2018 by Gunnar S license: CPOL

Third article in a series of three regarding NServiceBus, WebAPI and Azure Service Fabric

Cloud Computing » Azure » General

, +

SQL Server Brute Force Attack Detection: Part 4

30 Apr 2018 by Ryan G Conrad license: CPOL

Using Powershell and Windows Task Scheduler API to detect malicious login attempts on a remotely accessible SQL Server database

, +

SQL Server Brute Force Attack Detection: Part 3

25 Mar 2018 by Ryan G Conrad license: CPOL

More configurations and auditing tools

T-SQL

SQL Server Brute Force Attack Detection: Part 1

25 Mar 2018 by Ryan G Conrad license: CPOL

Prevent brute-force login attacks on a remotely accessible SQL Server database using T-SQL

T-SQL

SQL Server Brute Force Attack Detection: Part 2

25 Mar 2018 by Ryan G Conrad license: CPOL

Additional logging and data collection

T-SQL

SqlCommand to T-SQL Printer

22 Mar 2018 by Robert Vandenberg Huang license: CPOL

An Entity Framework log printer that converts SQL commands to executable T-SQL statement

HTML

T-SQL

VS2013

Select Statement to HTML Table

2 Feb 2018 by Luca Astolfi license: CPOL

User defined procedure for make an HTML table from T-SQL Select statment

, +

The ETL Process and Range Lookups

3 Jan 2018 by Member 11127135 license: CPOL

The ETL Process and Range Lookups

T-SQL

Generate Insert Scripts of Existing Rows with "if Exists" Conditions

11 Dec 2017 by Chetan Naithani license: CPOL

Stored Procedure to Generate Insert Scripts

T-SQL

DimDate Revisited (The Power of a View and Nested Whiles)

10 Dec 2017 by Steven L. Wentworth (12896862) license: CPOL

Straightforward generation of and ensuring accuracy for DimDate values.

T-SQL

Pay Attention to What "Script...To" Generates

22 Sep 2017 by #realJSOP license: CPOL

It doesn't always happen the way you expect.

T-SQL

SQL Coding Productivity in Visual Studio Enterprise with SQL Prompt Core

22 Sep 2017 by Redgate Software license: CPOL

If you could gain an extra hour in your working day, what would you spend it on? One way to save time and work efficiently, is to use tools available at your fingertips. Learn how SQL Prompt Core, included free in Visual Studio Enterprise, helps you speed up working with SQL and be more productive.

Third Party Products » Product Showcase » General

T-SQL

Mission Impossible: Migrating .NET Core 1.x to 2.0

19 Aug 2017 by Afzaal Ahmad Zeeshan license: CPOL

.NET Core 2.0 brings a lot of improvements to the system, and it brings a lot of pain to the developers as well. I had a lot of problems upgrading .NET Core 1.x apps to .NET Core 2.0; I yet have to feel the promise it makes about performance and so, but let us see how to upgrade our existing applica

Platforms, Frameworks & Libraries » .net Framework » How to

T-SQL

Are Using Bitwise Operators for Table Joins Really Taboo?

26 Jul 2017 by Ed Wiebe license: CPOL

Can't we obtain the benefit of using bitwise operators for SQL many-to-many relationships AND maintain referential integrity?

, +

Combination of Id-ParentId and HierarchyId Approaches to Hierarchical Data

17 Jul 2017 by Vadim Loboda license: CPOL

How to combine the Id-ParentId and HierarchyId approaches to keep and fetch the data in hierarchical and alphabetical order.

T-SQL

FOR XML Basics (RAW Mode): 1 of 4

2 Jun 2017 by AhsanAhmed license: CPOL

A brief introduction on how to use FOR XML clause in RAW mode in MS SQL Server to return data in XML format

T-SQL

, +

FOR XML Basics (AUTO Mode): 2 of 4

2 Jun 2017 by AhsanAhmed license: CPOL

A brief introduction on how to use FOR XML clause in AUTO mode in Microsoft SQL Server to return data in XML format

T-SQL

, +

FOR XML Basics (EXPLICIT Mode): 3 of 4

1 Jun 2017 by AhsanAhmed license: CPOL

A brief introduction on how to use FOR XML clause in EXPLICIT mode in Microsoft SQL Server to return data in XML format

T-SQL

, +

Angular2 & WebApi (SPA) for Enterprise App - Part 8 - Build & Deploy Application

29 May 2017 by tranthanhtu.vn license: CPOL

In this article, we will learn how to build and deploy the code

Web Development » Applications & Tools » Applications

, +

Angular2 & WebApi (SPA) for Enterprise App - Part 7 - Manage Application Lifecycle

29 May 2017 by tranthanhtu.vn license: CPOL

In this article, We will learn why do we need to manage the stages of our application.

Web Development » Applications & Tools » Applications

, +

Capture of a Typical SQL Server Database Workload

29 May 2017 by Tomáš Bauer license: CPOL

Capture of a Typical SQL Server Database Workload

Database » Sql Reporting Services » General

T-SQL

, +

SqlDependency .NET library can work to detect updates automatically

24 May 2017 by Zahid Nawaz Ch. license: CPOL

SqlDependency ,can be used to pick changes without executing query to see there is any update from database , WHERE CLAUSE can also be applied for narrowing scope, Its way to push changes from SQL Server to SQLDependency , .NET library , SQL Server Broker service sends updates to SQLDependency.

Languages » C# » Applications

, +

R-script Migration to SQL Server 2016

13 May 2017 by Evgeniy Sukhikh license: CPOL

Issues and solutions taken while moving R from cmd to sp_execute_external_script

ODBC

T-SQL

LINQ to Entities, Cross Apply, and Left Outer Join

12 May 2017 by DaveDavidson license: CPOL

In this article, I show LINQ to Entities syntax that will produce queries with CROSS APPLY and LEFT OUTER JOIN clauses.

Platforms, Frameworks & Libraries » Linq » General

T-SQL

, +

Call a Web Service using SSIS then Store and Query the Results

7 May 2017 by Michael Lockwood license: CPOL

This article illustrates how to call a web service using SQL Server Integration Services (SSIS), store the XML results in a SQL Server database table then query the XML using XQuery.

, +

Artisan Way of Data Reply

16 Apr 2017 by Vadim Loboda license: CPOL

A way to deliver more details about an error or exception from an SQL Server database through an ASP.NET web application to a web client.

Database » Database » Data Access

.NET

ADO.NET

T-SQL

SQL to ADO.NET API (Automated ADO.NET or DB API)

10 Apr 2017 by dmytro.sen license: Apache

SQL to ADO.NET API (Automated ADO.NET)

General Programming » Tools and Ide » General

.NET

ADO.NET

API

T-SQL

Introducing SQL Clone

10 Mar 2017 by Redgate Software license: CPOL

SQL Clone exploits the existing virtualization technology within Windows to take much of the sting out of the traditional problems surrounding database provisioning.

Third Party Products » Product Showcase » General