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

@codingsight

Followers
847
Following
785
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: https://t.co/xPBkXAJcJ8
0
2
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: https://t.co/8grOe4LbCs
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: https://t.co/HryqREH6KB
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: https://t.co/jv5Is9P24t
0
0
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: https://t.co/7kEjiGeA0Y
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: https://t.co/g2cDpBXweT
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: https://t.co/35ofQo9DZp
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: https://t.co/pq1bu84Bwh
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: https://t.co/TdUnaIxx9r
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: https://t.co/B9XntIOIbg
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: https://t.co/n9GGAv0ilQ
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: https://t.co/csW0VPYUnc #oracle #analytics #clusters
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: https://t.co/KSLIlRuutX
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: https://t.co/xLWcMFLS7o
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: https://t.co/hgGfAqx77w
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: https://t.co/Ur5WVAPb6P
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: https://t.co/22mzLFTbb8
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: https://t.co/Ovbaf57j7v
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: https://t.co/LeEpet7x2G
0
0
2
@codingsight
{coding}Sight
4 years
🚀 Welcome our blog article by Nisarg Upadhyay “Renaming Indexes with sp_rename Procedure” 👉 Read in full: https://t.co/dWGZ9gqiS2 #sqlindex #storedprocedure #SQL #sqldeveloper
0
0
1