7 Courses for FREE from Scrimba!!

​Exciting news for aspiring developers! Scrimba has just launched its Fullstack learning path, offering a suite of interactive, in-browser courses designed to elevate your development skills. Whether you're aiming to become a fullstack developer or enhance your current toolkit, these courses provide essential knowledge for the modern developer.​

Available Courses:

• Learn Node.js – Build powerful backends with Node.js.
• Learn Express.js – Master Express.js for efficient server-side development.
• Learn Next.js – Work with Next.js, the world's most popular fullstack framework.
• Intro to SQL – Handle data proficiently with SQL.
• Intro to Vite – Speed up your frontend development with Vite.
• Intro to Supabase – Add a backend to your app without writing a server using Supabase.
• Command Line Basics – Unlock the terminal and take control of your development environment.

These courses are designed to provide a hands-on learning experience, enabling you to build real-world applications as you learn. Whether you're starting from scratch or looking to fill in knowledge gaps, Scrimba's Fullstack path is a valuable resource.​

Explore the full curriculum and start learning today: Learn to code with Scrimba

Happy coding!

Get Current TimeZone Name in SQL Server

Here is how we can get current time zone from sql server

DECLARE @TimeZone VARCHAR(50)
EXEC MASTER.dbo.xp_regread 'HKEY_LOCAL_MACHINE',
'SYSTEM\CurrentControlSet\Control\TimeZoneInformation',
'TimeZoneKeyName',@TimeZone OUT
SELECT @TimeZone

Determining which version and edition of SQL Server Database Engine is running

Open SQL Server Management Studio (SSMS) and connect to SQL Server. Run below query to find version and edition of SQL server.

SELECT  
    SERVERPROPERTY('productversion') as 'Product Version', 
    SERVERPROPERTY('productlevel') as 'Product Level',  
    SERVERPROPERTY('edition') as 'Product Edition',
    SERVERPROPERTY('buildclrversion') as 'CLR Version',
    SERVERPROPERTY('collation') as 'Default Collation',
    SERVERPROPERTY('instancename') as 'Instance',
    SERVERPROPERTY('lcid') as 'LCID',
    SERVERPROPERTY('servername') as 'Server Name'

SQL Server next version CTP 1.3 now available

Microsoft announced a new preview for the next version of SQL Server (SQL Server v.Next). Community Technology Preview (CTP) 1.3 is available on both Windows and Linux.

In this preview, Microsoft has added several feature enhancements to High Availability and Disaster Recovery (HADR), including the ability to run Always On Availability Groups on Linux. You can try the preview in your choice of development and test environments now: www.sqlserveronlinux.com.

Get started with the preview of SQL Server with developer tutorials that show you how to install and use SQL Server v.Next on macOS, Docker, Windows and Linux and quickly build an app in a programming language of your choice.

• Install on Red Hat Enterprise Linux
• Install on Ubuntu Linux
• Install on SUSE Linux Enterprise Server
• Pull and run a Linux Docker container on Linux, Windows or macOS
• Download the preview for Windows
• Create a SQL Server on Linux virtual machine in Azure

The Early Adoption Program is designed to help customers and partners evaluate new features in SQL Server v.Next, and to build and deploy applications for SQL Server v.Next on Windows and Linux. Sign up for the Early Adoption Program (EAP)