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
Load Testing Results Might Not Be What You Think
Bottlenecks in your testing tools, infrastructure, or methodology might just hurt your load test results, and the results can skew...
2016-09-16 (first published: 2016-09-12)
1,328 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