Azure Data Studeo- Nov 2019 Release
SQL Server Management studio is now can be installed separately not part of SQL Server package. with this enhancement SSMS has several features and version is getting updated and...
2019-11-12
67 reads
SQL Server Management studio is now can be installed separately not part of SQL Server package. with this enhancement SSMS has several features and version is getting updated and...
2019-11-12
67 reads
You are going to create a multi-subnet Availability Group in Part 3 of our series on how to build a SQL Cluster Lab. First you […]
The post Build a...
2019-11-11
37 reads
You are going to create a multi-subnet Availability Group in Part 3 of our series on how to build a SQL Cluster Lab. First you give the Cluster Name...
2019-11-11
46 reads
You are going to create a multi-subnet Availability Group in Part 3 of our series on how to build a SQL Cluster Lab. First you give the Cluster Name...
2019-11-18 (first published: 2019-11-11)
601 reads
Almost lost in all the announcements from Ignite was a bunch of amazing new features that were added to the Provisioned Resources/SQL Pool section (read SQLDW functionalities) side of...
2019-11-19 (first published: 2019-11-11)
539 reads
For those who don’t know, last week was the PASS Summit. It’s an amazing event every year, but this last week, I saw a ton of indications that our...
2019-11-20 (first published: 2019-11-11)
642 reads
TEST Automation Taxes Your Sanity
You have to glue together systems with your amazing duct taped scripts.
You see failure after failure.
You want help predicting the success of your next run,...
2019-11-11
38 reads
I like to say that the goal for any event is to meet the expectations of attendees. The trick is to set the expectations because if you don’t, they...
2019-11-11
42 reads
Microsoft announced recently that they were changing the way licensing works for HA and DR situations. I think this is a great change, and the summary is: You can...
2019-11-11
51 reads
Good morning in November! We were all looking at the Microsoft Ignite in Orlando last week. And it happened! SQL Server 2019 is now generally available – more details...
2019-11-11
56 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