Simply Debugging
Debugging is a life skill. Yes, the term comes from IT (literally removing a bug from a computer believe it...
2018-03-19 (first published: 2018-03-07)
2,074 reads
Debugging is a life skill. Yes, the term comes from IT (literally removing a bug from a computer believe it...
2018-03-19 (first published: 2018-03-07)
2,074 reads
SQL Server Management Studio (SSMS) 2016 has a handy new feature to View Live Query Statistics. This feature also works...
2018-03-07
193 reads
This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing workloads and doing analysis on them. T-SQL or other...
2018-03-06
20 reads
This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing...
2018-03-06
301 reads
Today is the day that Azure SQL Database Managed Instance is available for the world to explore. Private preview means...
2018-03-06
310 reads
One sale today, my Getting Started with SQL Server 2016 Administration video. You can get this for $10 today, and...
2018-03-06
347 reads
I’ve been playing with Data Masker for SQL Server v6 and it’s an interesting product. I like the way it...
2018-03-06
392 reads
Disclaimer: I’m one of the Technical Reviewers for this book.
With the rising demand for cloud computing and wide adaptation of...
2018-03-19 (first published: 2018-03-06)
2,722 reads
In this post and video you will learn how to identify the owner and then change the owner of a...
2018-03-16 (first published: 2018-03-06)
22,067 reads
Azure SQL DB is a robust data platform that’s cloud native and can be managed from SQL Server Management Studio...
2018-03-06
442 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