How to pass data between procedures using temp tables.
In this post I will show how in some cases we can split a long procedure to a small and...
2018-05-23
1,802 reads
In this post I will show how in some cases we can split a long procedure to a small and...
2018-05-23
1,802 reads
Hello!
Some weeks ago I got the tests working on the CI build for PoshSSDTBuildDeploy. The tests were a bit of a mish mash, however they sort of did the...
2018-05-23
41 reads
This article is an in-depth guide on how PowerShell can be used to maintain and manage SQL backup on Linux...
2018-05-31 (first published: 2018-05-22)
2,102 reads
I was able to present at SQL Saturday Dallas this year. Thanks to those of you who were able to...
2018-05-22
214 reads
I’m extremely proud to announce that I have been selected to present an all-new preconference training session on Friday, June...
2018-05-22
292 reads
I’ve been meaning to patch some of my development instances. With a little spare time while doing other work, I...
2018-05-22
335 reads
I was creating some demo non-clustered indexes in one of my Azure SQL Databases and received the following warning when...
2018-05-30 (first published: 2018-05-22)
1,898 reads
Occasionally I will come across the need to use PowerShell for my day to day activities. One such need came up this week when I was preparing to do...
2018-05-22
70 reads
Occasionally I will come across the need to use PowerShell for my day to day activities. One such need came...
2018-05-30 (first published: 2018-05-22)
2,203 reads
I have previously written about using Transparent Data Encryption (TDE) with Azure Key Vaule as a great way to store and manage encryption keys for SQL Server. With Azure...
2018-05-22
36 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