Automating like an Enterprise DBA
One of the things that should seem very commonplace to a data professional is the effort to become a lazy DBA. A lazy DBA is not a bad thing....
2019-01-08
23 reads
One of the things that should seem very commonplace to a data professional is the effort to become a lazy DBA. A lazy DBA is not a bad thing....
2019-01-08
23 reads
TSQL Tuesday
The second Tuesday of the month comes to us a little early this month. That means it is time...
2019-01-08
674 reads
Point In Time Restore for Azure SQL Database
This article try to explain
Automatic backups services provided by Azure
Backup retention periods
How to take the point in time database restoration
This database restoration...
2019-01-08
56 reads
Point In Time Restore for Azure SQL Database
This article try to explainAutomatic backups services provided by Azure Backup retention periodsHow to...
2019-01-08
191 reads
From a DBA's perspective, automation is something that is absolutely necessary. This post shows just a few areas where I use automation in my life.
The post T-SQL Tuesday #110...
2019-01-08
21 reads
Automate All the Things
I had a strange thing happen to me this week. My IFTTT applet that sends me an...
2019-01-08
192 reads
Speaking at SQLSaturday Nashville – 815!
I’m proud to announce that I will be speaking at SQL Saturday Nashvilleon January 12th 2019! And wow, 815 SQL Saturdays! This one won’t let you...
2019-01-08
15 reads
Speaking at SQLSaturday Nashville – 815!
I’m proud to announce that I will be speaking at SQL Saturday Nashville on January 12th 2019! And wow,...
2019-01-08
162 reads
If you are building a big data solution in the cloud, you will likely be landing most of the source data into a data lake. And much of this...
2019-01-08
38 reads
If you are building a big data solution in the cloud, you will likely be landing most of the source...
2019-01-08
413 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