Who should own the database?
TL;DR; SA, or if you are really paranoid then you can create a disabled SQL login with minimal permissions and...
2018-01-25 (first published: 2018-01-15)
2,728 reads
TL;DR; SA, or if you are really paranoid then you can create a disabled SQL login with minimal permissions and...
2018-01-25 (first published: 2018-01-15)
2,728 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-01-24 (first published: 2018-01-15)
2,658 reads
I had an interesting issue last week. I had to rename non-domain (Workgroup) SQL Server Virtual Machine in Azure. The server...
2018-01-25 (first published: 2018-01-15)
7,294 reads
I decided to go to the SQL Saturday at Nashville this year to get some good learning and networking in...
2018-01-15
450 reads
Management of the database is very much essential in today’s date and for doing this, there is a need to...
2018-01-15
3,295 reads
Over the last couple of weeks I’ve been looking at various different locations around Dublin as my tenancy in the...
2018-01-15
279 reads
With technology expanding in both complexity and quantity, the task to name each component and functions of a technology product...
2018-01-24 (first published: 2018-01-15)
1,730 reads
Did you know that items in the Object Explorer can be dragged and dropped into a query window? This can...
2018-01-14
320 reads
We’re all used to using the clipboard in Windows programs. You copy something into it with Ctrl+C, and paste it...
2018-01-13
406 reads
This is day 2 of the Advent of Code 2017. If you want to read about the puzzles, start with...
2018-01-13
891 reads
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...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
WhatsApp:0817819444 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates, Kabupaten Jember,...
WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
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