2022-09-09
601 reads
2022-09-09
601 reads
In this article we look at how to import and export connection information for servers in SQL Server Management Studio for backup and to move to another installation of SSMS.
2022-07-04
Learn different ways to recover a T-SQL script when using SQL Server Management Studio if SSMS is accidently shutdown without saving the script.
2022-06-13
2,245 reads
This article explores how to create and use views in SQL Server 2019 using SSMS.
2021-12-27
7,379 reads
Introduction I have to admit that I love SSMS. It is a great tool, and I felt furious when a colleague mentioned that Azure Data Studio will replace SSMS in the long run. In this new article, we will talk about the main differences between Azure Data Studio and SSMS. We will see if my […]
2021-11-10
26,761 reads
2021-04-22
572 reads
In this article we look at several ways to find the version of SQL Server that is installed when the SQL Server service is not running.
2021-01-12
In this article we look at how to resolve the error database diagram support objects cannot be installed because the database does not have a valid owner.
2021-01-01
SSMs and ADS are the new tools for SQL Server and the data platform, both of which are now available separately from SQL Server.
2020-11-02
587 reads
In this article we look at how to build a custom stored procedure template that can be used in either SSMS or Visual Studio for all new development.
2020-10-29
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
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...
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