Calculating DTU's for Azure SQL Database
One of my clients asked to calculate the DTU’s required for an existing database before migrating to Azure SQL Database....
2018-03-05
636 reads
One of my clients asked to calculate the DTU’s required for an existing database before migrating to Azure SQL Database....
2018-03-05
636 reads
One of my friend sent an email with the requirement to load balance the traffic coming from application to secondary SQL Server replicas in always on availability group. Read-only...
2018-03-05
26 reads
One of my friend sent an email with the requirement to load balance the traffic coming from application to secondary...
2018-03-05
669 reads
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2018-03-02
295 reads
My grandfather used to say, “There’s more than one way to skin a cat.” I always thought it was a...
2018-03-08 (first published: 2018-03-02)
4,823 reads
Hey! Here’s the latest on my YouTube Channel. Click on through and subscribe. I’ll be doing lots of stuff on...
2018-03-02
325 reads
If you encounter the following error trying to access reporting services:
User XXXX does not have required permissions. Verify that sufficient...
2018-03-02
283 reads
I’ve been playing with Data Masker for SQL Server v6 and it’s an interesting product. I like the way it...
2018-03-12 (first published: 2018-03-02)
2,288 reads
This wait type indicates that parallel plans execute on the server. This wait type doesn’t necessarily means there is a...
2018-03-02
866 reads
Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding...
2018-03-02
163 reads
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
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...
WhatsApp:0817819444 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates, Kabupaten Jember,...
WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
Comments posted to this topic are about the item Why Successful SQL Server Backups...
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