Quick Table Info Export with PowerShell
This week I had a user come to me asking about how fields were defined on a few tables he was using in writing some reports. Long story short,...
2018-05-18
25 reads
This week I had a user come to me asking about how fields were defined on a few tables he was using in writing some reports. Long story short,...
2018-05-18
25 reads
Every year, I spend the Sunday after SQL Saturday Rochester scanning & processing raffle tickets for our wonderful sponsors. Here’s how the system works:
Attendees get tickets (one ticket per...
2018-04-10
20 reads
A couple weeks ago Carlos L. Cachon (blog|twitter) put out a call on Twitter looking for SQL Saturday organizers to join him on the SQL Data Partners Podcast. When...
2018-03-08
15 reads
This month’s T-SQL Tuesday from Aaron Bertrand gives us a choice:
Life beyond the technical in a search for what Drew with the Burdensome Name calls #sqlibrium Your own T-SQL...
2018-02-13
18 reads
I need a new social media profile picture.
That’s one of the most important (non-technical) conclusions I drew from my week at PASS Summit 2017. It seemed like everywhere I...
2018-02-05
13 reads
I wrote a post over on the dbatools website about how to get involved with improving comment-based help
Working on the CBH is a great way to get started with...
2017-11-29
14 reads
In the course of testing a major upgrade, one of my users in Accounting happened upon a problem with one of her scenarios. The web app we were working...
2017-11-22
15 reads
I am very happy to announce that SQL Saturday returns to Rochester, NY on March 24, 2018. This is the Flour/Flower City’s seventh SQL Saturday and SQL Saturday #723...
2017-11-21
24 reads
This tweet showed up in the dbatools Slack channel Friday afternoon.
Just did my first Pull Request to "contribute" to @psdbatools. Granted, the code change was a single line of...
2017-11-18
15 reads
It’s time for T-SQL Tuesday and this month’s edition is hosted by Ewald Cress (blog|twitter). It’s non-technical this month because we’re all recovering from PASS Summit. Ewald asks us...
2017-11-14
21 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