DocumentDB Tutorial 2 – Working with Documents
Join Eitan Blumin in the next video of his DocumentDB Tutorials. This time learn how to work with the documents...
2016-02-18 (first published: 2016-02-11)
2,098 reads
Moving to Open Live Writer
I’ve used Windows Live Writer for almost as long as I’ve been blogging (mid 2007 or so). It’s worked well...
2016-02-11
791 reads
SQL Server Security Principals Lightning Round Presentation
Thanks for attending tonight's joint meeting of the Baton Rouge .NET/SQL/PowerBI User Groups, which was sponsored by Idera!
I presented a...
2016-02-10
387 reads
Azure SQL Database monitoring
Even though an Azure SQL Database stores all data on the Azure cloud, it does not mean that your options for managing...
2016-02-10
764 reads
CROSS APPLY v InLine Functions
While working on the Advent of Code problems in SQL, I ran across something interesting. Day 4 involves hashing, which...
2016-02-10
2,179 reads
How Bad Are Your Indexes?
In my last post "Copying SSIS packages With DTUTIL" I described a "gotcha" where the dynamic management views (DMVs) had...
2016-02-10
3,156 reads
Leadership and the Data Professional
Many traits make up data professionals and the many who find themselves in leadership roles. The traits being shared in...
2016-02-17 (first published: 2016-02-10)
1,824 reads
Changing to simple recovery to clear the log.
Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries...
2016-02-10
589 reads
View Getting Started with Power BI and Time Calculations with Dustin Ryan is Now Available!
Earlier today I had the pleasure of speaking with the PASS Business Intelligence Virtual Chapter on getting started with Power...
2016-02-09
927 reads
VMware vExpert 2016 Announcement
What an amazing week! VMware has announced the full list of VMware vExperts for the first half of the 2016 cycle, and I’m...
2016-02-09
469 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...
Layanan BCA KCP Mahendradata Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Mahendradatta Selatan No. 99 AX, Padangsambian, Kec. Denpasar Bar., Kota Denpasar, Bali...
Alamat Telp BCA KCP Sesetan Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Raya Sesetan No.301, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80223
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