Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Everything / Languages / SQL

SQL

SQL

Great Reads

by Nirosh
This tutorial is designed for .NET programmers who need to understand ‘Nido’ framework and its application.
by Akhil Mittal
Repository pattern in MVC3 application with entity framework
by Paul Rony
Programmer's Guide to Starting a Software Company and Building an Enterprise Application
by Rick Bassham
How to use the SqlChangeMonitor with the new MemoryCache class in .NET 4.0.

Latest Articles

by Nirosh
This tutorial is designed for .NET programmers who need to understand ‘Nido’ framework and its application.
by Akhil Mittal
Repository pattern in MVC3 application with entity framework
by Paul Rony
Programmer's Guide to Starting a Software Company and Building an Enterprise Application
by Rick Bassham
How to use the SqlChangeMonitor with the new MemoryCache class in .NET 4.0.

All Articles

Sort by Score

SQL 

by Rick Bassham
How to use the SqlChangeMonitor with the new MemoryCache class in .NET 4.0.
by Lee P Richardson
This blog post lists 3 days to refactor EF Linq queries without killing Perf
by Jin Vincent Necesario
This article shows you the basics of SQL Schema using the DDL statements.
by Arctype SQL
Universally Unique IDs (UUIDs) use random numbers to create unique IDs. UUIDs use more storage, but they provide a good solution for distributed databases and security.
by Aram Tchekrekjian
In this tutorial, we will learn how to connect Android with ASP.NET Core Web API.
by Sander Rossel
Getting your feet wet in NoSQL with MongoDB!
by Raymund Macaalay
Here is a good use for SQL OUTER APPLY
by Rajat-Indiandotnet
As a product owner, you always worried about the different security aspects of your application and SQL Server Database is one of the main important parts for which you might worry.
by derekman9707
A SQL Cmdlet a Day 2 Piping and Select
by Rion Williams
How to access SQL from Entity Framework Code Queries in ASP.NET core
by Amogh Natu
This post shows how to insert a comma-separated string into multiple rows in a table in SQL Server.
by mazhou
Ad-hoc pagination support with SQL Server codenamed “Denali”
by Arun Ramachandran India
ADO.NET - What is meant by SQL injection attack?
by derekman9707
This post discusses about variable value assignment in SSIS.
by Manjuke Fernando
Always encrypted feature in SQL Server 2016
by Noor Ahmad Feroozi
An attempt was made to load a program with an incorrect format sqlite
by Rion Williams
Some recommended readings about streaming systems
by Bikash Shaw
An Introduction to Bitronix JTA Transaction Manager with MySQL
by essentialSQL
In this article we’ve collected all the essential information about writing SQL queries into one ultimate guide to help you gain and practice this knowledge more effectively.
by Mel Padden
A script that analyzes the text of each individual object and builds a tree of what depends on what.
by Manjuke Fernando
Analyzing SQL Server Error Logs / Agent Logs using T-SQL
by Arctype SQL
Explanation of how a query gets execution and understanding the EXPLAIN command
by DotNetLead.com
Angular/.NET Core Web API application that can be used as the starting point for building your applications.
by Pranay Rana
Here I am going to discuss about Any method.
by Aram Tchekrekjian
How to apply JWT Access Tokens and Refresh Tokens in ASP.NET Core Web API 6
by John Atten
Configuring ASP.NET MVC 4 membership with a SQL CE database.
by Tejas Vaishnav
Auto incremented ID using VARCHAR data type
by Steve Wellens
This is one of those tucked-away features in Visual Studio that, once you find it, can make you slap your forehead so hard that it hurts.
by Raymund Macaalay
How to automate Backups on SQL Server Express Version
by Andrew Zwicker
Why OR conditions in join statements should be avoided and an example fix
by Vivek Johari
Creating an Azure SQL Database Contents Introduction Creation of Azure SQL Database Step 1: Select Database Name Step 2: Select Azure Subscription Step 3: Choose Resource Group Step 4: Choose Database Source Step 5: Choose SQL Server Step 6: Choose Elastic Pool Option Step 7: Choose Service Tier for
by Sarmaad Amin
Often a service is required to connect to a database to perform some operations. In this post, we are going to look at having an Azure Function connect and insert a record in database table. We will showcase the usage on nuget packages and usage in Azure Function to automate package management.
by Jeremy Hutchinson
Azure SQL vs AWS RDS - performance and cost
by Sebastian Solnica
In this post, I will show you an interesting problem that we experienced when querying a SQL Server database with Dapper.
by Manjuke Fernando
Behavior of IDENTITY Columns and SEQUENCES with TRANSACTIONS
by Ben Liebert
Best practice front-end architecture using Microsoft ASP.NET MVC and Rivet.js
by Ben Liebert
Best practice front-end architecture using Microsoft ASP.NET MVC and Rivets.js
by Vivek Johari
For any programming language, just writing the code is not well enough. It should be written using the best practices for getting optimise performance . In this article, I will explain the disadvantages of writing code without using Best Practices in SQL Coding.
by Sacha Barber
A while back I posted a blog post about a simple Circular Progress Bar that I did for WPF.
by PascalLandau
Debugging BigQuery usage
by jqwidgets
How to bind jqxGrid to SQL Database using ASP.NET MVC 3
by essentialSQL
How to build dynamic SQL in a stored procedure
by Sam_IN
In this article, I will explain step by step how to create Continuous Build and Release process for SQL Server Scripts for Database. All the steps are self explanatory with relevant screenshots.
by Paul S. Chapman
How to improve the creation of XML message requests using Reflection, XML and XSLT
by Sacha Barber
Bulk insert into SQL from C#
by kribo
This post aims to demostrate how to load images into a SQLite database and retrieve them for viewing.
by Rob Kraft
The benefit of this approach is that you can then regularly scan your entire code base for the use of .ExecuteReader and .ExecuteNonQuery knowing that there should be no cases of those methods, other than the exception cases you expect.
by John Bandela
C++20 provides us with improved compile time features that can allow us to get a working SQL query into C++.
by Sibeesh Passion
How to use caching in Web API
by essentialSQL
There are several ways to calculate a running total in SQL. In this article, we will cover two methods: Joins, and Window Functions.
by essentialSQL
A common question I get ask is whether I can have a CASE Statement in the WHERE Clause.
by Acharya Raja Sekhar
Capture SQL Server queries fired from your application
by Andrew Zwicker
An example of using a Cartesian [cross] join.
by Sebastian Solnica
A simple way to implement changelog system for database objects using NHibernate session interceptor and database triggers
by Ernest Poletaev
How to change database schema, add or delete a field or table, be sure that new version of application will work correctly and existing users will not lose their data
by skydger
Checking MS SQL Server database files default paths.
by Ivan Krivyakov
Christmas Carol: XML Signatures
by Kevin Mack
Some areas to focus on for Cloud Security
by Arctype SQL
Simple examples of collaborative filtering with fundamental logic behind all of these systems boiling down to same principles used here
by essentialSQL
Examples of common data types in SQL Server and how to define them
by Manjuke Fernando
Computed columns in SQL Server
by Dave C Andrews
Count the records in a table which are of a certain type.
by Illya Reznykov
The post describes how to use token-based authentication to run SQL queries against Azure SQL Database.
by Lee P Richardson
Description of two ways to use LINQPad with ABP apps to solve performance problems
by essentialSQL
Sooner or later, you want to know when a column contains in SQL another value.  In this article we’ll go over several ways you can test to see whether one value is contained within an another.
by Graham D Smith
Commissioning TFS or VSTS
by Graham D Smith
Continuous Delivery with VSO: Configuring the Basics
by Tom Janssens
Functional programming = SQL Select statement
by Raymund Macaalay
How to convert / Parse Delimited string column in SQL to Rows
by User 6619207
How to copy a table using SQL Server Management Objects
by essentialSQL
Comparison of a correlated sub query to a join
by Tharaka MTR
How to count consecutive dates using SQL
by Manjuke Fernando
Create a Cursor using dynamic SQL query.
by essentialSQL
In this episode of SQL Minute I want to share with you how to create a pivot or cross tab chart.
by Kevin Chadney
Creating a simple SSMS extension which accesses the query window and object browser.
by gmtzgtz
How to create and execute dynamic SQL on T-SQL.
by Gediminas Geigalas
Creating .In and .NotIn Extension methods for NHibernate 3 Linq provider
by essentialSQL
Introduction to cross join - create row combinations
by Cale Dunlap
Example of using code-based query generation, transposition, cross-tabulation, and normalized data to produce a query result that can feed a simple chart from data which was not originally designed with reporting or charting in mind.
by JasonDove
The basis of this solution is to control which fields are grouped on within the report, this will in turn change the summary operations and change the entire context of the report. This is done using Crystal Reports built-in Parameters in a way often overlooked by developers.
by Sibeesh Passion
How to create a custom deferred grid in MVC using Web API and Angular JS
by essentialSQL
How to do some basic data modeling
by Arctype SQL
As a business expands, the need to ethically leverage data is not a luxury anymore, but a necessity.
by Andrew Zwicker
A continuation of the data dictionary discussion with information about how the documentation is done
by essentialSQL
Database indexes explained
by Andrew Zwicker
Why table and column documentation is useful and some SQL for setting up the data dictionary tables
by Arctype SQL
When solving a problem that requires you to link a user's session data to their actual user object, Postgres comes in handy.
by Jeremy Likness
Some ah-hah moments about Kusto
by Camilo Reyes
Demystify LocalDB in ASP.NET with sqlcmd
by Arctype SQL
Easily deploy PostgreSQL pod in Kubernetes
by DotNetLead.com
Deploy existing ASP.NET Core UI, API, and SQL Server to Docker containers
by Brady Kelly
Making F5 execute your query
by Basavaraj P Biradar
Difference between SET QUOTED_IDENTIFIERS ON and OFF settings.
by Vivek Johari
Basic information about the different ways of creating a table
by Manjuke Fernando
DROP IF EXISTS in SQL Server 2016 (DIE)
by Raymund Macaalay
The easiest way to cancel all SharePoint workflows in progress
by Patrick Cunningham
This article uses 8 steps to create example of how to read and write from HTML to a SQL database in a .NET web application using jQuery, JSON, and XML.
by Raymund Macaalay
How to change collation of all database objects in SQL Server
by Sadeque Sharif
Easily trace all errors of Stored Procedures in MS SQL Server.
by Andrew Zwicker
A discussion of how joins significantly outperform subqueries and how this is more evident when OR conditions are involved.
by Martin Jarvis
SQL Script to clone a menu into multiple languages
by Manjuke Fernando
Error occurs when CTE Alias is ‘RESULT’ - Incorrect syntax near 'RESULT'. Succeeds on some SQL Server databases but fails on others.
by Passion4Code
This post covers everything about SQL - getting started
by Rajat-Indiandotnet
New feature in SQL Server 2016
by Raymund Macaalay
How to execute stored procedure in parallel
by Gordon Beeming
Simply run the script and then every time SQL is restarted, all your Identity columns will be reset to the latest available seed.
by Rajat-Indiandotnet
Find first not null value from different columns
by User 10072795
Finding similar rows in SQL
by Rajat-Indiandotnet
First_value & Last_Value according to group set is that easy? Tip# 44
by Manjuke Fernando
Fixed ~ Error Installing SQL 2008 Business Intelligence Studio and Related Features
by Minh Danh Nguyen (ToughDev)
Fix for 'Search fields undefined' error
by Minh Danh Nguyen (ToughDev)
How to fix ‘Search fields undefined’ error when generating source code for a Scriptcase gridview
by Andrew Zwicker
A discussion about a forum post for handling a running subtraction in a SQL query.
by Passion4Code
How to do full text search in SQL
by Raymund Macaalay
Function to clean fields in SQL
by mrcellux
FluentJdbc is a functional, fluent API to execute most common SQL operations an application needs as a single statement.
by Tharaka MTR
Generate insert statements from a specific table data using SQL Server
by Debopam Pal
This example shows how you can generate INSERT, UPDATE & DELETE SQL Query for Oracle DB.
by madan535
Get Empty or NULL Data Rows with available data between given date range in SQL Server
by essentialSQL
The purpose of this article is to introduce you to subqueries and some of their high-level concepts.  There are a lot of details to cover in order to learn sub queries, but you’ll see we cover those in depth in later articles.
by essentialSQL
This is the second in a series of articles about subqueries. In this article, we discuss subqueries in the SELECT statement’s column list. Other articles discuss their uses in other clauses.
by essentialSQL
How to use the Intersect Operator in SQL Server
by essentialSQL
In this lesson, you are going to explore how to do pattern matching with the SQL Where clause LIKE operator.
by essentialSQL
What is a Null Value? In databases a common issue is what value or placeholder do you use to represent a missing values.   In SQL, this is solved with null.  It is used to signify missing or unknown values.  The keyword NULL is used to indicate these values.
by essentialSQL
Introduction to Inner Joins in SQL Server
by essentialSQL
Introduction to Outer Joins in SQL Server
by essentialSQL
How to combine table rows using UNION in SQL Server
by essentialSQL
In today’s lesson, you’re going to learn how to filter the results returned from your queries using the WHERE clause.
by essentialSQL
Learn more about filtering results returned from your queries using the WHERE clause
by essentialSQL
Grouping results returned from your queries using the GROUP BY clause
by essentialSQL
Introduction to database joins in SQL
by essentialSQL
Database Second Normal Form explained in simple English
by essentialSQL
Database Third Normal Form explained in simple English
by essentialSQL
Query Results Using Pattern Matching in SQL
by essentialSQL
How to Group and Summarize your Results in SQL
by essentialSQL
Simplified Data Modeling in SQL
by essentialSQL
Database normalization in SQL explained in simple English
by essentialSQL
Database First Normal Form explained in simple English
by essentialSQL
How to use the Except Operator in SQLServer
by essentialSQL
In this guide, I’ll show you how to get started using Power BI.  We’ll then get some sample data and use it to build a simple project.
by JonB3232
Getting Started with NoSQL and MongoDB
by essentialSQL
Simple SELECT queries in SQL Server
by essentialSQL
How to sort your query results in SQL Server
by Rajat-Indiandotnet
Good to know SQL jargon
by MBigglesworth79
Quoted identifiers appear to be causing more problems and confusion than they are worth; not least the potential creation of "duplicate" column names.
by Sam Varadarajan
"BEGIN" keyword in Oracle.
by Sam Varadarajan
Apparently, passwords are case sensitive in Oracle 11g by default. This can be overridden.
by Shameel
This article describes a simple and elegant way to allow write access to ASP.NET apps to the App_Data folder. This is required for applications to work properly when deployed in AWS Beanstalk.. The post Granting write access to ASP.
by Raymund Macaalay
How to create dynamic LINQ queries.
by Kevin Mack
A blog about availability in the cloud and how to build applications that are architected for resiliency.
by essentialSQL
How to find duplicate values in SQL Server
by essentialSQL
How to combine results from more than one table
by essentialSQL
An answer to fix an error converting data type from varchar to float
by essentialSQL
Sort Alphanumeric Values with SQL Server
by essentialSQL
In this video, we'll walk you through how to use the LIKE clause.
by essentialSQL
How do the SQL DISTINCT and TOP SELECT Clauses Work Together to Generate Results?
by essentialSQL
How to calculate the end of the month in SQL
by Arctype SQL
Write your query in a way to overcome the limitations of NULL rather than avoid using it.
by zidane168
Use SQL triggers to keep track of the changes made to your data
by Vivek Johari
Performance tuning of a complex SQL query involves understanding its execution flow, optimizing query structure, and improving database interactions. In this article, I will discuss the approach which can be helpful for performance tuning of a complex SQL query.
by Libish Varghese Jacob
Configuring and using Entity Framework 4.1 for my Open Source project.
by Lee P Richardson
Deploy EF database migrations while avoiding security flags
by essentialSQL
Use STRING_SPLIT() to join two tables
by Nitesh Kejriwal
How to do case sensitive string match in SQL Server
by Rajat-Indiandotnet
Step by step merge join transformations
by Vivek Johari
This article will try to show how to find duplicate values in a table.
by Rohitmssqlfun
Finding the top most expensive cached queries
by Tharaka MTR
This post will show you how to fix orphaned SQL users.
by Manjuke Fernando
This post will show you how to insert data using SQL views created using multiple tables.
by HeWillem
How to instantiate derived LINQ to SQL entities
by Dave C Andrews
How to join multiple columns with Linq to SQL
by essentialSQL
I recently put together a lesson on  table aliases and multi-table joins.  It is part of my Join Together Now course.  Click here get the course at a discount.
by Kevin Mack
When storing data in Azure blob storage, the process of upload a blob is fairly straight forward, and all it takes is setting the access tier to “Archive” to move data to blob storage.
by Nadeem Afana
Illustrates an efficient method of returning random rows from a SQL Server database
by Ghanshyam N Patel
How to shrink SQL Server database log file
by Shahriar Iqbal Chowdhury/Galib
This post shows you how to solve SSIS Error Code 0xC020801C/0xC004700C/0xC0047017
by rusanu
A technique to make tables with columnstore indexes updateable
by rusanu
A very simplified explanation of how column store indexes can be used
by Dave C Andrews
You can have your tables make computations themselves, without running through a view.
by Dave C Andrews
Use ROW_NUMBER() to enumerate and partition records in SQL Server
by tanmoysarkar
How to use SMTP Port and Custom Pipeline Component to send Formatted Email Messages to concerned users
by essentialSQL
How to write a SQL UNION without using Set operations
by essentialSQL
In this video and the following article, we’ll take you step-by-step through the process of changing a query’s filter criteria into a SQL variable, then ultimately into a stored procedure.
by Manjuke Fernando
Using Update Cursors in SQL Server
by essentialSQL
Three simple steps to writing SQL queries
by essentialSQL
How to Write SQL – Understand Database Table Meanings and Relationships – Step 1
by ozkary
HTML5 Web Database and Mobile Web Applications
by Rion Williams
Tools to test security, a plan on how to secure your system and building good habits to help ensure you stay protected
by Vivek Johari
Identity property in SQL Server
by Pranay Rana
How to increase Linq query performance by compiling it
by Duy H. Thai
Explore the essence of an 'LTS classes' file, the classes it generates, and how it connects the object model to the database model...
by John Atten
Installing and configuring PostgreSQL on a Linux box is either simple, because you are a Linux and/or Postgres expert, or not so simple, because you are new(er) to Linux, Postgres, or both. Over the past year, I have resided firmly in the latter camp.
by John Atten
How to install and use SQLite on Windows
by Melick
Insufficient SQL Database Permissions for User 'Name: doman\SP_UserProfiles SID:
by Vivek Johari
Through this article, we are going to discuss three important interview questions of SQL
by essentialSQL
Introduction to Common Table Expressions
by Keyhole Software
Introduction to MonoTouch Library sqlite-net
by Nikola M. Živković
Introduction to NoSQL and Polyglot Persistence
by Vivek Johari
Introduction to SQL Server Views
by essentialSQL
Introduction to SQL Server's built-in conversion functions
by essentialSQL
Introduction to SQL Server’s Common String Functions
by essentialSQL
Introduction to SQL Server’s Mathematical Functions
by Manjuke Fernando
Briefly describing the features in SQL Server Data Tools.
by essentialSQL
Here is an introduction to the Delete statement
by essentialSQL
In this article, well explore how to use the MERGE statement. We discuss some best practices, limitations, and wrap-up with several examples.
by essentialSQL
An introduction to the UPDATE statement
by Sibeesh Passion
Introduction to Web SQL
by Andrew Zwicker
Do you find yourself or others doing repetitive tasks? The solution – automate if possible.
by derekman9707
Pseudo-simple recovery model
by Kunal Chowdhury «IN»
Join Hint in SQL - Guest post by Joydeep Das
by essentialSQL
Joins versus subqueries in SQL
by essentialSQL
Puzzle to teach joins vs subqueries in SQL
by Sibeesh Passion
In this article, we will learn how we can work with jQuery Datatables with server side data.
by Kevin Mack
Hello all, It’s been a while since I did a blog post outside of the weekly updates. But I wanted to do one in terms of conversations that I’ve been having a lot lately and seems to be largely universal. High Availability.
by essentialSQL
In this blog post, you will learn about stored procedures
by Dave Kerr
If you are looking to get your hands dirty and learn all about Docker, then look no further!
by essentialSQL
In this puzzle, we’re going to learn how to find the person whose birthday, among others, is in the middle.
by essentialSQL
How to join dirty data using SQL Server
by essentialSQL
How to use SQL Server Date functions
by essentialSQL
In this puzzle, we’re going to learn how to query the data dictionary using SQL Server.
by essentialSQL
In this blog entry we discuss the difference between left join versus right join operators.
by Wendelius
This post discusses about how to add checks into a SQL statement in order to prevent wrong results in case of possible future changes.
by JasonShort
A few common SQL query patterns, and their Linq to Entities (EF) equivalents
by Raymund Macaalay
LINQ to SQL Essentials
by Kristofer Kallsbo
Trying to join two tables that have a 1 to many relationship with LINQ to SQL
by Kristofer Kallsbo
Updating several rows using LINQ to SQL.
by Vlad Neculai Vizitiu
Some LiteDB use cases
by Sibeesh Passion
How to load an XML file and show as li using ng-repeat in Angular JS
by Kevin Mack
A few disk queries for log analytics
by Jameson Triplett
Log4j2.xml Tweaks
by Gediminas Geigalas
Logging NHibernate queries with parameters
by Jeremy Likness
Learn how to parse complex expression trees, and even modify them to alter IQueryable results.
by Piusn
Management Studio for Mongodb, -Mongodb Part 3
by Sifiso W Ndlovu
Master Data Services Insufficient Memory Error
by Vivek Johari
This article explain key concepts and best practices related to NULL value in SQL which help in mastering the NULL value in SQL Server.. The post Mastering NULL value in SQL Server appeared first on Technology with Vivek Johari..
by m_kramar
What if you have a collection of objects and want to find matches in database and you want to do it using just one query? The following example demonstrates how it can be done using LINQ.
by Sander Rossel
Using Venn diagrams to visualize sets.
by Raymund Macaalay
Median Calculation using TSQL (no cursors)
by Nitin Singh India
Merge data in SQL Server.
by Basavaraj P Biradar
The new Merge statement in SQL Server 2008.
by Trần_Tuấn_Anh
SQL Injection (SQLi) is a serious security vulnerability that allows attackers to execute arbitrary SQL code on a database. This can lead to unauthorized access, data breaches, and even complete system compromise.
by Steve Wellens
I haven't been impressed by any new technology in a long time…until I downloaded and tried out the new Microsoft Chart Controls for the .Net Framework. It contains charts for both Forms and Asp.Net applications.
by Kelum W. Ganegoda
Microsoft SQL Server Backups & Restore: Steps Explained
by Vivek Johari
Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool Contents Introduction Microsoft Database Migration Assistant (DMA) tool Migrate SQL Server database To Azure SQL Instance using DMA tool Detecting the compatibility issues using Assessment Type
by Shameel
This multi-part article series discuss migrating your databases, applications and services from SQL Server to PostgreSQL and discusses all the important information you need to be aware of, before beginning a migration project..
by Shameel
Part 2 of this multi-part article series compares SQL Server and PostgreSQL article, database structure, language differences, data type mappings, functions and operators and other important considerations for migration..
by Shameel
Part 3 of this multi-part article series discusses the actual migration process: Schema and data migration, ETL/ELT, Reporting & OLAP, Scheduling and Applications & Services migration.. The post Migrating your SQL Server Workloads to PostgreSQL – Part 3 appeared first on The Developer Space..
by Shameel
Part 4 of this multi-part article series discusses Maintenance and Monitoring, High Availability, Load Balancing, and Replication and Environment Stabilization.. The post Migrating your SQL Server Workloads to PostgreSQL – Part 4 appeared first on The Developer Space..
by Eric Xue (brokensnow)
Missing Server side dependencies - Problems and Solutions
by Mahmudul Haque Azad
A simple trick to add to custom node to the XML commenting.in GhostDoc
by Suvendu Shekhar Giri
Sort the result set as per your need
by Jamie Munro
MySQL: insert or update in one SQL statement
by Arctype SQL
In this article, you'll learn about Postgres UUIDs and how to generate them with examples from two different modules.
by Andrei Ion Rînea
Simpler paging, sequences and FileTables in SQL Server 2012
by Sebastian Solnica
NLog LayoutRenderer for Assembly Version
by Tim Golisch
The Master database often seems to be the "Lost & Found" bin of the SQL Server world. There are two popular ways for preventing this kind of problem. Read on...
by essentialSQL
In this article, we explore non recursive CTEs (Common Table Expressions). This is a broad class, and basically covers every form of CTEs except those that call themselves. This other class is called the recursive CTEs; they are covered in the next article.
by rusanu
Adding a new non-NULLable column with default values to an existing table in SQL Server 11
by Tharaka MTR
Some online tools for troubleshooting web, SQL, XML and JSON
by Sam Varadarajan
Oracle SQL*Plus - Forward slash contd... (PL/SQL)
by Sam Varadarajan
Forward Slash contd…
by Sam Varadarajan
Oracle SQL*PLUS: How to silence SQL*Plus
by Sam Varadarajan
Commit and forward slash in Oracle
by Sam Varadarajan
Oracle - Forward slash in SQL&Plus - Take 2
by essentialSQL
In this blog entry we do an overview of the order if execution in SQL.
by Andrei Ion Rînea
OUTPUT clause in UPDATE statements
by Tharaka MTR
Pad numbers with leading and ending zeros
by Petru Faurescu
Best way, performance wise, to paginate results in MongoDB
by Steve Naidamast
This is a poor man's hierarchy data tree solution in SQL
by Arctype SQL
Using pg_notify in Postgres alongside the NOTIFY and LISTEN syntax is all that's needed to build a real time updating dashboard
by Shameel
This article walks you through the summary of most important new features. enhancements and breaking changes in PostgreSQL 12.. The post PostgreSQL 12: New Features and Enhancements appeared first on The Developer Space..
by Shameel
This article describes the new Stored Procedure feature in PostgreSQL 11.5 and shows you how it differs from Functions.. The post PostgreSQL finally gets Stored Procedures appeared first on The Developer Space..
by Ivan Korhner
Postgresql: PostgreSQL Query Tuning - Indices
by nirman b doshi
Powershell Scripts to replace "setvar" variable in SQL-CMD script file before running the SQL scripts
by nirman b doshi
Powershell Scripts to replace Key Value pair in SQL Script file before running the SQL Scripts
by Sacha Barber
Powershell selecting from SQL Server
by Andrew Zwicker
How to prevent duplicates in the data
by Bob McGowan
Processing SQL Server FILESTREAM Data - Part 1
by Bob McGowan
Utilizing SQL Server FILESTREAM capabilities from .NET
by Mohammad Elsheimy
Programmatically Enumerating, Attaching, and Detaching SQL Server Databases via SQL statements and stored procedures
by Charles Boyung
How to program for date ranges
by johnniealan
This article describes about adding progress bar in cell.
by Reader Man San
The Need I needed to add the possibility for upper layers like the Model/Service to make projection on Linq to SQL statements but without leaking IQueryable. As the normal Linq to SQL projection is: var query = from c in Cars … Continue reading →
by Reader Man San
Projecting on Linq to SQL, from different layers
by Vincent Maverick Durano
Protect your data: Prevent SQL injection
by essentialSQL
Query plans in SQL
by Sam Varadarajan
Quick Tip – Oracle SQL*Plus: HTML Output
by Sam Varadarajan
How to exit from SQL&Plus on command line
by Sam Varadarajan
(IF) Check for parameters to script.
by Ivan Krivyakov
Random notes on MDX filtering
by Andrei Ion Rînea
Some performance tips
by Jeremy Hutchinson
Update table rows with varying random values in SQL
by essentialSQL
How to identify the top and bottom 25 percent to rank student scores
by Pranay Rana
Understanding Descendants and avoiding misconception with this method
by Raymund Macaalay
Repairing Suspect SQL Database
by Manjuke Fernando
How to repeat a SQL row based on a value in a different column
by Andrew Zwicker
How to replace cursors with set-based SQL queries - Part 1
by Andrew Zwicker
This is part 2 of a discussion about replacing cursors with SQL statements for significant speed improvements.
by jgauffin
Griffin DAL Generator – Take 2
by Kevin Mack
Cost projections and figuring out gross margin in cloud computing
by Sifiso W Ndlovu
How to resolve PolyBase Installation errors in SQL Server 2016
by Bryan O'Connell
Review of the ebook: Brad's Sure Guide to SQL Server Maintenance Plans.
by Raymund Macaalay
Restricting Access to Database by Application Name and/or Host Name in SQL Server
by essentialSQL
How to select top rows within a query
by essentialSQL
How to select top rows within a query
by Gil Fink
Revisiting XML Configurations In Unity In the past I wrote a few tutorials about Unity application block. One of the things I wrote about was how to configure a Unity container using design time configuration.
by essentialSQL
How to rewrite a subquery as a join
by Steve Maier
The same database and the same RIA Services can be used as a Web Service by using some simple additions to the setup of your project.
by Craig Pickles
Row-Level Security in Azure SQL with entity framework
by Kevin Mack
Hello all, in keeping with the last post on the blog, I started doing some posts around High Availability, so ultimately the focus here is how do I architect my solution to ensure that is meets the availability demands of my customers.
by Debopam Pal
How to run SQL script containing DDL, DML, Select statements and PL/SQL block through reader in Java
by gmtzgtz
How to write a LINQ statement with multiple joins
by Manjuke Fernando
How to save an image to a SQL Server table
by outcoldman
Schedule a daily backup with SQL Server Express
by Mel Padden
From a utility I'm working on. Compatible with SQL-92 INFORMATION_SCHEMA views.
by Vivek Johari
This article explained about measures for securing data in SQL Server at various levels to protect data from unauthorized access and breaches.. The post Securing data in SQL Server appeared first on Technology with Vivek Johari..
by MBigglesworth79
XML Serialization
by Steve Wellens
In an earlier post here, I wrote two functions to Serialize and Deserialize objects to XML strings. Since then, while reading a book about XML, I learned of even more power in the .NET XML Serialization libraries*...
by Keyhole Software
Seriate: The Glue Between SQL Server and Node.js
by Eric Xue (brokensnow)
Extracting the entire UserProfile AD user details into a CSV file
by Manas Bhardwaj
This post is intended to be used as a hack for developers to release some disk space. Please do not use on actual production environments.
by S Ravi Kumar (TechieRathore)
Simple POCO N SQL Generator in C#
by Raymund Macaalay
Singularize Function in TSQL
by Rion Williams
In my previous post, I discussed the use of TransactionScope within C# and how it might simplify how transactions are managed within your applications.
by Rion Williams
Smooth transactions with TransactionScope
by Shahriar Iqbal Chowdhury/Galib
Solution to the MSSQL Server “Suspect”
by Nitesh Kejriwal
Solution to a very common problem that we face while working with SQL
by Dinesh K Mandal
Some Hidden Facts about Stored Procedure and Its Optimization
by Tharaka MTR
Some SQL Server Query tricks
by PeteBarber
Specifying the directory to create SQL CE databases when using Entity Framework
by m_kramar
How to split Oracle CLOB into lines - fast way
by essentialSQL
SQL ACID explained
by essentialSQL
Puzzle to explore a SQL BOM example
by Arkadeep De
SQL bulk copy from DataTable using XML
by essentialSQL
SQL COALESCE Function and NULL
by essentialSQL
SQL COALESCE function and how you can test for null, and when present, substitute it for another value
by essentialSQL
Learn about implicit data conversion and explicit type conversions with CAST AND CONVERT
by essentialSQL
In this article we’re going to cover the seven data types you’ll most frequently encounter in your everyday use of SQL.
by essentialSQL
In this blog entry we do an overview of the SQL DATEDIFF function
by essentialSQL
SQL DISTINCT Clause For SQL Server
by snorkie
This post is designed to help you understand how to use the EXISTS keyword in your SQL query environment.
by Anton Burtsev
The article shows how one can use Microsoft SQL Server to generate millions of guids in seconds.
by Keyhole Software
“SQL? Isn’t that just something my ORM tools use?” Often application developers can and should remain at least one level removed from SQL. JPA and the Entity Framework each provide more abstract (and OO-friendly) query languages, and it’s often unnecessary to write any queries at all.
by essentialSQL
In this article we look at SQL FULL JOIN examples and make a few notes of things to look for.
by essentialSQL
Understanding SQL full outer join and its reconstruction through other join clauses
by essentialSQL
How to use SQL GROUP BY Clause is to consolidate like values into a single row
by Andrew Zwicker
A discussion about SQL joins and subqueries with information about how to format join statements properly
by Gaurav Aroraa
SQL Like Functionality in LINQ?
by essentialSQL
How to calculate moving averages
by essentialSQL
How to identify the top and bottom 25 percent to rank student scores
by essentialSQL
In this puzzle, we’re going to learn how to calculate moving averages by working through a hypothetical stock market example. Solving puzzles is a great way to learn SQL.  Nothing beats practicing what you’ve learned.
by essentialSQL
How to calculate moving averages by working through a hypothetical stock market example
by essentialSQL
How to identify the top and bottom 25 percent to rank student scores
by Andrew Zwicker
SQL Query run time estimation
by Passion4Code
SQL scheduled jobs
by Vivek Johari
Stored Procedure in SQL Server can be defined as the set of logically group of SQL statement which are grouped to perform a specific task. This article will describe the Stored Procedure in SQL Server and their benefits.
by Arun Ramachandran India
How to write stored procedures with output parameters in SQL Server
by pinaldave
Primary Key and non-clustered index in simple words
by pinaldave
SQL Server – Puzzle – Statistics are not Updated but are Created Once
by pinaldave
SQL Server - SmallDateTime and Precision - a continuous confusion
by pinaldave
Tips from the SQL Joes 2 Pros Development Series – Efficient Query Writing Strategy
by pinaldave
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series
by pinaldave
Tips from the SQL Joes 2 Pros Development Series – System and Time Data Types
by Nuno M. F. Gomes
I'm not an every day SQL Server user but I use SQL Server regularly since 7.0 version until the 2005 version (not yet tried 2008 in a serious way) and from time to time I still find some nice hidden gems.A few days ago I needed to created a cleanup script for an application and one of the t
by Arun Ramachandran India
What exactly is COALESCE function in SQL Server?
by Martin Thwaites
Finding and removing indexes in SQL Server is an excellent way to remove bottlenecks, especially if you've "inherited" the application.
by Sifiso W Ndlovu
SQL Server exercise for data warehouse candidates
by essentialSQL
SQL Server Hierarchical Query using the hierarchyid type
by Markus Greuel
Some tips for developers who have to deal with a slow SQL server.
by aasim abdullah
How local variables can reduce query performance in SQL Server
by aasim abdullah
To find out whose birthday is coming in a given number of days is very simple.
by aasim abdullah
A simple way to swap column values.
by aasim abdullah
Why we should avoid the NOLOCK table Hint in DELETE/UPDATE queries.
by Rob Kraft
SQL Server’s sp_executesql does not protect you from SQL Injection
by essentialSQL
Truncate and Delete in SQL
by Ronnie Mukherjee
SQL Unit testing
by essentialSQL
The purpose of this article is to introduce you to SQL window functions and some of the high-level concepts.
by Anton Burtsev
If you want your database to be fast with a huge amount of data, you should test it with large test database.
by Martin Jarvis
Cleaning up after the database tuning engine advisor in SQL
by Himanshu DS
SQL: Target a SubQuery
by zenwalker1985
SqlConnection.Dispose internals
by rusanu
SqlDependency based caching of LINQ Queries
by derekman9707
SSIS - Do I Union All or Merge?
by Anton Angelov
Tutorial on how to set up an email subscription for reports generated in SSRS (SQL Server Reporting Services). Step by step explanations with a lot of images.
by My Tech World
It is recommended that stored procedures shouldn't be prefixed with sp_ for two simple reasons.
by Sibeesh Passion
In this post, we will see how to use common table expression or CTE in our SQL Server.
by PRANAV SINGH
Stored Procedure with sorting, paging, and filtering
by Gediminas Geigalas
This article reviews how my opinion on Stored Procedures changed over time and what disadvantages they bring into your application.
by loki2302
In T-SQL it’s just impossible to access multiple result sets if stored procedure returns them.
by Srinivasu Pemma
Stored procedures best practices
by Omar Al Zabir
Storing ASP.NET session outside webserver - SQL Server vs Redis vs Couchbase
by Manjuke Fernando
Strange behaviour converting NVARCHAR(MAX) to BINARY
by Wendelius
System.IO.Packaging namespace in WindowsBase may cause problems when trying to create a CLR procedure.
by ferventcoder
Script for reducing the size of a database
by Anton Angelov
Tutorial how to create test cases statistics for the automation status and their distribution by priority. Steps how to setup SSRS and TFS Data Warehose.
by Rion Williams
Bug stories: Exposition, action, climax, resolution, or epic failures.
by Melick
How to copy your production SharePoint database to development environment
by Keyhole Software
With the Criteria API, the effort to support a wide range of query-building operations is within reason.
by Sam Meacham
So what’s wrong with EF’s TPT inheritance? The SQL that EF generates. With some simple testing (2 or 3 subclasses) everything may appear to be fine. In fact, you may even be impressed that EF manages to fetch all the data you need in a single trip, indeed, in a single query.
by Rohitmssqlfun
EXECUTE permission was denied on the Object ‘sp_start_job’, database ‘msdb’, schema ‘dbo’
by Trần_Tuấn_Anh
A series of my experiences and mistakes in working with databases up until now.
by Gordon Beeming
They said Select * was bad but...
by Leland Richardson
Several little-known SQL tricks/techniques used to improve query times and enforce business rules with common everyday web-development scenarios
by Bryan Thomas Weikel
CodeProject"LEK" is a three-tier .NET WinForms accounting application that can be configured at run time to use either LINQ to SQL, Entity Framework or NHibernate to access data in either a "main" or "testing" SQL Server database.
by essentialSQL
Top five performance tips for Stored Procedures
by essentialSQL
How to use the TOP clause in SQL
by Alvin Bunk
How to troubleshoot SQL code using comments
by Shahriar Iqbal Chowdhury/Galib
A custom function that will hunt down HTML tags and remove them
by Shahriar Iqbal Chowdhury/Galib
TSQL Recursive Split function
by Shahriar Iqbal Chowdhury/Galib
TSQL split a string by delimiter
by outcoldman
TSQL: Passing array/list/set to stored procedure (Microsoft SQL Server)
by Rohitmssqlfun
Under which user does your SQL Agent job run: SQL Agent service account or SQL Agent job owner?
by Vivek Johari
In SQL Server, Change Data Capture (CDC) is a powerful feature that tracks changes (inserts, updates, and deletes) made to. The post Understanding CDC in SQL Server appeared first on Technology with Vivek Johari..
by Manjuke Fernando
It's very important to know what sort of JOINs are available in SQL Server and where exactly we can use them, in order to produce accurate results.
by Gaston Verelst
Unit testing your repositories - the code
by Kelum W. Ganegoda
This post demonstrates how to create an update progress with the UpdatePanel, similar to the one we can see in GMail.
by DiscoverSQL
Using @@Error within a transaction.
by essentialSQL
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.
by John Atten
How to use JSON type and aggregate functions to map relational data to JSON
by essentialSQL
In this puzzle, we’re going to learn how to create a cross tab query using SQL Server.
by essentialSQL
How to calculate the median value using SQL
by Raymund Macaalay
If you want an easy way of viewing objects in Active Directory, one good way of doing it is creating a view or stored procedure on SQL Server.
by essentialSQL
In this puzzle, we’re going to learn how to work with the AdventureWorks Bill of Materials table.  Companies use a BOM (Bill of Materials) to itemize the products that are used or contained in another product. Solving puzzles is a great way to learn SQL.
by Sander Rossel
Using C# to get data in- and out of your (relational) database
by Thomas Cooper
Using Case to convert Date format in SQL Select
by Manjuke Fernando
Using CLR functions with T-SQL
by essentialSQL
How to use conditional logic in SQL with CASE expression
by Gil Fink
Using Conditional Mapping in Entity Framework when we want to retrieve only a portion of data from a table in the database permanently by some filter.
by Arctype SQL
Learn how to write a MySQL cursor or a MySQL loop
by OwenDavies
This post outlines how to use Docker image for local SQL Server development.
by JammoD87
Using Dynamic SQL to create a Pivot Table
by Joe Rattz
Using LINQ to filter by object type and then quantify.
by Bryan O'Connell
Using LINQ to SQL for ETL projects.
by Alvin Bunk
How to use Oracle SQL Developer to connect to MySQL/Mariadb databases
by eric hexter
How to use SQL Compact for Integration Tests with Entity Framework
by Manjuke Fernando
How to use the new MERGE statement feature in SQL Server 2008
by Andrew Zwicker
A discussion of how views give a more denormalized means for querying against normalized tables.
by atverma
Utility to Generate Word Documents from Templates Using Visual Studio 2010 and Open XML 2.0 SDK - Part 4
by Eduardo Fonseca
Video Games Statistics Using Web API 2 and SQL Server Reporting Services
by M Sheik Uduman Ali
WCF Claims, STS and Federation – Layman’s View
by Sky Sanders
A strategy for implementing maintaining separation of concerns and implementation hiding.
by Sibeesh Passion
Web API With HttpClient Or Consume Web API From Console Application
by Kevin Mack
What kinds of things should I avoid, or remove from my applications to improve my position moving forward
by derekman9707
Different types of database backups
by essentialSQL
This post discusses the major parts of a SQL database
by User 6619207
About SQL Server Management Objects
by essentialSQL
Learn about a database cursor with an example and when to use it in a SP
by essentialSQL
What is a database table?
by essentialSQL
What is a Database Trigger?
by essentialSQL
In this puzzle, we’re going to learn how to create a dynamic pivot table using SQL Server.
by essentialSQL
I recently put together a lesson on non-equi joins.  It is part of my Join Together Now course.  Click here get the course at a discount.  A non-equi join can be used to solve some interesting query problems.
by essentialSQL
What is a Data Dictionary in SQL Server?
by essentialSQL
SQLite3 is a compact free database you can use easily to create and use a database. Learn more about it in this blog post.
by essentialSQL
In this puzzle, we’re going to learn how to rewrite a subquery using inner joins.
by essentialSQL
Difference between Cast and Convert
by essentialSQL
What is the difference between GROUP BY and ORDER BY
by essentialSQL
Difference between inner and outer joins
by essentialSQL
This post discusses the difference between merge and update
by essentialSQL
Difference between WHERE and HAVING clauses
by Keyhole Software
It turns out that WITH can be pretty useful in the right situations, simplifying code and providing a more efficient way to access subqueries and temporary table structures.
by Andrew Zwicker
The decision of where to put logic isn’t always clear cut.
by essentialSQL
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.
by Rion Williams
Troubleshooting SQL performance: identifying issues, optimizing queries, utilizing tools efficiently
by Steve Wellens
"The SQL command ran, there's no error message but nothing changed! What's going on? Do you think it's a virus? Maybe there's a bug in .NET!"
by Gaston Verelst
Why you would use Common Table Expressions
by essentialSQL
Work with the AdventureWorks Bill of Materials using Subqueries
by Komal Mangal
How to work with LINQ to XML
by Ivan Krivyakov
Attribute order should not matter in XAML, but sometimes it does...
by essentialSQL
Write SQL – Formulate your Question – Step 2
by essentialSQL
Write SQL - write the query
by AlexTatiyants
JSON-oriented document stores like Mongo and Couch have really become the darlings of the web application crowd. Of course, JSON (or BSON) isn't the only game in town. When it comes to document store formats, the other white meat if you will is XML.
by Keyhole Software
XML Manipulation With XML Copy Editor