2016-04-05 (first published: 2011-12-05)
509 reads
2016-04-05 (first published: 2011-12-05)
509 reads
The oddest SQL practices can be done deliberately for good reason, but are there any that are always wrong, that are so bad that that their use should be prohibited as a matter of policy?
2016-04-04
175 reads
2016-04-01
143 reads
In an Azure SQL Database, you pay for a certain number of DTUs, but what are these? Steve Jones explains.
2016-04-01
2,737 reads
Today Steve Jones wonders if any of you are looking at the next version of our platform, SQL Server 2016.
2016-03-31 (first published: 2016-03-29)
307 reads
Today we have a guest editorial from Andy Warren that asks if the rest of you are intimidated by PowerShell.
2016-03-30
220 reads
It's possible to perform a man-in-the-middle attack against SQL Server. Steve Jones notes you should be aware these attacks could take place inside of your network.
2016-03-29
101 reads
The individual's dexterity can impact how we use software. Perhaps we need ways to undo mistakes in various systems.
2016-03-28
88 reads
2016-03-28
201 reads
Today Steve Jones talks about the issues with the sa account, and how you might protect this on all your instances.
2016-03-25
123 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...
Telp/Wa 62817825533 Jl. Suroyo No.28, Tisnonegaran, Kec. Kanigaran, Kota Probolinggo, Jawa Timur 67211
Telp/Wa 628217555651 Jl. Diponegoro No.68, Palraman, Dawuhan, Kec. Situbondo, Kabupaten Situbondo, Jawa Timur 68311
Comments posted to this topic are about the item Why Successful SQL Server Backups...
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