Monday Morning SQL Break – September 19, 2016
It’s Monday and time for this week’s blog and twitter round-up. It’s been a few weeks since the last recap, apparently vacation a month and a half ago slowed...
2016-09-19
27 reads
Monday Morning SQL Break – September 19, 2016
It’s Monday and time for this week’s blog and twitter round-up. It’s been a few weeks since the last recap,...
2016-09-19
958 reads
Be a good administrator
Below are the topics every Administrator has to keep up with.
Backup / Restore:
Understand the backup / restore options SQL Server provides for...
2016-09-19
195 reads
Query Store and Plan Forcing: What Do You Use It For
If you’re working with Azure SQL Database or you’ve moved into SQL Server 2016, one of the biggest new tools...
2016-09-28 (first published: 2016-09-19)
1,261 reads
Power BI Custom Visuals Class (Module 17 – Sunburst)
In this module you will learn how to use the Sunburst chart Power BI Custom Visual. The Sunburst chart is...
2016-09-27 (first published: 2016-09-19)
1,913 reads
Using an ORDER BY in a view
For many years it’s been a best practice to never put an ORDER BY in a view. The idea is...
2016-09-26 (first published: 2016-09-19)
3,954 reads
Speaking at Suburban Chicago SQL Server Users Group Tomorrow
I will be presenting a technical session entitled ‘Virtual SQL Servers. Actual Performance‘ tomorrow evening for the Suburban Chicago SQL Server Users...
2016-09-19
366 reads
Building Oracle 12c on Linux 7 on Hyper-V
David has written a white paper, or short ebook titled building oracle 12C on Linux 7 VM residing on Hyper-V....
2016-09-19
463 reads
Books VS Internet
It’s is very easy to be
confused between investing in books or we should use the power of internet. If
you ask...
2016-09-19
243 reads
Distributed AG
going though Allan Hirt’s 24 SQLPASS recording, he has explained the new feature of SQL Server Availability group you can get...
2016-09-19
387 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...
Kantor Resmi BCA KCU PURWOKERTO Telp:0817°825°533
Telp/Wa 62817825533 Jl. Jend. Sudirman No.391 A, Brubahan, Purwanegara, Kec. Purwokerto Tim., Kabupaten Banyumas,...
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