Determine database version from a bak file
Have you ever imagine you can determine the version of SQL Server from a bak or a MDF file? I...
2018-11-26 (first published: 2018-11-15)
18,534 reads
Have you ever imagine you can determine the version of SQL Server from a bak or a MDF file? I...
2018-11-26 (first published: 2018-11-15)
18,534 reads
In my previous blog post of this topic, I talked about the definition of what GDPR is and also described...
2018-11-09 (first published: 2018-10-30)
3,504 reads
A couple of weeks ago, Microsoft released a new multi-platform tool called Azure Data Studio, this tool is the final...
2018-10-18 (first published: 2018-10-09)
2,580 reads
Have you ever wanted SSMS to start and automatically and establish a connection to your DBA \ hub server and have...
2018-10-15 (first published: 2018-10-02)
7,915 reads
I’m very thrilled to announce that I will be participating as speaker in Denver’s SQL Saturday that will take place on...
2018-09-07
334 reads
Query Store is a very powerful tool for performance tuning, if you are not using it already you should!! It...
2018-08-29 (first published: 2018-08-13)
2,102 reads
Every time I conduct a SQL Server health check, it’s pretty common for me to find wrong configurations at instance...
2018-08-28
14,374 reads
Good news for all the Guatemalan data professionals, starting from August 2018 you have an official PASS SQL Server local...
2018-08-23
306 reads
I really like Microsoft philosophy nowadays, they are putting a lot of time developing good open source tools like SQLCLI,...
2018-08-10 (first published: 2018-08-07)
3,560 reads
06/21 was the date that marked my career as data professional, for the first time ever I decided to participate as...
2018-08-01
270 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