Overview of SQL Server Backup Types
SQL Server backups, in itself, is a vast subject; so vast, there are multiple books written about them. In this...
2018-04-19
547 reads
SQL Server backups, in itself, is a vast subject; so vast, there are multiple books written about them. In this...
2018-04-19
547 reads
I have previously written about using Transparent Data Encryption (TDE) with Azure Key Vaule as a great way to store...
2018-04-30 (first published: 2018-04-19)
2,122 reads
In this module you will learn how to use the Drill-Down Donut Chart. The Drill-Down Donut Chart allows you to...
2018-05-01 (first published: 2018-04-19)
3,526 reads
In the previous blog, we discussed the Foreign Keys Constraints and how the CHECK Constraints are useful to verify the...
2018-04-30 (first published: 2018-04-19)
3,182 reads
This script is from my library and I use it to review what is going on with my transactional replications, try to remove statements that didn't get purged for...
2018-04-18
54 reads
There’s a new feature in Azure, and I stumbled on it when someone posted a link on Twitter. Apologies, I...
2018-04-27 (first published: 2018-04-18)
3,334 reads
The client reported that the log file on their main database was growing unusually large, and when they checked the...
2018-04-27 (first published: 2018-04-18)
4,161 reads
Last time, we began an in-depth look at how time is measured. This post continues our journey. If any of...
2018-04-18
503 reads
SSMS (and other SQL Server utilities) utilize a batch separator to, well, separate batches of T-SQL statements. Before we go...
2018-04-18
2,170 reads
This script is from my library and I use it to review what is going on with my transactional replications,...
2018-04-18
471 reads
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...
This is my late response to T-SQL Tuesday #204. I almost always forget about...
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