Toolbox - Do You Have Current Backups?
On our managed servers we run a job each day to check that either a FULL or DIFF has run...
2018-04-04
690 reads
On our managed servers we run a job each day to check that either a FULL or DIFF has run...
2018-04-04
690 reads
There are already a number of articles and blog posts that reveal the benefits of the SQL Operations Studio tool. The...
2018-04-16 (first published: 2018-04-04)
2,069 reads
I am excited to announce that I have been selected to speak at Music City Tech held at Vanderbilt University...
2018-04-04
288 reads
This blog post is about how to diagnose what your Azure VM is doing while it is booting.
I have a...
2018-04-06 (first published: 2018-04-04)
1,660 reads
Welcome to a new series that Manuel Quintana [Blog | Twitter] and I are starting where we will cover some of...
2018-04-04
446 reads
There has been talk of a dark theme for SSMS for years. Does it exist, will it exist? Well, the...
2018-04-04
484 reads
SQL Server Database is an advance relational database management system, which is widely used by business professionals. But one of the serious issue one faces is SQL Server Database...
2018-04-04
30 reads
SQL Server Database is an advance relational database management system, which is widely used by business professionals. But one of...
2018-04-04
706 reads
I got asked this question last week and it’s a very good one. After all, running Sql Server in Azure...
2018-04-05 (first published: 2018-04-04)
1,770 reads
2018-04-03
268 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