SSMS 17.4 Vulnerability Assessment
SSMS 17.5 is out as of February 2018, but the the Vulnerability Assessment (VA) was released in SSMS 7.4
It seems...
2018-03-14 (first published: 2018-03-05)
2,446 reads
SSMS 17.5 is out as of February 2018, but the the Vulnerability Assessment (VA) was released in SSMS 7.4
It seems...
2018-03-14 (first published: 2018-03-05)
2,446 reads
There is no better way to see the art of the possible with the cloud than in use cases/customer stories...
2018-03-05
82 reads
There is no better way to see the art of the possible with the cloud than in use cases/customer stories...
2018-03-05
323 reads
All the execution plans are estimated plans. All of them. There fundamentally isn’t any such thing as an “Actual” plan.
Where...
2018-03-14 (first published: 2018-03-05)
1,835 reads
My very first SQL Homework post was about taking a backup. The vast majority of people who work with databases...
2018-03-05
305 reads
One of the joys of working with SQL Server is the descriptive and meaningful error messages, right?
https://vignette.wikia.nocookie.net/batmantheanimatedseries/images/a/a7/DiD_39_-_Joker_Vision.jpg/revision/latest?cb=20160610021326
Exhibit A - the 33206:
Error:...
2018-03-13 (first published: 2018-03-05)
16,991 reads
Determine Free Space In SQL Server DatabaseIn our previous section we have discussed about Using Stored Procedures in SQL Server For Better Performance and know various advantages of using...
2018-03-05
33 reads
Determine Free Space In SQL Server Database
In our previous section we have discussed about Using Stored Procedures in SQL Server...
2018-03-05
49,888 reads
Foreign key constraints put the “relation” into relational databases. They enforce integrity by requiring that a key value referencing another...
2018-03-05
483 reads
One of my clients asked to calculate the DTU’s required for an existing database before migrating to Azure SQL Database. Pricing Azure SQL Database is different from traditional SQL...
2018-03-05
25 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