PowerShell – Change SQL Server Login Password
Here’s a quick post detailing a PowerShell script that can be used to change the password for a SQL Server...
2014-01-14
2,283 reads
Here’s a quick post detailing a PowerShell script that can be used to change the password for a SQL Server...
2014-01-14
2,283 reads
Here’s a quick post detailing a PowerShell script that can be used to change the password for a SQL Server Login. Regular readers know that I practice the philosophy...
2014-01-14
331 reads
I received a blog comment from a nice chap recently, concerning a subject that I’m often asked about and I wanted...
2014-01-07
1,591 reads
I received a blog comment from a nice chap recently, concerning a subject that I’m often asked about and I wanted to share my thoughts with you here. I only...
2014-01-07
32 reads
If you could give a DBA just one piece of advice, what would it be?
I asked 20 successful and experienced...
2013-12-16 (first published: 2013-12-10)
3,327 reads
If you could give a DBA just one piece of advice, what would it be? I asked 20 successful and experienced SQL Server professionals this exact question. You can...
2013-12-10
36 reads
This is a quick post to announce the winner of our competition for a FREE conference pass to SQL Server Live! in Orlando.
Those rather nice...
2013-10-30
1,378 reads
This is a quick post to announce the winner of our competition for a FREE conference pass to SQL Server Live! in Orlando. Those rather nice folks at SQL Server Live are also offering SQL Brit...
2013-10-30
22 reads
Taking responsibility for your own Professional Development and making it a priority is essential to being a successful Data Professional.
Courtesy...
2013-10-21
613 reads
Taking responsibility for your own Professional Development and making it a priority is essential to being a successful Data Professional. Courtesy SQL Server Live! I’ve got an outstanding opportunity for...
2013-10-21
27 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