Moving to WordPress.com
For years I’ve hosted WordPress somewhere, most recently in Azure using Project Nami so that I could store all the...
2017-01-08
402 reads
Blog Posts
Columnstore Indexes – part 95 (“Basic Query Patterns”)
Continuation from the previous 94 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In this blog post I am continuing...
2017-01-07
501 reads
Checking Permissions for Keys–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-01-06 (first published: 2016-12-29)
1,846 reads
Columnstore Indexes – part 94 (“Use Partitioning Wisely”)
Continuation from the previous 93 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post will talk about some...
2017-01-06
588 reads
Data Channel - Interview 02 - Hamid Fard on SQL Server Memory Capacity Planning
Dear All,
Welcome to the second interview of Data Channel. Very happy and proud to have Mr Hamid Fard, MVP and...
2017-01-06 (first published: 2016-12-31)
1,848 reads
Friday Reading 2017-01-06
Happy New Year to all of you out there! I know, I know it’s a week late but hey I’ve...
2017-01-06
347 reads
New String Function – TRIM – in SQL Server vNext
As SQL developer, you must have often come across a scenario where you need to remove the empty spaces at...
2017-01-06
2,090 reads
Refreshing the SQL Server PowerShell Provider
Sometimes SSMS gives you stale results and there you have the Refresh button to fix that. In SQL PowerShell, the same situation can arise where the SQL Server PowerShell...
2017-01-06
21 reads
Refreshing the SQL Server PowerShell Provider
Sometimes SSMS gives you stale results and there you have the Refresh button to fix that. In SQL PowerShell, the same situation can arise where the SQL Server PowerShell...
2017-01-06
19 reads
Refreshing the SQL Server PowerShell Provider
Sometimes SSMS gives you stale results and there you have the Refresh button to fix that.
In SQL PowerShell, the same...
2017-01-06
551 reads
Blogs
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...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
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...
Adding Bits I
Comments posted to this topic are about the item Adding Bits I
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