Adding a VLDB database to an SQL Server Availability Group
Recently, I was tasked with making an 60TB database highly available by adding it to an availability group. The following,...
2015-08-26 (first published: 2015-08-18)
2,110 reads
Recently, I was tasked with making an 60TB database highly available by adding it to an availability group. The following,...
2015-08-26 (first published: 2015-08-18)
2,110 reads
Monitoring SQL Server on a budget
Cheap ain’t easy
There’s a lot of tools out there, and very few that are polished,...
2015-08-18
413 reads
Recenty I was writing an article for MSSQLTips where I had to create a treemap (it will be published soon)....
2015-08-26 (first published: 2015-08-18)
2,636 reads
If we could take a picture of the HA solutions currently offered in SQL Server, database mirroring would be the...
2015-08-27 (first published: 2015-08-18)
2,412 reads
Monitoring SQL Server on a budget
Cheap ain’t easy
There’s a lot of tools out there, and very few that are polished,...
2015-08-18
335 reads
What! NO? Get with it, my friend. Power BI is for everyone. All the kids are doing it… not to...
2015-08-18
259 reads
What! NO? Get with it, my friend. Power BI is for everyone. All the kids are doing it… not to...
2015-08-18
472 reads
Recently, Many friends of mine are interested in learning SSIS so , I thought to write some blogs which might help...
2015-08-17
937 reads
This weekend I’ll be attending SQL Saturday #403 in Louisville, KY. If you’re in the area, think about taking a...
2015-08-17
879 reads
I worked on a project where we had two SSDT projects with different versions of SQL, one 2012 and one...
2015-08-17
725 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...
Comments posted to this topic are about the item Helping an English Student with...
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