Some New Cool Features in SSMS
SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases and onward. Vulnerability Assessment (active from SSMS 17.4) Right...
2017-12-28
35 reads
SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases and onward. Vulnerability Assessment (active from SSMS 17.4) Right...
2017-12-28
35 reads
SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases and onward. Vulnerability Assessment (active from SSMS 17.4) Right...
2017-12-28
41 reads
SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases...
2017-12-28
947 reads
I’m done. No more trips (and no more time) to hit any events this year. As I wrote recently, I’m...
2017-12-28
638 reads
Several years back, when Extended Events was brand new, it was downright painful to try and convert the classic Profiler or Server Side trace to something meaningful and useful...
2017-12-28
13 reads
Several years back, when Extended Events was brand new, it was downright painful to try and convert the classic Profiler...
2017-12-28
243 reads
Several years back, when Extended Events was brand new, it was downright painful to try and convert the classic Profiler...
2017-12-28
559 reads
Affordances are a general design concept that comes from physical product design but can be applied to visual design. I...
2017-12-28
507 reads
Continuation from the previous 115 parts, the whole series can be found at http://www.nikoport.com/columnstore/
After delaying for a couple of years...
2017-12-28
529 reads
Exploring the wonderful case of a missing database backup.
I was working on a client’s site today, setting up database backup...
2017-12-27
579 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...
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