codingsight Profile Banner
{coding}Sight Profile
{coding}Sight

@codingsight

Followers
865
Following
787
Media
363
Statuses
1K

Awesome blog for SQL Server, .NET, and JavaScript Developers!

Mountain View, California
Joined January 2015
Don't wanna be here? Send us removal request.
@codingsight
{coding}Sight
4 years
📢 How to Delete Entire #MySQL #Database.Welcome our new blog article by Nisarg Upadhyay. 💡 Article shows different ways of how to delete a database in MySQL with the help of MySQL command-line utility and #MySQLWorkbench. ☑️ Read in full: .
Tweet media one
0
3
1
@codingsight
{coding}Sight
4 years
📢 How to Auto-trigger #AWS Lambda Functions.Our new blog article by Aveek Das is out now!. 💡 This step-by-step tutorial explains how to create automated schedules using the #CloudWatch Rules and auto-trigger #AWSLambda functions. ✅ Full article:.
Tweet media one
0
2
1
@codingsight
{coding}Sight
4 years
📢 "Connecting a Bastion Server to a #PostgreSQL Server via SSH Tunnel" by Theodoros Karasavvas. 💡 Learn how to connect a bastion server to PostgreSQL server via #SecureShell Tunnel to lower the level of the private network exposure. ☑️ Read in full: .
Tweet media one
0
1
1
@codingsight
{coding}Sight
4 years
📢 "How to Create a Table with Multiple #ForeignKeys and Not Get Confused" by Ben Richardson. 💡 Article explains how to add multiple foreign keys to the same table in #SQLServer using the #SQLqueries to add foreign keys. ☑️ Read in full: .
Tweet media one
0
1
0
@codingsight
{coding}Sight
4 years
📢 "Troubleshooting Issues when Working with Date and Time in #SQLServer" by Ben Richardson!. 💡 Article focuses on troubleshooting some of the most common issues that you might face while working with the #SQL time and date #datatypes. ✅ Read in Full:
Tweet media one
0
0
1
@codingsight
{coding}Sight
4 years
🚀 Welcome our blog article by Josip Saban “Storing Binary #DataTypes in #SQLServer . What’s in:.🔹 Manual Value Conversion Using CAST().🔹 Using Conversion Styles with CONVERT().🔹 Difference Between BINARY and VARBINARY. 👉 Read in full:
Tweet media one
0
0
0
@codingsight
{coding}Sight
4 years
🚀 We'd like to share a blog article by Theodoros Karasavvas “How to Protect #MySQL #database from Ransomware Campaigns”.📑 Article describes how to protect your MySQL database from ransomware attacks. 👉 Read in full:
Tweet media one
0
0
0
@codingsight
{coding}Sight
4 years
📢 Converting DateTime to YYYY-MM-DD Format in #SQLServer.Our blog article by Ben Richardson is out now!. ✅ Full article is available by the link:
Tweet media one
0
0
2
@codingsight
{coding}Sight
4 years
📢Stored Procedure to Get the Latest Database Backups Status.The blog article by Alejandro Cobar is out now!. 💡 Deploy this SP in every #SQLServer instance and check the latest #database #backup information (System and User databases). ✅ Full article:.
Tweet media one
0
0
0
@codingsight
{coding}Sight
4 years
📢 Managing your #MSSQL #Replication.Our blog article by Carla Abanes is out now!. 💡 Article shows tips and #TSQL scripts for you to use when you need to check many #SQLAgent jobs are created after the replication configuration. ✅Read in full:.
Tweet media one
0
0
0
@codingsight
{coding}Sight
4 years
📢 Advanced Analytics with #Oracle #DataAnalytics – Handling with Express Builder Functionality.The lat part of the Advanced Analytics series by Dung Dinh is out now!. ✅ Full article is available by the link:
Tweet media one
0
0
0
@codingsight
{coding}Sight
4 years
📢 Learning Advanced Analytics Features with #Oracle #Analytics: #Outliers and #Clusters.Our blog article by Dung Dinh is out now!. ✅ Article is available by the link: #oracle #analytics #clusters
Tweet media one
0
0
1
@codingsight
{coding}Sight
4 years
🚀 Welcome our blog article by Josip Saban “Understanding #SQL Server Database Errors”. This article focuses on both #SQLServer #database errors handling and transactions with the help of TRY-CATCH statement. Learn on examples!. 👉 Read in full:
Tweet media one
0
0
1
@codingsight
{coding}Sight
4 years
📢 "How to Create and Configure #MicrosoftAzure #DevOps CI/CD #Pipeline Agent" by Vitalii Zaichenko. 💡Article describes how to create and setup self-hosted or Microsoft-hosted #Azure DevOps CI/CD Pipelines Agent. ☑️ Read in full: .
Tweet media one
0
0
3
@codingsight
{coding}Sight
4 years
A #PowerShell Tool to Get the Status of #SQLAgent Jobs by Alejandro Cobar. Article will help you to quickly check the current status of #SQLServer Agent jobs, either inventory or just the last execution status. Read in full to get more info:
Tweet media one
0
0
2
@codingsight
{coding}Sight
4 years
📢 Easy Answers to 5 Vital Questions about Composite #Index in #SQL . Welcome our blog article by Edwin Sanchez. 💡 This article explains what is composite index in SQL and when to use one on examples. ☑️ Read in full to get more info: .
Tweet media one
0
0
2
@codingsight
{coding}Sight
4 years
📢 The #CartesianProduct in SQL.Welcome our blog article by Philipp Zhenov. 💡 Learn what a Cartesian Product in #SQL is and how to apply it on practice. Find out why it's better to avoid using it in specific cases. ☑️ Read in full to get more info:
Tweet media one
0
0
2
@codingsight
{coding}Sight
4 years
🚀 We’d like to share our blog article by Ben Richardson “How to Download and Install SQL Server Express Edition?”. 📑 Article describes step-by-step process for downloading Microsoft #SQLServer Express Edition and Microsoft #SSMS. Read in Full:
Tweet media one
0
0
3
@codingsight
{coding}Sight
4 years
🚀 Welcome our blog article by Tomas Helgi Johannsson “#MySQL and #MariaDB #Backup and Restore Strategy with Best Practices”. Explore the main types of how to backup and restore MySQL/MariaDB database. Check for best practices and examples!. Link:
Tweet media one
0
0
2
@codingsight
{coding}Sight
4 years
🚀 Welcome our blog article by Nisarg Upadhyay “Renaming Indexes with sp_rename Procedure”. 👉 Read in full: #sqlindex #storedprocedure #SQL #sqldeveloper
Tweet media one
0
0
1