Azure SQL Database Script for Size
Sometimes you may not want to flip over to the Azure portal to grab the database size, such as the used space below. So here is a handy script...
2019-08-12
34 reads
Sometimes you may not want to flip over to the Azure portal to grab the database size, such as the used space below. So here is a handy script...
2019-08-12
34 reads
This is the fourth article of the Machine Learning topic. I have introduced you to the Machine Learning, described the process and the tools. My first idea was that...
2019-08-24 (first published: 2019-08-11)
61 reads
You may sometimes have reports or other processes that are dependent on transactional replication being current. If that is the case, you will probably need a mechanism to check...
2019-08-09
38 reads
Hiring at Basecamp is interesting. I caught this interview and think it’s a good look at a process most of us have gone through, but perhaps not thought about....
2019-08-09
40 reads
I have been looking into this feature and also into understanding graph data in general. I believe introduction of graph database feature in SQL Server has many advantages –...
2019-08-22 (first published: 2019-08-09)
859 reads
I did a couple of recent podcasts that I wanted to mention: The first one was with Kirby Repko from the YouTube channel SQLTalk: Modern Data Warehouse Design with...
2019-08-23 (first published: 2019-08-08)
491 reads
When Memory-Optimized Tables (MOT) were announced for SQL Server, there was a lot of excitement about the technology. After this was released on SQL Server 2014, feelings waned with...
2019-08-08
69 reads
Lately, I have been using SSIS execution frameworks and Biml created by other people to populate data marts and data warehouses. It has taught me a few things and...
2019-08-20 (first published: 2019-08-08)
1,205 reads
I have read quite a bit about “the death of Big Data” recently. To be
honest I’ve never liked the term Big Data. It has always skewed people’s
thinking...
2019-08-08
36 reads
I have read quite a bit about “the death of Big Data” recently. To be
honest I’ve never liked the term Big Data. It has always skewed people’s
thinking...
2019-08-08
36 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