Saw this on twitter and thought I would throw it up on the blog. Easier than responding on twitter.
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | Out-Null;
$SQLServerInstance...
2015-03-24
420 reads
My cheap and dirty PowerShell script for dumping the disk space usage for a Windows machine. It was originally some...
2015-03-24
477 reads
I’ve been a problem solver as far back as I can remember, always looking for a new challenge. I love...
2015-03-24
270 reads
So I was reading the following blog post by Brent Ozar and I think it finally hit me right between the...
2015-03-24
324 reads
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-03-24
720 reads
Have you written a TRY..CATCH statement in T-SQL? I hadn’t done it for most of my career, since the construct...
2015-03-24
1,202 reads
Simple paramaterization occurs when the optimizer determines that a query would benefit from a reusable plan, so it takes the...
2015-04-02 (first published: 2015-03-24)
6,985 reads
You may or may not have noticed it after installing SQL Server 2012: the designer interface in Visual Studio 2010/2012...
2015-03-24
763 reads
After SQL Saturday Pordenone, I’ll keep speaking about DLM (aka ALM on databases) during the following events:
PASS Italian Virtual Chapter, April 14. I’ll demonstrate...
2015-03-24
289 reads
After SQL Saturday Pordenone, I’ll keep speaking about DLM (aka ALM on databases) during the following events:
PASS Italian Virtual Chapter, April 14. I’ll demonstrate...
2015-03-24
558 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
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