Powershell and Dynamic SSIS (or any for that matter) Config files
As I imagine that the majority of people who are reading this will have some level of SSIS knowledge, I’ll...
2011-12-05
1,234 reads
As I imagine that the majority of people who are reading this will have some level of SSIS knowledge, I’ll...
2011-12-05
1,234 reads
On my list of things to get done this week is register for SQLRally 2012 in Dallas. It’s a quick...
2011-12-05
504 reads
Earlier this year, I wrote a post about my upcoming plans for the year in response to a question asked...
2011-12-05
1,609 reads
The SQL Server 2012 Developer Training Kit has been updated with a bunch of new content (download it here). This...
2011-12-05
1,135 reads
When I started looking into the upgrade path for this, I saw a couple of notes online about the fact...
2011-12-05
807 reads
After installing the WAN optimization appliances on all of our main sites, we have liked what we’ve seen thus far....
2011-12-05
692 reads
What is a brilliant gift at Christmas for a DBA? I mean apart from having the day off…..
For those new...
2011-12-05
601 reads
I will be presenting a day long preconference session on Scaling SQL Server for SQLSaturday #104 on Friday, January 6,...
2011-12-04
875 reads
Without looking, name your most important server. Or if you have a bunch, name the top 2 or 3.
Now tell...
2011-12-04
948 reads
Hi guys.
The procedure bellow get the data and log size of all databases in current instance.
CREATE PROCEDURE dbo.uspDatabaseSize
AS
declare...
2011-12-03
1,958 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