Backing up SQL Server on Linux using Ola Hallengrens Maintenance Solution
With the release of SQL Server vNext CTP 1.4 SQL Agent was released for use on Linux. To install it...
2017-04-06 (first published: 2017-03-22)
1,882 reads
With the release of SQL Server vNext CTP 1.4 SQL Agent was released for use on Linux. To install it...
2017-04-06 (first published: 2017-03-22)
1,882 reads
Last week, we discussed storing text in a database. This week we will dive deeper into data types. When storing...
2017-03-22
120 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-04-06 (first published: 2017-03-22)
2,755 reads
I was recently reading this msdn article on Ghost Records, and it mentioned that you could get the number of...
2017-04-04 (first published: 2017-03-22)
10,240 reads
In a previous post I showed how easy it is to test your backups using Test-DbaLastBackup
Today I thought I would...
2017-04-05 (first published: 2017-03-22)
1,940 reads
I was working on a blog post this weekend that required a list of random numbers. Now, this isn’t exactly...
2017-04-05 (first published: 2017-03-22)
2,374 reads
It seems like SSMS has seen better days. Many developers I have worked with recently complain about Out of Memory...
2017-03-22
641 reads
Speaking at PowerShell + DevOps Global Summit 2017!
I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2017 on the conference runs from April...
2017-03-22
14 reads
Speaking at PowerShell + DevOps Global Summit 2017!
I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit...
2017-03-22
330 reads
On Saturday, March 18, 2017, I spoke at my very first SQL Saturday. I have been an attendee, involved in...
2017-03-22
338 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
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