SQL Split String Function (STRING_SPLIT in 2016)
* originally published in our old blog in August 2011 - updated with SQL Server 2016 reference
As a SQL Server developer you...
2016-11-01
1,047 reads
PASS Summit Announcements: Azure Analysis Services
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. I’m writing a set...
2016-11-01
849 reads
Creating Custom Databases with SQL Prompt
SQL Prompt has lots of great features that can help you write SQL quicker. However, you’ve got to train yourself...
2016-11-11 (first published: 2016-11-01)
1,685 reads
Stored Procedures Are Not Faster Than Views
A performance tuning tip I saw recently said, “Views don’t perform as well as stored procedures.”
<sigh>
Let’s break this down, just...
2016-11-09 (first published: 2016-11-01)
3,743 reads
SQL Server Infrastructure and Virtualization Boot Camp
I am proud to announce the availability of our new training offerings! We are launching a live web-based version of our...
2016-11-01
479 reads
Power BI Custom Visuals Class (Module 23 – Sparkline)
In this module you will learn how to use the Sparkline Power BI Custom Visual. The Sparkline allows you to...
2016-11-01
682 reads
Autumn Update - Trick or Treat
Its been a busy few weeks for me, most of that outside of gethynellis.com I’m in the process of moving...
2016-11-01
485 reads
CISL 1.4.0 is released
Another happy release of the CISL (Columnstore Indexes Script Library) is live – this time it is 1.4.0!
This release is focusing...
2016-11-07 (first published: 2016-11-01)
1,024 reads
SQL Server DMA – Data Migration Assistant V2.0
One of the benefits of twitter is that you get to hear about new tools quickly, one of the tools...
2016-11-01
684 reads
PASS Summit 2016 Wrapup
Last week I had one of the best experiences of my career – attending this year’s PASS Summit in Seattle. I...
2016-11-01
586 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
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...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan Resmi BCA KCP Tanggul Hub/Wa. 0817-819-444
Jl. PB.Sudirman No.40, Tekoan, Tanggul Kulon, Kec. Tanggul, Kabupaten Jember, Jawa Timur 68155
Layanan BCA KCP Jajag Hub/Wa. 0817-819-444
Jl. YOS Sudarso No.49, Dusun Kp. Baru, Jajag, Kec. Gambiran, Kabupaten Banyuwangi, Jawa Timur...
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