{coding}Sight

In a new article, you'll learn insights about SQL parsing issues and the errors that occurred throughout the process. Read the first part from a series of articles Completing SQL by Andrey Podkolzin https://bit.ly/3bLLzcI  #Dotnet #SQLServer #developerspic.twitter.com/yfMIbHk9Cw

Meet a new article on @codingsight Learn the Basics of Working with JSON in SQL Server. By Kenneth Igiri @kenigiri https://codingsight.com/basics-of-working-with-json-in-sql-server/ … Do you work with #JSON in #SQLServer?pic.twitter.com/wDO0JXrAyh

Advanced SQL: CROSS APPLY and OUTER APPLY https://bit.ly/2CEZ1iX  Learn about the SQL Server APPLY operator, its variations - CROSS APPLY and OUTER APPLY and how they are used - described with examples and code snippets. #sql #sqloperator #queryperformance #tsqlpic.twitter.com/mIXJneAAYV

How to use SQL Cursors for Special Purposes https://bit.ly/2CEYSfp  In this article we will go through the basics of SQL cursors and will show its pros and cons. Also we will look at some special purposes for which SQL cursors can be used. #tsql #sqlserver #sqlpic.twitter.com/4IqHkDLicT

Concatenation in Transact-SQL https://bit.ly/2uxJe0J  In this article we study the ways to use concatenation in SQL Server. We will show three methods: the CONCAT function, the CONCAT_WS function and the use of the “+” sign. #sqlfunctions #tsql #sqlpic.twitter.com/J7sxOhr2uu

Running SQL Database Maintenance Tasks Using SQLCMD https://bit.ly/2YpTzcQ  Learn how to use Sqlcmd - a utility that lets you run T-SQL commands directly from the command prompt without the use of external database tools. #sql #sqlcmd #tsql #DBApic.twitter.com/4s3eYsRyLV

Transferring Jobs and Schedules between Instances using T-SQL https://bit.ly/2us5rNI  In this article we will look at an example of a T-SQL script which transfers the Agent jobs and schedules from one instance of a MS SQL Server to another. #sql #slqserver #tsql #DBApic.twitter.com/7QSHAlyTop

SQL Server Bulk Insert – Part 2 https://bit.ly/2CDMpIW  In this article, we will go through some options (FIRE_TRIGGERS, CHECK_CONSTRAINTS and TABLOCK) of bulk insert process in various scenarios. #sql #slqserver #tsqlpic.twitter.com/Pyw2G6KRKp

Implementing Automated Database Backup and Restore with Default Means https://bit.ly/2HGB5zU  In this article we will look at an implementation of automated backup process on one server and consequent restore on a different one. #sqlserver #tsql #backup #DBApic.twitter.com/DH7O3eZz17

SQL Server 2019 New Features https://bit.ly/2HSSPau  In this article we talk about new features in SQL Server 2019, such as: Always On, Online Indexing, Query Processing and etc. #sqlserver #linux #windows #dockerpic.twitter.com/FfxDEoV2c3

In-depth Exploration of Row Level Security https://bit.ly/2Yq2evV  In this article we build a simple scenario to illustrate Row Level Security concept using a financial institution. #sqlserver #databasesecuritypic.twitter.com/pQZieEWbPO

Automatic Deletion of Forgotten Transactions in MS SQL Server https://bit.ly/2HT7sKN  In this article, we will look at an implementation of a process which automatically deletes forgotten transactions. #sqlserver #tsql #sql #DBApic.twitter.com/COiET7Ifjn

Advanced SQL: Insert output of the parameterized table-valued function in SQL table https://bit.ly/2YmNvC6  The article describes the “Insert Into” statement and its usage. It also explains how to save the output of the table-valued function to a #SQL table. #sqlserver #tsqlpic.twitter.com/YBsBH4n5Vs

SQL Server Bulk Insert – Part 1 https://bit.ly/2uqc9ny  The article describes a simple usage concepts of bulk insert and analyzes several scenarios which are close to real-life issues. #sqlserver #tsql #sqlpic.twitter.com/olGaaPXf3Q

"Introduction to Row-Level Security in SQL Server" https://bit.ly/2FzomwG  by @AcuityTraining In this article we look at row-level security feature in SQL Server, which allows users to access a table but restricts them to accessing specific rows. #sqlserver #databasesecuritypic.twitter.com/WYM6QYiG61

"Dealing with NULLs in SQL Server" https://bit.ly/2Yn4J29  by @kenigiri The article describes the concept of NULL as it relates to three-valued predicate logic and as well as popular SQL Server functions to deal with data sets containing NULLs #sql #tsql #sqlserverpic.twitter.com/GKh5f5M2Hf

"SQL Server CRUD Operations – Part 1" https://bit.ly/2HGB1jE  The article desribes the main concept of the CRUD operations and basics of the INSERT statement usage. #sqlserver #sql #tsqlpic.twitter.com/HR1vIxPrki

"Introduction to SQL Server Identity" https://bit.ly/2B5Ia8d  The article desсribes fundamental concepts and usage methods of SQL Server Identity property and Identity columns. #sql #sqlserver #tsqlpic.twitter.com/bsuMC5MaFw

"Basics of Running T-SQL Statements from Command Line using SQLCMD" This article describes a basic funtionality of sqlcmd utility and shows how to run T-SQL commands directly from the command prompt. #sqlserver #sql #sqlcmd #ssms #tsql https://bit.ly/2HF0ZDZ pic.twitter.com/CsSkb2kCKK