Audit SQL Agent Jobs
One probably seldom thinks of the SQL Agent jobs scheduled on the SQL Server instance – unless they fail. What if...
2019-01-17
1,030 reads
One probably seldom thinks of the SQL Agent jobs scheduled on the SQL Server instance – unless they fail. What if...
2019-01-17
1,030 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2019-01-31 (first published: 2019-01-16)
3,765 reads
A few months ago, Microsoft announced that SQL Server Management Studio (SSMS) will no longer include the visual Database Diagrams...
2019-01-16
250 reads
SSMS is the most common tool used by SQL Developers or DBA’s but unfortunately there are some features that are...
2019-01-30 (first published: 2019-01-16)
3,266 reads
A magical thing happened this week in the SQL Community Slack (it’s free to join, by the way, sign up here). In the midst of a discussion about the...
2019-01-16
127 reads
Hello Dear Reader, just a quick check in, I had originally planned to blog yesterday. However, screen shots of apps made for a terrible looking blog.Fortunately I found that...
2019-01-16
31 reads
Hello Dear Reader, just a quick check in, I had originally planned to blog yesterday. However, screen shots of apps...
2019-01-16
238 reads
Unfortunately, due to a last minute scheduling conflict on my side, we’ve had to reschedule the data modeling webcast with...
2019-01-16
152 reads
I end up using the bcp utility to move tables between environments, and I’ve found that a lot of the...
2019-02-04 (first published: 2019-01-16)
3,230 reads
The other day I took a Microsoft Learn course about securing Azure SQL DB. It was really enjoyable and I...
2019-01-29 (first published: 2019-01-16)
2,267 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