Better Security with dbatools
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2018-01-26
772 reads
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2018-01-26
772 reads
Wayne’s Tips and Tricks for SSMS
SQL Server Management Studio (SSMS ) is a program that many just launch daily (or only...
2018-01-26
715 reads
We all know that we should liberally document our code with comments, so that others (and even yourself) will know...
2018-01-26
397 reads
Recently, one of my clients had a need to automatically download a file from a public facing state government website. ...
2018-01-26
137 reads
Recently, one of my clients had a need to automatically download a file from a public facing state government website. ...
2018-01-26
1,164 reads
As mentioned previously, the process of setting up TDE (Setting up Transparent Data Encryption (TDE)) is the same whether you’ve...
2018-01-26
1,217 reads
You can set up Transparent Data Encryption (TDE) when you first create a database, or you can apply it to...
2018-01-26
2,709 reads
Transparent Data Encryption (TDE) was introduced in SQL 2008 as a way of protecting “at rest” data. It continues to...
2018-02-07 (first published: 2018-01-26)
2,209 reads
It’s moving weekend! Hopefully two hard days and then I’ll be all settled in my new place. Cannot wait.
Inbetween packing...
2018-01-26
263 reads
By Steve Bolton
…………The sample T-SQL I posted in the last article wasn’t as difficult as it looked, considering that it...
2018-02-06 (first published: 2018-01-25)
1,183 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