Quick and Easy XE for Azure DB
The Cloud
It has been a minute since I gave much love or attention to Extended Events in Azure SQL DB....
2019-01-07 (first published: 2018-12-24)
1,509 reads
The Cloud
It has been a minute since I gave much love or attention to Extended Events in Azure SQL DB....
2019-01-07 (first published: 2018-12-24)
1,509 reads
In my previous post, I mentioned that I wasn’t checking the status of my RSJobs because I had logging built into my function. I originally tried to log out...
2018-12-24
88 reads
The Christmas is coming. But before we start the festive time and sit down to the Christmas Eve dinner – a...
2018-12-23
212 reads
Orlando Code Camp is March 30. 2019 in Lake Mary (same location as SQLSaturday Orlando) and we’re hoping to have...
2018-12-22
265 reads
More and more tools are becoming available for data analysts and data scientists. These tools provide convenience and lower the bar...
2019-01-03 (first published: 2018-12-22)
2,464 reads
I got a chance to work with PowerShell automation script to automate the login process. In the script, the profile...
2018-12-21
267 reads
2018 is about to end. In the case you didn't know or haven't heard, the extended support for SQL Server 2008 (and R2) reaches to an end in 2019.
This...
2018-12-21
52 reads
More and more I am impressed on the Azure Portal. Microsoft continues to make enhancements to the user interface (UI)...
2018-12-21
258 reads
Max Degree of Parallelism is a setting that is often changed to improve performance in SQL Server. What exactly does...
2019-01-07 (first published: 2018-12-21)
2,802 reads
2018 is about to end. In the case you didn't know or haven't heard, the extended support for SQL Server...
2018-12-21
399 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