Power Automate – Returning the Last Day of the Month
Have you ever needed to set a property or field to the last day of the month? This is a common business problem that can
2022-04-01 (first published: 2022-03-25)
433 reads
Have you ever needed to set a property or field to the last day of the month? This is a common business problem that can
2022-04-01 (first published: 2022-03-25)
433 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Lots of people have never worked with LocalDB,...
2022-04-01 (first published: 2022-03-28)
231 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-03-31
33 reads
This blog pos illustrates how Azure Data Explorer and Azure Synapse Analytics complement each other for near real-time analytics and modern data warehousing use cases. This solution is already...
2022-03-31
66 reads
In the previous blog post we created an Azure Data Explorer (ADX) cluster. In this blog post we will create a database that we will ingest data into, as...
2022-03-31
85 reads
I have written a lot about the magic of KQL and the brilliance of Azure Data Explorer. Now we should create a cluster of our own that hosts Azure...
2022-03-31
43 reads
Basically when we are writing KQL we are asking the following questions: Does it exist? Where does it exist? Why does it exist? What shall we do with the...
2022-03-31
42 reads
This blog post is about another use of KQL that will definitely help your organisation and make you very popular. First of all check out this video here which...
2022-03-31
254 reads
This blog post demonstrates a hybrid end-to-end monitoring solution integrated with Microsoft Sentinel and Azure Monitor for ingesting streamed and batched logs from diverse sources, on-premises, or any cloud,...
2022-03-31
55 reads
This blog post is about how to quickly learn KQL. Kusto supports a subset of the SQL language. See the list of SQL known issues for the full list of unsupported...
2022-03-31
1,361 reads
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