SQL Server 2022 Paid Editions Require a Licensing Key
For the final release of SQL Server 2022, Microsoft popped a surprise that wasn’t in the release candidates
2022-12-05
For the final release of SQL Server 2022, Microsoft popped a surprise that wasn’t in the release candidates
2022-12-05
There are many things to consider when deciding whether to invest in a database monitoring tool or whether to use a homegrown solution. However, the business frequently wants to know one thing and one thing only: what’s the return on this investment (ROI)? In this webinar, Microsoft Data Platform MVP, Grant Fritchey, is joined by our expert panel to share the pros and cons to building a monitoring system versus purchasing one.
2022-12-05
This series of articles describes a path you can take to transforming an existing, manual and error-prone database development and release process into an automated and reliable Database DevOps 'pipeline', starting here with an overview of what we set out to achieve, and the people, processes and tools involved.
2022-12-02
Learn how and why to use RAISERROR in your SQL Server code to be able to better handle errors that may occur during code execution.
2022-12-02
The previous installment of this series examined aggregate subquery removal and subquery coalescing, describing the latter as similar in some ways to an inverse for “Or Expansion” and “Join Factorization”. In this instalment, it’s time to take a closer look at Or Expansion and we’ll move on to Join Factorization in the next instalment.
2022-11-30
With the average data breach costing $4.35 million, Test Data Management (TDM) is crucial. In this session, we’ll demonstrate how TDM can reduce your risk by achieving scalable compliance without slowing down your database development process. Watch on demand now.
2022-11-30
2022-11-28
In my previous tip, I explained how we are inclined to use archive tables and how they become increasingly problematic over time. This tip will focus on ways to mitigate the issues.
2022-11-28
In this article, we cover things you should know about Azure SQL Database and why this may be a good choice for your database applications.
2022-11-25
Bob Pusateri, Database Engineering Lead at Salesforce, joined our recent Summit to discuss how automation can enable digital transformation. Listen in full.
2022-11-25
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...
Telp/Wa 62817825533 Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111
Telp/Wa 628217555651 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates, Kabupaten...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
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