Misleading errors: “Server is configured for Windows authentication only.” But it’s not!
In general, the errors SQL gives are highly useful. Of course every now and again you get one that’s just...
2018-06-18
805 reads
In general, the errors SQL gives are highly useful. Of course every now and again you get one that’s just...
2018-06-18
805 reads
In this module you will learn how to use the PowerApps Custom Visual. The PowerApps visual allows you to embed...
2018-06-18
682 reads
Recently, there are have been a few articles about the lack of adoption of Query Store. Note the following:
Brent Ozar...
2018-06-17
78 reads
Recently, there are have been a few articles about the lack of adoption of Query Store. Note the following:
Brent Ozar...
2018-06-28 (first published: 2018-06-17)
2,347 reads
New SQL blogger
Jamie at the 45th Parallel (South) – New Zealand
This post is just a quick shout-out. My friend and co-leader...
2018-06-15
352 reads
If you are like me, you use the SSMS GUI for various things. Though, I tend to use scripts for...
2018-06-27 (first published: 2018-06-15)
1,189 reads
SQLite is one of the most commonly used database engine. Its source code is available in public domain which can be used for commercial or private purpose. Common data...
2018-06-15
235 reads
SQLite is one of the most commonly used database engine. Its source code is available in public domain which can...
2018-06-15
35,867 reads
Now that I have your attention with a powerful title how about some context? It is quite common to get...
2018-06-26 (first published: 2018-06-15)
2,310 reads
As a remote DBA I often have to log in to client systems for a fixed amount of time and...
2018-06-27 (first published: 2018-06-15)
14,222 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...
Telp/Wa 62817825533 Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111
Telp/Wa 628217555651 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates, Kabupaten...
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