PBM and PowerShell
The best new management feature added to SQL Server 2008 is Policy Based Management or PBM. PBM allows DBAs to...
2010-12-30
1,727 reads
The best new management feature added to SQL Server 2008 is Policy Based Management or PBM. PBM allows DBAs to...
2010-12-30
1,727 reads
The best new management feature added to SQL Server 2008 is Policy Based Management or PBM. PBM allows DBAs to...
2010-12-25
2,392 reads
For years we’ve been told you should use Enterprise Manager in SQL Server 2000 or SQL Server Configuration Manager in...
2010-12-13
3,196 reads
We’ve released a minor update to SQLPSX which includes several bug fixes as well as two new modules. Here’s an...
2010-12-11
779 reads
For years we’ve been told you should use Enterprise Manager in SQL Server 2000 or SQL Server Configuration Manager in...
2010-12-10
2,269 reads
A while ago I blogged about using xp_cmdshell to execute a PowerShell script in SQL Server and return a result...
2010-11-30
1,645 reads
Windows PowerShell has the concept of execution policy that determines in which cases script and configuration files are able to...
2010-11-30
1,310 reads
Windows PowerShell has the concept of execution policy that determines in which cases script and configuration files are able to...
2010-11-28
2,393 reads
As part of the 2.3 build of SQLPSX I built an MSI based installer to package all 10 SQLPSX modules....
2010-11-23
2,125 reads
I run several SQL Server instances on my laptop, however I’ll keep the services shutdown to conserve resources and then...
2010-11-19
423 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Comments posted to this topic are about the item Pay for Performance, which is...
Jl. PB.Sudirman No.40, Tekoan, Tanggul Kulon, Kec. Tanggul, Kabupaten Jember, Jawa Timur 68155
Jl. YOS Sudarso No.49, Dusun Kp. Baru, Jajag, Kec. Gambiran, Kabupaten Banyuwangi, Jawa Timur...
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