Sharding: Horizontal Scaling in Azure SQL Database
David has produced a talk all about Sharding. Or if you prefer horizontally scaling your Azure SQL database.
You can view...
2018-10-19 (first published: 2018-10-04)
2,748 reads
David has produced a talk all about Sharding. Or if you prefer horizontally scaling your Azure SQL database.
You can view...
2018-10-19 (first published: 2018-10-04)
2,748 reads
On a previous post, we discussed what is an extended event (XE) and how to create one.With the following T-SQL you can quickly check what are the currently running...
2018-10-03
36 reads
Today I’d like to talk about the Azure Relational Data Services Platform. This is an important foundational component for many...
2018-10-03
747 reads
Someone sent me a link a few weeks back about a free book from Microsoft. It’s the Developer’s Guide to...
2018-10-12 (first published: 2018-10-03)
2,488 reads
Some time ago we started a new series here, called Database Fundamentals. The very first post in that series asked...
2018-10-03
305 reads
I recently set up Redgate’s SQL Change Automation in Visual Studio 2017, and I ran into a confusing error when I started trying to use it. For any other...
2018-10-03
40 reads
In this module you will learn how to use the Stacked Bar Chart by Akvelon. This version of the Stacked...
2018-10-09 (first published: 2018-10-03)
2,172 reads
PowerBI is a powerful reporting solution for Business Intelligence for analytical reports, it is not meant to replace SSRS, the focus of this tool is to be able to...
2018-10-03
26 reads
We all have the need to collect system and performance information regarding our SQL Servers. Some of us use third-party...
2018-10-17 (first published: 2018-10-03)
3,554 reads
As of October 2018, Azure SQL Database Managed Instance is now generally available in the general purpose tier. Business Critical...
2018-10-03
71 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...
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