Appearance: SQL Data Partners Podcast #161
Carlos Chacon (twitter) was kind enough to have me back on the SQL Data Partners Podcast to talk about my experiences with managing 8000 databases on a single instance...
2019-02-21
25 reads
Carlos Chacon (twitter) was kind enough to have me back on the SQL Data Partners Podcast to talk about my experiences with managing 8000 databases on a single instance...
2019-02-21
25 reads
I was recently working on a PowerShell script to set up some new databases for my users and found myself writing the same things over and over again.
1 2...
2019-02-04
35 reads
Way back in August, Matt Cushing (blog|twitter) was preparing to teach and asked for a list of “what do you wish you’d known when you started” items that he...
2019-01-21
30 reads
Like many folks using Wordpress, I post a tweet each time I publish a blog entry and that’s done automatically by Wordpress. In the Wordpress Classic Editor, there was...
2019-01-14
21 reads
In my previous post, I outlined the preparations we undertook to migrate a large SQL Server 2008R2 instance to SQL Server 2016. This post details migration day.
Final Prep We...
2019-01-09
27 reads
A bit over a year ago, I blogged about my experience migrating a test SQL Server instance from a VM to a physical machine with a little help from...
2019-01-07
22 reads
As we open 2019, I thought I’d take a moment to reflect on the past year.
Blogging 2018 was my biggest year of blogging yet! I published 28 posts and...
2019-01-02
11 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
Intro PowerShell has had a native method for spawning multiple “threads” ever since I can remember, in the form of the *-Job functions. They work OK, but there are...
2018-12-17
51 reads
Matt (blog | twitter) is preparing for his first SQL Saturday presentation next weekend in Washington, DC. He’s asked:
I wanted to get an idea of some good, bad, and...
2018-11-29
25 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