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...
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
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