Introduction to SQL Jobs in Azure Data Studio
Learn how to work with SQL Agent Jobs in Azure Data Studio.
2021-12-13
10,254 reads
Learn how to work with SQL Agent Jobs in Azure Data Studio.
2021-12-13
10,254 reads
Learn how you can get better charting in Azure Data Studio with SandDance.
2021-12-06
2,657 reads
Learn about the history and different versions of Integration Services (SSIS) in SQL Server.
2021-11-12
10,020 reads
Introduction I have to admit that I love SSMS. It is a great tool, and I felt furious when a colleague mentioned that Azure Data Studio will replace SSMS in the long run. In this new article, we will talk about the main differences between Azure Data Studio and SSMS. We will see if my […]
2021-11-10
26,761 reads
In this article, we will learn how to work with PolyBase using Azure SQL DWH.
2020-12-25 (first published: 2017-08-21)
3,265 reads
In the part 18, we created a Cube based on the Azure Data Warehouse. In this new chapter, we will work with the cube, create backups and show some tips to restore.
2020-05-29 (first published: 2017-10-23)
3,149 reads
In this new article, we will learn how to create a cube extracting data from ADWH.
2020-05-22 (first published: 2017-10-09)
2,592 reads
This time we will compare different solutions to copy system folders using different SSIS tasks.
2019-11-22 (first published: 2017-05-09)
14,123 reads
CTAS and CETAS are very important T-SQL features in ASDW. These features allow to create a table and fill with data based on a query.
2019-07-12 (first published: 2017-12-12)
4,449 reads
In this article, we will show how to connect MicroStrategy Desktop with ASDW.
2019-01-08
620 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers