SQL Homework – June 2021 – SQL Audits
Last month I had you work on Extended Events, so hopefully now you are a bit more comfortable with them. ... Continue reading
2021-06-14 (first published: 2021-06-01)
308 reads
Last month I had you work on Extended Events, so hopefully now you are a bit more comfortable with them. ... Continue reading
2021-06-14 (first published: 2021-06-01)
308 reads
On the theme of failover groups let’s do a quick recap on my environment. As shown below you can see the secondary database server called spacesql in West Europe....
2021-06-11
114 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-06-11
34 reads
The other day I saw something that I wasn’t sure I’ve ever see again. The call for speakers for the PASS Data Community Summit went out. After the dissolution...
2021-06-11 (first published: 2021-05-28)
153 reads
I recently gave a presentation at the WITDC Mental Health and Wellness day. The recordings are out and here’s the ... Continue reading
2021-06-11 (first published: 2021-05-27)
229 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-06-10
43 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Encryption is a function call in SQL Server,...
2021-06-09 (first published: 2021-05-26)
629 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-06-09
52 reads
Another buzzword that you may have been hearing a lot about lately is Data Fabric. In short, a data fabric is a single environment consisting of a unified architecture...
2021-06-09
23 reads
I get asked this question all the time, so I figured it was time to write a blog post, record a video and write some code to automate the...
2021-06-09 (first published: 2021-05-22)
329 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...
Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132.. Fungsi Layanan:...
Call Cs 08218200233 Jl. Borobudur No.I, RT.03/RW.07, Mojolangu, Kec. Lowokwaru, Kota Malang, Jawa Timur...
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