Speaking at PowerShell Summit 2018!
I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2018 on the conference runs from April...
2018-01-27
351 reads
I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2018 on the conference runs from April...
2018-01-27
351 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 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...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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