Azure SQL database SKU selection
When migrating on-premise SQL Server database to Azure SQL environment, identifying the right compute capacity of the target environment to match the resource consumption of(more...)
2021-05-08
149 reads
When migrating on-premise SQL Server database to Azure SQL environment, identifying the right compute capacity of the target environment to match the resource consumption of(more...)
2021-05-08
149 reads
Azure SQL database is a cloud based Database as a Service provided by Microsoft Azure platform. This service is based on the traditional SQL Server(more...)
2021-05-02
29 reads
In this exercise we will see the implementation of Windows Active Directory integration to Microsoft SQL Server on Linux environment. In this example Centos1 is(more...)
2020-12-09
25 reads
This exercise demonstrates the installation and configuration of Microsoft SQL Server on Linux environment, this is a standalone deployment . Step 1 – Create “mssql”(more...)
2020-12-08
30 reads
This exercise demonstrates the installation and configuration of Postgres database on Linux environment using source tar file. Step 1 – Download Postgres tar file wget(more...)
2020-12-08
30 reads
In CentOS 7 Linux MariaDB is by default installed, due to this you may face issue installing MySQL. If you want to install MySQL, first(more...)
2020-12-08
42 reads
Sharding is a method for distributing data across multiple machines. MongoDB uses sharding to support deployments with very large data sets and high throughput operations.(more...)
2020-11-20
33 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