Confidence Intervals for a proportion – using R
What is the difference between reading numbers as they are presented, and interpreting them in a mature, deeper way? One...
2017-09-28 (first published: 2017-09-18)
1,333 reads
Mala Mahadevan
What is networking, really?
I am still trying to get up to speed on blogging after a gap. Today I managed to push myself...
2017-09-15 (first published: 2017-09-10)
1,583 reads
14 years of Summit…
I have been trying to get my blogging going again after a gap of two months. It has been incredibly...
2017-09-04
511 reads
Getting back to blogging
The past two months have been very hectic for me. I had an unexpected job offer towards end of July,...
2017-08-28
467 reads
Understanding Relative Risk – with T-SQL
In this post we will explore a common statistical term – Relative Risk, otherwise called Risk Factor. Relative Risk is a...
2017-06-21 (first published: 2017-06-19)
1,963 reads
Cochran-Mantel-Haenzel Method with T-SQL and R – Part I
This test is an extension of the Chi Square test I blogged of earlier. This is applied when we have...
2017-06-12
560 reads
Dataset for Cochran-Mantel-Hanzel Test
Below is the script to create the table and dataset I used. This is just test data and not copied...
2017-06-12
438 reads
Fischer’s Exact Test – with T-SQL and R
This post is a long overdue second part to the post on Chi Square Test that I did a few months...
2017-05-31 (first published: 2017-05-22)
1,479 reads
SQL Saturday Louisville precon – interview Andy Leonard
This will be year #9 of sql saturdays in Louisville. Every year (starting with 3rd or 4th), it has been...
2017-05-08
436 reads
The Birthday Problem – with T-SQL and R
When I was on SQLCruise recently – Buck Woody (b|t) made a interesting statement – that in a room of 23 people,...
2017-05-03 (first published: 2017-04-24)
1,922 reads
Blogs
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers