2016-01-11
563 reads
SQL Server 2016 – whats new…lets see
Hey friends. I am here again with what’s new blog … Things are changing quite frequently and requirement is also changing....
2016-01-11
440 reads
Sudoku by SQL Part 2 of 3
The Challenge
Since I came across the first sudoku I was wondering if it could by solved by SQL using queries...
2016-01-10
373 reads
New Year Wish List for SQL Server Features
With SQL Server 2016 to be officially released this year, I want to make a wish list for the features...
2016-01-15 (first published: 2016-01-10)
1,716 reads
Sudoku by SQL Part 3 of 3
The Challenge
Since I came across the first sudoku I was wondering if it could by solved by SQL using queries...
2016-01-09
381 reads
Sudoku by SQL Part 1 of 3
The Challenge
Since I came across the first sudoku I was wondering if it could by solved by SQL using queries...
2016-01-09
455 reads
Creating a Matrix in Power BI With Multiple Values on Rows
This week I was asked to create a matrix in a Power BI report that looks like this:
Matrix with Values on...
2016-01-09
1,323 reads
We Want You!
It seems like PASS Summit 2015 was just yesterday and here we are again, getting ready for Summit 2016 already. ...
2016-01-08
427 reads
Advent of Code Day 1, Puzzle B
As I continue through the Advent of Code, albeit slowly, I’m solving each puzzle 3 days. I worked through 6...
2016-01-08
753 reads
Why is my SQL Server using all of the RAM on the server?
The TL;DR on this is simple:
"BECAUSE IT'S SUPPOSED TO!"
A frequent complaint we receive comes from a client that has an...
2016-01-14 (first published: 2016-01-08)
7,753 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