SSMS now has a vulnerability report
Security is an important and often overlooked function of technology. Don’t believe me? Go to a SQL conference and look...
2018-03-29
443 reads
Security is an important and often overlooked function of technology. Don’t believe me? Go to a SQL conference and look...
2018-03-29
443 reads
Sometime we create databases on Test/ Development database servers for temporary uses for short duration and forgot to delete them after the work got completed. As a part of...
2018-03-29
37 reads
Sometime we create databases on Test/ Development database servers for temporary uses for short duration and forgot to delete them...
2018-03-29
1,970 reads
There are many query sets out there to collect varying groups of configuration data - the ones I most frequently use...
2018-03-29
727 reads
I had three ideas I considered submitting this year:
Devops for the DBASQL ChecklistsLearning Plans v2I’ve presented the first topic a...
2018-03-29
280 reads
SQLServerCentral has been stuck in the past for some time, but we’ve finally decided to move. I’ve been asking for...
2018-03-28
1,480 reads
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...
2018-03-28
721 reads
This article is part of the SQL Server Tools series, aimed at giving you an idea of the available tools and techniques...
2018-03-28
1,027 reads
As a follow-up to my blog Is the traditional data warehouse dead?, I did a webinar on that very topic for...
2018-03-28
105 reads
As a follow-up to my blog Is the traditional data warehouse dead?, I did a webinar on that very topic for...
2018-03-28
415 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...
This is my late response to T-SQL Tuesday #204. I almost always forget about...
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