Quick Blog: Making the Power BI PowerShell cmdlets easier to use
One of the top reasons I love PowerShell so much is that from the beginning, it was designed to let you, yes you, make it run better for the...
2019-09-19
51 reads
One of the top reasons I love PowerShell so much is that from the beginning, it was designed to let you, yes you, make it run better for the...
2019-09-19
51 reads
One of the top reasons I love PowerShell so much is that from the beginning, it was designed to let you, yes you, make it run better for the...
2019-09-27 (first published: 2019-09-19)
691 reads
I was talking with a couple of excellent SQL people* recently, and we were bemoaning the difficulties and disciplines of blogging. This is what speakers do after a successful SQL...
2019-09-19
46 reads
This is something I touched on back in 2017 a little after the Live Query Statistics feature was introduced with SQL 2016, but I was using the functionality this...
2019-09-26 (first published: 2019-09-18)
1,953 reads
In my home lab I have an Ubuntu virtual machine that runs both SQL Server 2017 and SQL Server 2019 in Docker containers. After SQL Server 2019 Release Candidate...
2019-09-18
86 reads
I am not sure when this became available but for Azure SQL Database 150 compatibility level is now available. Last time I created a database few weeks ago, only...
2019-09-18
73 reads
When studying Azure one of the things you’ll be asked to learn is the Powershell commands that can control, well, ... Continue reading
2019-09-18
86 reads
I’ve written about statistics in SQL Server a few times now. Through conversations I am reminded that not everyone keeps their table statistics up to date. Keeping your statistics...
2019-09-26 (first published: 2019-09-18)
518 reads
Recently I noticed that Microsoft uploaded a new dockerfile to the mssql-docker repository on Github. This dockerfile was under the mssql-server-linux-non-root directory and (you guessed it) allows SQL Server...
2019-09-25 (first published: 2019-09-18)
1,012 reads
This is the sixth interview we have done. This time our guest is Greg Low! I bet you know Greg as he is one of the most recognizable person...
2019-09-17
21 reads
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