T-SQL Tuesday #102: Giving Back
This is my diatribe about service and giving back to the community. When done properly, there is a natural born effect of enhancing one's personal life equal in some...
2018-05-09
15 reads
This is my diatribe about service and giving back to the community. When done properly, there is a natural born effect of enhancing one's personal life equal in some...
2018-05-09
15 reads
Last month we had the opportunity to discuss some of the most important tools for a data professional. I took...
2018-05-09
302 reads
I try to avoid dynamic SQL as much as possible and consider it as a necessary evil. However, in some...
2018-05-21 (first published: 2018-05-09)
2,541 reads
I had a requirement to run MySQL on a VSTS hosted build agent and then to be able to run...
2018-05-08
229 reads
I had a requirement to run MySQL on a VSTS hosted build agent and then to be able to run commands from outside of the container and this gave...
2018-05-08
20 reads
For a quick introduction to transaction isolation levels see my previous post on them.
Once snapshot isolation is enabled on a...
2018-05-08
2,462 reads
This month’s T-SQL Tuesday from Riley Major (b|t) asks us to figure out a way to give back to the...
2018-05-08
418 reads
It’s TSQL Tuesday again! This month our host is Riley Major (b/t) and the subject is Giving Back. He’s given us...
2018-05-08
244 reads
If you work with multiple windows or make a change using SSMS to an object, sometimes IntelliSense does not reflect...
2018-05-08
305 reads
Yesterday we discuss about different ways of options and configuring with environment variable which will place MySQL locate for values...
2018-05-08
238 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