My alternative to sp_WhoIsActive
I use sp_WhoIsActive a lot. I’m extremely grateful for Adam Machanic writing it. It has tons of options that let...
2019-01-28
5,393 reads
I use sp_WhoIsActive a lot. I’m extremely grateful for Adam Machanic writing it. It has tons of options that let...
2019-01-28
5,393 reads
We’ve had backup encryption out of the box since SQL Server 2014, yet I’ve rarely seen it used. In an...
2019-02-19 (first published: 2019-01-28)
12,038 reads
In this article I’ll be discussing the benefits of using a consistent unknown member key across your data warehouse. And...
2019-02-18 (first published: 2019-01-28)
4,042 reads
As we studied the basics of Docker and container and containerization , Docker – is a open-source platform to have multiple light...
2019-01-28
432 reads
Maybe more people would use the Central Management Server feature of Management Studio if it had a name that didn’t sound as utilitarian as a heat pump. Something like...
2019-01-28
21 reads
Maybe more people would use the Central Management Server feature of Management Studio if it had a name that didn’t sound as utilitarian as a heat pump. Something like...
2019-01-28
25 reads
(2019-Jan-28) When you work with maps using ArcGIS visual in Power BI, you always have a feeling that it is a...
2019-02-15 (first published: 2019-01-28)
3,035 reads
Hello guys, a few internet posts that you might find interested. Press Azure SQL Analytics—Automating Deployment Apparently, it wasn’t an...
2019-01-27
191 reads
Notes:
We had 17 register and 8 attend our first lunch meetup of the year at Fuzzy’s Tacos Great venue. $10...
2019-01-26
225 reads
Last year (the first filing) I had my accountant do the filing for SQLOrlando, but this year I wanted to...
2019-01-26
175 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