Using Windows stored credentials to connect to SQL in containers
I work with SQL Server in containers pretty much exclusively when testing code and one of my real bug bears...
2018-01-17
1,138 reads
I work with SQL Server in containers pretty much exclusively when testing code and one of my real bug bears...
2018-01-17
1,138 reads
I typically don’t turn on line numbers if SSMS, but while working with someone on a bit of code, they...
2018-01-16
23,275 reads
You may have noticed that there are many menu commands that don’t have a keyboard shortcut. For instance, SQLCMD mode...
2018-01-16
126 reads
You may have noticed that there are many menu commands that don’t have a keyboard shortcut. For instance, SQLCMD mode...
2018-01-16
374 reads
PASS has released the videos to members from this past Summit. I say TJay Belt today ask about relating a...
2018-01-16
581 reads
Hello!
Not so long ago, I wrote about how dbatools now has functions that can be used to deploy dacpacs. What...
2018-01-16
345 reads
Hello all,
I’ve recently updated my YouTube channel. I’m going to be posting a lot more videos up there. If you...
2018-01-16
329 reads
I had a strange issue recently when trying to login to the Azure Portal. Quite simply I would enter my...
2018-01-16
277 reads
Having a tool to be able to monitor CLR health will be essential as you deploy more and more managed code within SQL Server. Extended Events offers a great...
2018-01-16
34 reads
The Common Language Runtime (CLR) is the fundamental nerve center of the Microsoft .NET Framework. It is this nerve center that...
2018-01-16
1,037 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