Connect to Power BI Report Server with SSMS
Sometimes you want to connect to a report server instance using Management Studio, for example to create a new security...
2018-05-11 (first published: 2018-05-02)
4,189 reads
Sometimes you want to connect to a report server instance using Management Studio, for example to create a new security...
2018-05-11 (first published: 2018-05-02)
4,189 reads
I’ve really got to make a plan here at some point. So far I’ve been just putting down things as...
2018-05-02
263 reads
In SQL Server the query optimizer uses a cardinality estimator to answer data SELECTIVITY questions like the ones below. The...
2018-05-02
411 reads
As a mini project I wanted to use Azure logic apps to pull tweets from my twitter account when people...
2018-05-02
351 reads
I’m converting some Firebird database code to T-SQL and I’m seeing a lot of code that doesn’t work in the...
2018-05-10 (first published: 2018-05-02)
2,919 reads
A few weeks ago I was presenting at SQL Saturday Raleigh and was asked a question that I didn’t know...
2018-05-09 (first published: 2018-05-02)
1,819 reads
I’m converting some Firebird database code to T-SQL and I’m seeing a lot of code that doesn’t work in the same way that SQL Server. No surprise - I...
2018-05-02
84 reads
This post is part 3 of a 3 part series…
Part 1 Grouping SetsPart 2 ROLLUP and CUBEPart 3 GROUPING and...
2018-05-01
64 reads
Unit testing using tSQLt is really great, you call FakeTable on any tables your code touches and then insert the...
2018-05-10 (first published: 2018-05-01)
3,023 reads
Unit testing using tSQLt is really great, you call FakeTable on any tables your code touches and then insert the columns and rows your test actually need, nothing more,...
2018-05-01
23 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