Find your Enabled SQL Server Network Protocols Using PowerShell
Another quick check I like to do when in 'discovery mode' on a client system is to see what network...
2011-05-21
2,175 reads
Another quick check I like to do when in 'discovery mode' on a client system is to see what network...
2011-05-21
2,175 reads
As a consultant I spend much of the first day or two at a client site discovering everything I can...
2011-05-20
1,335 reads
Lately I've been working on scripts to check and set security and configuration settings for SQL Server using PowerShell. One...
2011-05-19
5,895 reads
This year the Program Committee decided to open up the selection process to the community. I'm anxious to see how...
2011-05-11
872 reads
In working on applications at client sites you tend to come across code that makes you think "what were they...
2010-06-25
917 reads
A Twitter user asked for a script to remove old backups, and I had one I built back in February,...
2010-06-24
1,138 reads
SQL Saturday - Columbus, OH, June 26, 2010 I'll be presenting two sessions this Saturday (June 26, 2010) in Columbus, OH...
2010-06-23
638 reads
Last week I presented a couple of sessions at Tech Ed NA in New Orleans. It was a great experience,...
2010-06-13
749 reads
After finally getting a Service Broker solution implemented successfully, I'm really impressed with the technology, and frustrated how difficult it...
2010-04-03
916 reads
A while back I blogged about using Checklists , but there's another task you want to incorporate into your workflow - documentation....
2010-03-13
1,213 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