AlwaysOn: Configuring Secondary Read-Only Access
Now that you have AlwaysOn configured and your first Availability Group (AG) created, it’s time to start leveraging those secondary...
2012-02-10 (first published: 2012-02-08)
10,345 reads
Now that you have AlwaysOn configured and your first Availability Group (AG) created, it’s time to start leveraging those secondary...
2012-02-10 (first published: 2012-02-08)
10,345 reads
Now that you have AlwaysOn configured and your first Availability Group (AG) created, it’s time to start leveraging those secondary...
2012-02-08
1,116 reads
I have been quiet over the past year trying to get acclimated to my new job and my new found work...
2012-02-03 (first published: 2012-02-02)
1,415 reads
I have been quiet over the past year trying to get acclimated to my new job and my new found...
2012-02-02
401 reads
During a recent customer engagement I was asked if it was possible to ensure that the colors in a Line...
2012-01-10
1,620 reads
I am excited to announce that I will be giving a virtual presentation to the Knoxville SQL Server User Group. ...
2012-01-04
1,004 reads
If you are in and around Dallas next week drop by my FREE half-day Business Intelligence workshop. The details are...
2011-11-01
1,689 reads
One of the less advertised enhancements of SSIS in SQL Server 2012 is the Project Reference type available when using...
2011-10-24
3,251 reads
So recently I was doing a demonstration using the new SQL 2012 SSIS running in Visual Studio 2010. I needed...
2011-10-13
32,479 reads
When working at large organizations with several users, managing security using Windows or SQL authentication could be challenging. However, there...
2011-10-13
9,821 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