Activate Conference 2018: Presentation info
A special hello if you're visiting this blog post during or after my workshops on Thursday afternoon, February 22 at...
2018-02-22
328 reads
A special hello if you're visiting this blog post during or after my workshops on Thursday afternoon, February 22 at...
2018-02-22
328 reads
Today is the day that we have announced dbachecks a PowerShell module enabling you to validate your SQL Instances. You...
2018-02-22
1,121 reads
dbachecks is a new PowerShell module from the SQL Server Community! For more information, read introducing dbachecks. If you don't...
2018-02-22
512 reads
For the last couple of months, members of the dbatools team have been working on a new PowerShell module called...
2018-02-22
871 reads
For the last couple of months members of the dbatools team have been working on a new PowerShell module called dbachecks....
2018-03-07 (first published: 2018-02-22)
2,608 reads
If you’ve been careful and done everything right when you’re setting up TDE then you shouldn’t run into this problem.
We...
2018-02-21
3,641 reads
Last year I ran a series of posts about Database Fundamentals. Over the next few weeks, I will cover the...
2018-02-21
348 reads
Now that we have a basic understanding of RoundhousE database deployment from the first two parts of this series let’s get to the good stuff. If you haven't read...
2018-02-21
59 reads
If you’ve never worked with windowing functions they look something like this:
SELECT name, max(create_date) OVER
-- No this isn't meant to...
2018-02-21
1,493 reads
When applying a new SQL Server cumulative update, hot fix, or upgrade SQL Server doesn’t always apply all the fixes...
2018-02-21
1,293 reads
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...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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