Hardware Wrestling
A few weeks back I had some issues. They were related to this:
My standing desk was down and as you...
2017-11-24
477 reads
A few weeks back I had some issues. They were related to this:
My standing desk was down and as you...
2017-11-24
477 reads
Time Zones were definitely being a drag today. I got an email from one of the developers at work asking...
2017-11-24
1,137 reads
Seldom are the days when you run into complex issues but resolve them in the shortest interval of time.
Thanks to...
2017-11-24
513 reads
Azure data centers and Regions:
Azure data centers are located worldwide and a team/division MCIO (Microsoft Cloud Infrastructure and Operations) manages all the data centers...
2017-12-06 (first published: 2017-11-24)
1,788 reads
It’s been a long career for me. In fact, I’ve been a SQL Server data professional for 17 years, just...
2017-11-23
1,067 reads
Naturally the cost of Azure SQL Database directly relates to what tier and performance level you are using. Starting from...
2017-11-23
499 reads
As installing SQL Server on Linux doesn’t install SQL Server command-line tools by default. So, you have to install it...
2017-11-23
768 reads
I recently worked on a project where a client wanted to use Biml to create SSIS packages to stage data...
2017-12-05 (first published: 2017-11-22)
1,285 reads
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2017-11-22
1,137 reads
In the grand scheme of things, MySQL and SQL Server operate in different realms. It’s difficult to compare them because...
2017-11-22
360 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