SQL Server

SQL Server is Microsoft's relational database management system. It is a full-featured database primarily designed to compete against competitors Oracle Database and MySQL.

sql mssql sql-server sqlserver

Simple Steps To Connect SQL Azure To SSMS

Find out easy and sequential process on how to connect to Azure SQL Server and create a database using SQL Server Management Studio.

Fun SQL Injection 2 — MSSQL

Fun SQL Injection 2 — MSSQL. With this we are seeing that the website works correctly! .. but as happens in most sites vulnerable to sql injection, just add a ‘at the end of the parameter to see an SQL error.

10 SQL Standards to Make Your Code More Readable in 2021

10 SQL standards to make your code more readable in 2021. This is my 20th year working with SQL (eek!), and I’ve shared my 10 key learnings to help make sure your SQL code is easy to read, debug, and maintain. Make a NY resolution for 2021: Easy to read, and maintain SQL.

Working with User-Defined Functions in SQL Server

Working with User-Defined Functions in SQL Server. We will be discussing user-defined functions in SQL Server. More specifically, we will be discussing Scalar functions and Table-Valued functions. Creating functions. Using functions in Statements. Update/Delete functions.

Extract domain of Email from table in SQL Server

Extract domain of Email from table in SQL Server. SQL Queries could be used to extract the domain from the Email address. Let us created table named “email_demo” – create table (ID int, Email varchar (200));

Managing your MS SQL Replication

The article describes the concept and benefits of replication and its components as well as pros and cons of transactional replication snapshot replication, and merge replication.

6 Free T-SQL and Microsoft SQL Server Online Courses for Beginners

6 Free Microsoft SQL Server and T-SQL Courses. Introduction to Databases and SQL Querying. Advanced Databases and SQL Querying. SQL Server Baby Step. The Ultimate Guide to Becoming a SQL Server DBA. How To Begin Your Career As a SQL Server DBA. Introduction to SQL Server.

How to convert a value of one type to another type in SQL server

Convert means to change the form or value of something. The CONVERT() function in SQL server is used to convert a value of one type to another type. Learn How to convert a value of one type to another type in SQL server.

Some Useful System Stored Procedures in SQL

These procedures are built-in procedures and will help to extract the definition and dependencies of the existing user-defined stored procedures. Learn Some Useful System Stored Procedures in SQL.

How To Restore Your Database From a SQL Backup

Backing up SQL and databases using the manual restore method, the full database backup, the incremental restore, or the manageauditing command. Learn How To Restore Your Database From a SQL Backup.

Understanding the SQL Server Database Errors

Understanding the SQL Server Database Errors. There are two general categories – syntax or logical errors can be either programmatic errors or consequences of incorrect database design. T-SQL (the SQL Server programming language) allows handling both error types. You can debug the application and decide what you need to do to avoid bugs in the future.

How To Recover SQL Server FILESTREAM Enabled Database

In this SQL Server tutorial, we will discuss three separate methods of how to recover SQL Server FILESTREAM in a database in the case of severe database corruption. Restore Database From Backup; Run DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS; Use SQL Recovery Tool

Working Contact Form HTML CSS | php contact form to gmail

Working Contact Form HTML CSS PHP. We will create a php contact form which will sent messages directly into your Gmail account. HTML CSS Code: https://codepe...

SharePoint Server Data Recovery Tool Repair Corrupt SharePoint MDF Database

Free Download SharePoint Data Recovery Software to recover data from damaged mdf database files. Support SharePoint Server 2007, and 2010.

Retrieving your SQL LocalDB Instance Name: A How-To Guide

Retrieving your SQL LocalDB Instance Name: A How-To Guide. This command displays some info about the specified SQL instance: this info includes the version, the owner, and the current state.

SQL Server Performance Tuning Made Simple

In this tutorial, we’ll show a process for SQL Server performance tuning, and several tools, tips and techniques you can use to monitor performance and take the necessary steps to improve it.

SQL Server Database Design Tutorial

In this video we will learn How to use SQL Server to design the C# Application Database. I've made the complete tutorial that help you to understand how to use SQL Server to design the C# Application database.

Why You Should Learn SQL to Boost Your Career

Data — when collected, stored and analyzed — can be useful for making decisions in almost every department of a business. But how is the data collected, stored, and analyzed? That’s where SQL comes in. Why You Should Learn SQL to Boost Your Career.

Install SQL Server 2019 in Windows 10

In this video we will learn How to Install SQL Server 2019 in Windows 10. SQL Server is a server which used to design the application database. You can use SQL Server to create database, tables etc.

Benchmark databases in Docker: MySQL, PostgreSQL, SQL Server

Learn how to benchmark databases in Docker: MySQL, PostgreSQL, SQL Server. Why should you do database benchmark? I was a long-term SQL Server user. But it was not my decision to use SQL Server.