Toolbox - How Long Has My Server Been Up?
https://imgflip.com/i/2axp6yNo..not that Up (although it is awesome!)
--
As a remote service provider a common request is to follow up after a server...
2018-05-24
350 reads
https://imgflip.com/i/2axp6yNo..not that Up (although it is awesome!)
--
As a remote service provider a common request is to follow up after a server...
2018-05-24
350 reads
Securing SQL Server Database is a challenging task as there are number of external and internal risks or parameters affecting the Server and its databases. In this section, we...
2018-05-24
25 reads
Securing SQL Server Database is a challenging task as there are number of external and internal risks or parameters affecting...
2018-05-24
1,298 reads
Intro
I’m working on a solution where warehouse uses string codes as the keys for dimensions. Therefore the fact table is...
2018-05-23
118 reads
Microsoft state that enabling TDE (Transparent Data Encryption) usually has a performance overhead of 2-4%. That doesn’t sound like very...
2018-05-23
2,150 reads
Replication means making copy of the objects and moving transaction from primary server to secondary/standby/Slave server. There are two type...
2018-05-23
282 reads
I saw this from Argenis Fernandez, and thought it was wonderful.
1..128 | % { start-job -name ‘job name’ -scriptblock { & sqlcmd -S instanceName -U...
2018-05-23
825 reads
Last week I had the privilege of reviewing possibly the best SQL Server production environment I’ve seen in Canada. During...
2018-05-23
491 reads
A common misunderstanding is that the CONNECT permission lets you do more than just connect to a database. It doesn’t....
2018-05-23
489 reads
I gave a presentation at SQL Day in Poland last week on dbachecks and one of the questions I got...
2018-05-31 (first published: 2018-05-23)
3,076 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Telp/Wa 62817825533 Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111
Telp/Wa 628217555651 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates, Kabupaten...
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