How Much Linux Do You Need?
With SQL Server on Linux becoming more popular, Steve asks if you think you need to know much about that OS.
2025-02-14
98 reads
With SQL Server on Linux becoming more popular, Steve asks if you think you need to know much about that OS.
2025-02-14
98 reads
2024-07-24
351 reads
2024-02-23
308 reads
2024-01-26
337 reads
In this tip, we're going to look at the steps to backup SQL Server on Linux databases using SQL Server Agent on a Windows server.
2024-01-01
Microsoft built SQL Server on Linux. Are people coming to use it? Are you?
2023-09-22
144 reads
In this article, we will analyze the various out-of-the-box deployment options Oracle Cloud Infrastructure and Google Cloud Platform offers to host a Microsoft SQL Server database. This information can prove to be handy while deciding on the best cloud provider to host a given application or database.
2022-02-18
6,976 reads
2021-10-08
326 reads
2021-10-06
309 reads
An announcement on Windows containers has Steve noting that Linux might be a more desired skill in the future for SQL Server professionals.
2021-07-10
199 reads
By Steve Jones
We published an article recently at SQL Server Central on Tally Tables in Fabric...
By James Serra
In today’s data-driven world, organizations need the ability to analyze and act on data...
This month’s T-SQL Tuesday blog party is hosted by Deborah Melkin – Data Platform MVP,...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Explore the world of Omegle, the platform that connects you with strangers worldwide. Learn...
Hi , Im Facing the Below Issue in Ananlytics. We have a Inventory Partition...
I created a new sequence in SQL Server 2022 with this code.
CREATE SEQUENCE myseqtest START WITH 1 INCREMENT BY 1; GOI want to use this to insert some data from another table into a new table with this sequence. Which of these queries shows the way to do this efficiently?
-- 1 INSERT dbo.NewMonthSales (SaleID, saleyear, salemonth, currSales) SELECT NEXT VALUE FOR myseqtest , ms.saleyear , ms.salemonth , ms.currMonthSales FROM dbo.MonthSales AS ms; GO -- 2 INSERT dbo.NewMonthSales (SaleID, saleyear, salemonth, currSales) SELECT NEXT VALUE , ms.saleyear , ms.salemonth , ms.currMonthSales FROM dbo.MonthSales AS ms, myseqtest; GO --3 DECLARE mycurs CURSOR FOR SELECT ms.saleyear , ms.salemonth , ms.currMonthSales FROM dbo.MonthSales AS ms DECLARE @yr INT, @mn INT, @sales NUMERIC(10,2) FETCH NEXT FROM mycurs INTO @yr, @mn, @sales WHILE @@FETCH_STATUS = 0 BEGIN INSERT dbo.NewMonthSales (SaleID, saleyear, salemonth, currSales) SELECT NEXT VALUE FOR myseqtest , @yr , @mn , @sales FETCH NEXT FROM mycurs INTO @yr, @mn, @sales ENDSee possible answers