2020 Year in Review
Yeah, so…that was a hell of a year, wasn’t it?
Short-Form Reviews of Year 2020 Reviewer #1: 👎
Reviewer #2: ★✩✩✩✩, would not recommend
Best Laid Plans… The year started out really...
2021-01-04
13 reads
Yeah, so…that was a hell of a year, wasn’t it?
Short-Form Reviews of Year 2020 Reviewer #1: 👎
Reviewer #2: ★✩✩✩✩, would not recommend
Best Laid Plans… The year started out really...
2021-01-04
13 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-01-04
32 reads
In this article I have demonstrated a fairly simple method to help you modify your network adapters that are presented to SQL Server.
The post Simple Method to Add A...
2021-01-04 (first published: 2020-12-28)
573 reads
Following up on Should There Be A Successor to PASS? I have a couple more thoughts. One of the many complaints about PASS over the years was about perceived value....
2021-01-04 (first published: 2020-12-28)
567 reads
Introduction Ad hoc distributed queries use the OPENROWSET and OPENDATASOURCE functions to connect to remote data sources that use OLE DB. As the name suggests, ad-hoc distributed queries should...
2021-01-04
365 reads
There are various ways to keep SQL Server databases and SQL Database/SQL Managed Instance (SQL MI) databases in-sync asynchronously that I will discuss in this blog. The main use...
2021-01-04
48 reads
These are a few simple queries to help you along your way to becoming better acquainted w/ XEvents in Azure SQL. These queries will make XEvents easier for you!
The...
2021-01-04
48 reads
These are a few simple queries to help you along your way to becoming better acquainted w/ XEvents in Azure SQL. These queries will make XEvents easier for you!
The...
2021-01-04
31 reads
These are a few simple queries to help you along your way to becoming better acquainted w/ XEvents in Azure SQL. These queries will make XEvents easier for you!
The...
2021-01-04
27 reads
If anything, 2020 is an asterisk. Some lost their jobs. Some lost their loved ones. Perhaps more books will be written about it. Pundits will keep the conversation going....
2021-01-04
41 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...
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