SQLSaturday Baton Rouge thank yous
Hello everyone who was at #SQLSatBR this year!We had a huge early morning wave of attendees this morning that inundated our sponsors just like a cooling rain inundated us in...
2018-08-12
16 reads
Hello everyone who was at #SQLSatBR this year!We had a huge early morning wave of attendees this morning that inundated our sponsors just like a cooling rain inundated us in...
2018-08-12
16 reads
The Cloud is a fun and exciting place to be. Exciting as it may be, even in the cloud, protection...
2018-08-10
300 reads
You might think that this blog post is out of place here but I'm hoping use some of the data...
2018-08-10
312 reads
It’s been a couple of weeks now since I took the plunge and bought myself a Dell XPS 13 running...
2018-08-10
312 reads
(last updated: 2019-01-10 @ 18:00 EST / 2019-01-10 @ 23:00 UTC )
With the additional (and annoying) configuration step required to get SQLCLR Assemblies...
2018-08-27 (first published: 2018-08-09)
4,099 reads
At this year’s TechnoSecurity and Digital Forensics Conference I gave a 1 hour presentation on auditing SQL Server. There were...
2018-08-09
270 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-08-20 (first published: 2018-08-09)
1,828 reads
I have recently started as an author for MSSQLTips.com website, this is an excellent site where you can start writing...
2018-08-09
197 reads
I’m sure that we all know that SQL Server includes all sorts of interesting functionality to allow us to encrypt...
2018-08-27 (first published: 2018-08-09)
1,853 reads
Wanted to be proactive and move a database that was in the default path on C: to a secondary drive as it was growing pretty heavily.
What I didn’t realize...
2018-08-08
46 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