Password-less Authentication for Azure AD Guest Accounts with Azure SQL DB with Access Tokens
Learn how we can generate tokens that will give access to resources inside Azure without actually adding new users to your domain.
2019-07-01
2,710 reads
Learn how we can generate tokens that will give access to resources inside Azure without actually adding new users to your domain.
2019-07-01
2,710 reads
John Morehouse describes how a quest to help solve his organization's "deployment bottleneck" led them to a place where they could both deliver application and database changes into the wild at a pace to satisfy customer demand, and achieve a better work-life balance for the team, both of which are well worth having.
2019-07-01
In this article, Kellyn Pot’Vin-Gorman continues teaching SQL Server DBAs how to navigate Linux. She demonstrates usings aliases, setting up environment variables, and examining processes.
2019-07-01
This article will give a brief overview of how statistics are generated, stored, and used in SQL Server.
2019-06-28 (first published: 2017-10-17)
9,263 reads
In this article, we discuss how to load large partition tables incrementally.
2019-06-28 (first published: 2017-10-13)
2,580 reads
Brent Ozar gives some advice to those of you who give presentations to user groups and conferences.
2019-06-28
Learn a bit about the different results you get from the PERCENT_RANK and CUME_DIST aggregate functions.
2019-06-27
13,544 reads
One of the most profound challenges faced by technology companies today is talent. According to the latest Harvey Nash survey, 65% of CIOs believe that a shortage of tech skills is affecting their ability to respond to change.
2019-06-27
There is quite a bit of suffering within tech and caused by tech, from poorly commented code to shaming someone who asks a question on a forum. In this article, Samuel Nitsche explains why compassionate coding is a better way to go.
2019-06-27
In this tip we look at a PowerShell script you can use to collect index information for all of your SQL Server instances that you manage.
2019-06-26
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