Is your SQL Server environment ready for GDPR? Part 1
Unless you have been living under a rock lately, you have not heard about GDPR. This has been hot topic...
2018-05-25
154 reads
Unless you have been living under a rock lately, you have not heard about GDPR. This has been hot topic...
2018-05-25
154 reads
Vulnerability assessment is probably one of the most underrated new security features in SSMS 17. This feature is not new...
2018-05-21
155 reads
The SQL Server ERROR log is the best source to understand what’s wrong with your SQL Server instance, think this...
2018-05-10
149 reads
In some point of your career as DBA you might have interacted with ITIL or at least your heard about...
2018-04-13
275 reads
In my previous post I did my best explain a little bit what ITIL is and how important is for...
2018-04-13
258 reads
This is probably a very delayed post, but I have been really busy lately.
As mentioned in my previous post, I...
2018-03-23
118 reads
I’m very thrilled to announce that I will be participating as speaker in this year’s SQL Saturday event in Guatemala city!
Here...
2018-01-04
121 reads
Have you ever had problem with your backup jobs taking more time than usual overlapping your maintenance window? It is...
2017-12-01
249 reads
Today’s tip is a very basic functionality that comes with any SSMS (SQL Server Management studio), we are talking about...
2017-11-07
207 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