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
Mala's Data Blog
SQL Saturdays – down memory lane
A casual twitter-conversation with Karla Landrum and some other peeps led me down memory lane on older events. Our SQL...
2017-05-01
422 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
Normal approximation to binomial distribution using T-SQL and R
In the previous post I demonstrated the use of binomial formula to calculate probabilities of events occurring in certain situations....
2017-04-17
1,429 reads
The Binomial Formula with T-SQL and R
In a previous post I explained the basics of probability. In this post I will use some of those principles to...
2017-04-17 (first published: 2017-04-10)
1,920 reads
Sampling Distribution and Central Limit Theorem
In this post am going to explain (in highly simplified terms) two very important statistical concepts – the sampling distribution and central...
2017-04-03
696 reads
Basics of Probability
In this post am going to introduce into some of the basic principles of probability – and use it in other posts...
2017-03-30 (first published: 2017-03-20)
4,508 reads
TSQL2sday – Daily database WTF
This month’s TSQL Tuesday is organized by Kennie T Pontoppidan(t) – the topic is ‘Daily Database WTF‘ – or a horror story...
2017-03-12
444 reads
Generating Frequency Table
This week’s blog post is rather simple. One of the main characteristics of a data set involving classes, or discrete...
2017-03-20 (first published: 2017-03-06)
8,347 reads
The Empirical Rule
I am resuming technical blogging after a gap of nearly a month. I will continue to blog my re learning...
2017-03-02 (first published: 2017-02-27)
2,515 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
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