Scripts for SQL PowerShell Session at Microsoft Ignite 2017
This is just a quick blog post to share the scripts I used during my sessions at the Ignite conference this year. You can download a .zip file with...
2017-09-28
24 reads
This is just a quick blog post to share the scripts I used during my sessions at the Ignite conference this year. You can download a .zip file with...
2017-09-28
24 reads
This is just a quick blog post to share the scripts I used during my sessions at the Ignite conference...
2017-09-28
637 reads
All Day DevOps is coming on Oct 24. This is a 24 hour event, with 100 sessions live, online. You...
2017-09-28
1,318 reads
Many product announcements were made this week at Microsoft Ignite, and I wanted to give a quick overview of all...
2017-09-28
990 reads
Hacker News is one of the best sources for technical news out there. I check HN at least once a...
2017-09-28
596 reads
Purpose Get help soon with SSMS Addin issues. In some cases a user might experience problems with their SSMS Add-in....
2017-09-28
271 reads
Apparently there is a new tool from Microsoft where you can discover, track, and remediate potential database vulnerabilities. This tool...
2017-10-09 (first published: 2017-09-28)
1,607 reads
When running demos and experimenting with containers I always clear down my environment. It’s good practice to leave a clean...
2017-10-06 (first published: 2017-09-28)
1,601 reads
October is a busy month for me. I am flying all over the US and Canada for speaking engagements to...
2017-09-27
562 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-10-06 (first published: 2017-09-27)
1,815 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