Enable/Disable a table to be read only on the fly
Wouldn't be nice if we can set the "read only" property of any table to be on or off easily with one simple stored procedure call?
2013-07-30
16,821 reads
Wouldn't be nice if we can set the "read only" property of any table to be on or off easily with one simple stored procedure call?
2013-07-30
16,821 reads
When you're monitoring SQL Server, it's better to capture a baseline for those aspects that you're checking, such as workload, Physical I/O or performance. Once you know what is normal, then performance tuning and resource provisioning can be done in a timely manner before any problems becomes apparent. We can prevent problems by being able to predict them. Louis shows how to get started.
2013-07-30
4,688 reads
SQL Saturday is returning to St Louis for a full day of free SQL Server training and networking. This year's event will be on August 3, 2013 at the Saint Louis University's Center for Workforce & Organizational Development. We hope to see you there.
2013-07-30 (first published: 2013-06-26)
4,464 reads
Steve Jones presents some disaster stories with ideas on how you might prevent, or mitigate the effects, of those problem situations.
2013-07-29
210 reads
The report function, lookup, can be used to link two independent datesets.
2013-07-29
15,964 reads
With the massive number of servers running SQL Server within virtual machines (VMs), it's critically important for DBAs to understand the high availability options available when SQL Server is running within a VM.
2013-07-29
3,398 reads
This article contains a set of instructions for configuring SQL Server mirroring, including pre-requisites. It also includes notes on how to resolve a few issues that I have encountered.
2013-07-26 (first published: 2011-02-01)
22,916 reads
2013-07-26
659 reads
Although Windows PowerShell has been available to IT professionals going on seven years, there are still many IT pros who are just now deciding to see what the fuss is all about. Depending on your job, you might find PowerShell an invaluable tool. Microsoft's plan is that PowerShell will be the management tool for all of its servers and platforms. For most IT pros, it's not a matter of if you'll be using PowerShell, only a matter of when.
2013-07-26
4,024 reads
This article will show a way to find all SQL Servers, particularly those that have been forgotten about or lost.
2013-07-25 (first published: 2011-04-19)
15,713 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
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