Exploring the Caves of Code Analysis in #SQLPrompt
I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes...
2018-04-25 (first published: 2018-04-16)
2,312 reads
I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes...
2018-04-25 (first published: 2018-04-16)
2,312 reads
DMV (Database Management View) and DMO (Database Management Objects) were added in 2005. There have been huge improvements in each...
2018-04-16
26,488 reads
Designing implementation of interface is as critical as designing interface itself. In this post we will discuss some advice on...
2018-04-14
1,325 reads
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2018-04-20 (first published: 2018-04-13)
2,432 reads
Not sure how or why this popped into my head (and too late for April Fools!), but it amuses me...
2018-04-13
476 reads
In my previous post I did my best explain a little bit what ITIL is and how important is for...
2018-04-13
258 reads
In some point of your career as DBA you might have interacted with ITIL or at least your heard about...
2018-04-13
274 reads
This blog post is about how brilliant dbatools are. In this case – for syncing user logins between SQL Server instances.
Background:
Whenever...
2018-04-13
1,069 reads
Every now and again we have to deal with a sudden requirements change. When that happens, we sometimes just need to take a step back and evaluate the entire...
2018-04-12
123 reads
One of my most favorite things in the world is the opportunity to deal with extremely varying database and environment...
2018-04-19 (first published: 2018-04-12)
2,753 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...
This is my late response to T-SQL Tuesday #204. I almost always forget about...
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