SQL Homework – December 2021 – Changing collation
I can only speak for the locations I’ve worked at of course, but in all of the places I’ve worked ... Continue reading
2021-12-10 (first published: 2021-12-02)
323 reads
I can only speak for the locations I’ve worked at of course, but in all of the places I’ve worked ... Continue reading
2021-12-10 (first published: 2021-12-02)
323 reads
Last Updated on January 9, 2022 by John Morehouse Recently I was looking to install VMWare components in my local network of things so that I could gain additional...
2021-12-10
40 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...
2021-12-09
40 reads
Lets summarise some important learnings about SQL MI and failover groups. when you add a database to a failover group the secondary database has the same edition / compute...
2021-12-09
156 reads
Want to learn and use Google Cloud Storage?
What is Cloud Storage & Bucket?
Type of Disk avilable in Cloud Storage?
Lets Start! Continue reading ?
2021-12-09
52 reads
Imagine getting SA (sysadmin) access to your RDS SQL Server Instance! Well, that was not possible in the past, but during AWS re:Invent 2021, Amazon RDS Custom for SQL...
2021-12-08
35 reads
There are new Ubuntu Pro 20.04 images available in the Azure marketplace with SQL Server 2019 pre-installed so I thought I’d run through how to create a three node...
2021-12-08 (first published: 2021-12-01)
292 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...
2021-12-08
29 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Dynamic Data Masking is a feature that provides...
2021-12-08 (first published: 2021-11-29)
345 reads
Over the last nine months I’ve presented (virtually) eleven times on a variety of topics relating to SQL Server and the Microsoft Data Platform. Long-time readers will know I...
2021-12-08
38 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