SQL Script: - How to find the database restoring history of SQL Server databases
Sometime we need to find out the history of database restoration to get the answers of following questions: -
1) Do...
2018-03-30
8,191 reads
Sometime we need to find out the history of database restoration to get the answers of following questions: -
1) Do...
2018-03-30
8,191 reads
Introduction: -
We live in an era of “Automation”. Planes run on auto pilot mode, cars will soon be auto driven,...
2018-03-30
910 reads
SQL Server Install Requirements
SQL Server Installation requirements indicate .NET 3.5, 4.0, or 4.6 depending on the version. This is not including SSMS. At this point you shouldn’t use SSMS...
2018-03-30
38 reads
Some of my friends know I am a huge fan of the song “Havana” by Camila Cabello. They also know I like to remix songs and if I was...
2018-03-29
27 reads
Some of my friends know I am a huge fan of the song “Havana” by Camila Cabello. They also know...
2018-03-29
1,536 reads
I am proud to present a free webinar for the PASS Virtualization virtual chapter entitled “Level Up Your Cloud Infrastructure...
2018-03-29
430 reads
I’ve been wanting to share a little bit about Matt’s story for a while now and this past week I...
2018-03-29
902 reads
This is the third update for my goals for 2018. This is about 3 weeks after the last update, and...
2018-03-29
992 reads
Here’s a quickie that I’ve just stumbled across.
I’ve just tried to initiate a manual failover of an availability group and...
2018-03-29
533 reads
I am so honored and humbled to have been selected to speak at SQL Saturday Atlanta (#733) on May 19,...
2018-03-29
405 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...
This is my late response to T-SQL Tuesday #204. I almost always forget about...
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