Unit testing with SQL Server article on SQLServerCentral.com
My “Unit testing with SQL Server” article is now online on SQLServerCentral.com. A big thanks goes to Steve Jones (@way0utwes).
You...
2015-03-26
286 reads
Unit testing with SQL Server article on SQLServerCentral.com
My “Unit testing with SQL Server” article is now online on SQLServerCentral.com. A big thanks goes to Steve Jones (@way0utwes).
You...
2015-03-26
667 reads
tSQLt with TRY..CATCH
Someone asked me the question recently about how tSQLt works with TRY..CATCH blocks and the exceptions that we might test...
2015-04-03 (first published: 2015-03-25)
8,299 reads
I am a Superhero
Two weeks ago I attended SQLBits in London. This is probably the biggest SQL Server conference in Europe, and this...
2015-03-25
620 reads
Toshiba Portege Z301-A Review
Last year I purchased a Lenovo W530. Nightmares then ensued. Nice laptop if you just want to use it as...
2015-03-25
626 reads
Clean out all bad characters from a string.
I have a customer who is having a problem with a load. He is getting a fair number of bad...
2015-03-25
1,117 reads
The Idea Book
How many times have you said to yourself, “Someone should build an application that does [x]…”, or “Wouldn’t it be...
2015-03-25
805 reads
Welcome to BlobEater
I am an IT Professional from the UK with a huge interest in MS technology especially SQL Server and Azure. During...
2015-03-25
323 reads
Gotcha! PowerShell Array Initialization, Difference between PowerShell 2.0 and 4.0
I like to initialize my arrays by strongly typing my variable as an array, and setting it to null. PowerShell...
2015-03-24
697 reads
Using New-TimeSpan to convert friendly time
The question was this:
This is just a quick/fast snippet in response to that question, but I can think of a...
2015-03-24
480 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
Question of the Day
Adding Bits I
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