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
5 Must Haves Before You Start Consulting
Please join me at IT/Dev Connections on Oct. 12 at 8:00AM where I’ll be hosting a Birds of a Feather session “Moving to Independent Consulting” Bring your questions!*
Yes, an 8:00AM session in Las Vegas,...
2016-09-19
18 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