Failed to Create the Audit File
One day while checking things for clients, I happened across a fun little error message – “SQL Server Audit failed to...
2017-12-31
2,079 reads
One day while checking things for clients, I happened across a fun little error message – “SQL Server Audit failed to...
2017-12-31
2,079 reads
Most of you must be knowing that backup in Azure SQL Database fully automatic. After the database is created and...
2017-12-31
739 reads
Templates are a powerful tool in so many trades and crafts. From decals and stickers all the way up to the largest cruise ships in the world, templates can...
2017-12-30
16 reads
Templates are a powerful tool in so many trades and crafts. From decals and stickers all the way up to...
2017-12-30
362 reads
Templates are a powerful tool in so many trades and crafts. From decals and stickers all the way up to...
2017-12-30
712 reads
From SQL Guatemala, we wish you a happy new year 2018.
We hope this new year brings you joy and zero:...
2017-12-30
336 reads
(last updated: 2018-03-27)
Despite features added in SQL Server 2005 (yes, 2005!) that allow for very flexible, granular, and robust security,...
2017-12-30
4,336 reads
Welcome to gethynellis.com and our final post of the year.
SQL Server 2017 - In Review
It’s the end of what has been...
2017-12-30
590 reads
Naming no names here, but I want to talk about a really horrible sales call I had recently. Well, the...
2017-12-29
1,047 reads
In a few days the year 2017 will come to a close. The brand new year 2018 is on deck...
2017-12-29
346 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