Database Administration KPIs – 1/2
As a DBA, we may all have this question: How should my work be evaluated objectively? or in another way,...
2013-04-25
3,552 reads
As a DBA, we may all have this question: How should my work be evaluated objectively? or in another way,...
2013-04-25
3,552 reads
As a DBA, we may all have this question: How should my work be evaluated objectively? or in another way,...
2013-04-25
537 reads
According to Wiki, Procedural Justice (PJ) means:
Procedural justice is the idea of fairness in the processes that resolves disputes and...
2013-04-07
769 reads
According to Wiki, Procedural Justice (PJ) means:
Procedural justice is the idea of fairness in the processes that resolves disputes and...
2013-04-07
341 reads
Reading/scanning SQL Server Logs is a required DBA work item in all my work environments. I know there are lots...
2013-03-29 (first published: 2013-03-24)
2,615 reads
SQL Server SMO is a great resource for DBAs, unfortunately, before PowerShell, it is a pretty deep learning curve to...
2013-03-27 (first published: 2013-03-23)
2,730 reads
One challenge in a super-multiple server (say a few hundred servers) environment is to know what sql services (SSRS/SSAS/SSIS/Engine/Agent etc)...
2013-03-20
1,032 reads
One common surprise I have encountered in almost all my DBA environments is that a sql job that usually runs...
2013-03-17
948 reads
As a DBA, sometimes we may need to demonstrate to some stakeholders when a sql server instance was last rebooted,...
2013-03-14
1,189 reads
As a DBA in a complex environment, we frequently need to backup various environment information. One of the backups is...
2013-03-10
1,073 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...
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