Be Cautious About Invoke-SqlCmd Bug
With PowerShell becoming more popular in daily DBA work, I’d like to mention one huge ugly bug I recently encountered...
2015-10-25
2,050 reads
With PowerShell becoming more popular in daily DBA work, I’d like to mention one huge ugly bug I recently encountered...
2015-10-25
2,050 reads
With PowerShell becoming more popular in daily DBA work, I’d like to mention one huge ugly bug I recently encountered...
2015-10-25
371 reads
According to Wikipedia:
Crowdsourcing is the process of obtaining needed services, ideas, or content by soliciting contributions from a large group...
2015-05-25
691 reads
According to Wikipedia:
Crowdsourcing is the process of obtaining needed services, ideas, or content by soliciting contributions from a large group...
2015-05-25
343 reads
Today, I am excited and humbled to learn that I am awarded “Rookie of the Year – 2014” by MSSQLTips.com.
I have...
2015-01-14
691 reads
Today, I am excited and humbled to learn that I am awarded “Rookie of the Year – 2014” by MSSQLTips.com.
I have...
2015-01-14
333 reads
I recently had an opportunity to write an article for mssqltips.com on managing registered servers under “local server groups”, and...
2014-06-07
3,207 reads
As once a data architect, I cannot help but admiring and appreciating the data model behind the sql server job...
2014-04-07
1,586 reads
Recently I was working on a task that needs to handle various datetime calculations, and it is really fun.
Usually there...
2014-03-12 (first published: 2014-03-02)
4,613 reads
Recently I was working on a task that needs to handle various datetime calculations, and it is really fun.
Usually there...
2014-03-02
740 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