Importing a BACPAC to SQL Server
We previously looked at Archiving Azure SQL Database to a BACPAC and in today’s post we are going to address...
2016-09-22 (first published: 2016-09-13)
64,950 reads
Statistics with TSQL and R: Chi Square Test
As I move on from descriptive and largely univariate (one variable based) analysis of data into more multivariate data – one...
2016-09-21 (first published: 2016-09-13)
4,639 reads
Top 5 Books for Database Developers
My Top 5 series of books has proved very popular. The first post titled Top 5 books for Enterprise Architecture was the...
2016-09-13
1,795 reads
DBCC CHECKFILEGROUP
Well, with the name “blobeater” it was about time I did another post on CHECKDB. This time I want to...
2016-09-14 (first published: 2016-09-13)
1,241 reads
World is changing so DBA should
I was going through SQLPASS recording and on first time I could see a session as “MongoDB for the SQL...
2016-09-13
388 reads
SQL Server 2016 In-Memory OLTP and After Trigger Support
SQL Server 2016 supports AFTER triggers! I could find no good example of how to do this with a project...
2016-09-12
773 reads
Azure Cognitive Services API’s with SQL Server 2016 CLR
[read this post on Mr. Fox SQL blog] Azure Cognitive Services is relatively new functionality within Azure that exposes some truly amazing APIs that have the ability to do some truly amazing...
2016-09-12
40 reads
Azure Cognitive Services API’s with SQL Server 2016 CLR
[read this post on Mr. Fox SQL blog]
Azure Cognitive Services is relatively new functionality within Azure that exposes some truly amazing APIs that...
2016-09-20 (first published: 2016-09-12)
2,119 reads
SQL Server Operations: Monitoring Disk Space with WMI and OLE Automation Objects
Abstract
This article talks about various SQL methods to fetch the disk usage details and use of T-SQL in conjunction with...
2016-09-20 (first published: 2016-09-12)
2,079 reads
The Clustered Index Is Vital To Your Database Design
This is post #9 supporting Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.
You get one clustered index per table.
That...
2016-09-19 (first published: 2016-09-12)
2,516 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 BCA KCU SOLO SLAMET RIYADI Telp:0817°825°533
Telp/Wa 62817825533 Jl. Brigjen Jl. Slamet Riyadi No.3, Kauman, Kec. Ps. Kliwon, Kota Surakarta,...
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