SQL Server 2017: Making Backups Great Again!
In some DBA circles, backups are just as popular as politicians! However, recoverability is the most important task for database...
2017-11-10 (first published: 2017-10-31)
2,602 reads
In some DBA circles, backups are just as popular as politicians! However, recoverability is the most important task for database...
2017-11-10 (first published: 2017-10-31)
2,602 reads
Azure SQL Database Managed Instance is a new flavor of Azure SQL Database that is a game changer. It offers...
2017-10-31
1,198 reads
By Steve Bolton
…………When I was about 12 years old, I suddenly discovered football. Many lessons still awaited far in the...
2017-11-09 (first published: 2017-10-31)
1,550 reads
Formula One …. F1 …. Photo by Jp Valery on UnsplashEvery once in a while I discover a SQL Server Management Studio trick that’s apparently...
2017-10-31
407 reads
Every once in a while I discover a SQL Server Management Studio trick that's apparently been around forever but is completely new to me.
Today I want to point out...
2017-10-31
26 reads
If you are headed to Seattle for the PASS Summit, not only are you in for a week of intense...
2017-10-30
346 reads
Conferences are a great place to network, to see new technologies or to see existing technologies being used in new...
2017-10-30
685 reads
I have a new installation of SQL Server 2017, along with an instance of Analysis Services Tabular 2017. I tried...
2017-10-30
1,528 reads
Recently I’ve been thinking about Python and whether it can be useful to the DBA as well as the data...
2017-10-30
410 reads
As you read this, I’m in Seattle for the PASS Summit 2017. I have four roles that I satisfy at...
2017-10-30
592 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
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