Data-driven Prototypes
Phil Factor on a tale of how dodgy mock data derailed an otherwise-convincing prototype.
Install Visual Studio 2015 in Server without Internet Connection
Install Visual Studio 2015 in Windows Server without Internet Connection
Binary Files Import and Export
Importing binary files is always a challenge in SQL Server. New Author Sergey Benner brings us a technique using bulk loading that has worked well for him.
Disable or Drop
When you need to debug or troubleshoot, Steve Jones wants you to disable, not drop, objects.
Azure DWH part 23: Data Mining
SQL Server on-premises includes a module to create Data Mining models. We will show how to create them using ASDW.
Is This Data Science?
An analysis of salaries uses statistics to determine significance of the data. Is this data science?
Free eBook: SQL Server Internals: In-Memory OLTP
In this free ebook Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible.
How to Change the File Extension for a Data File
This is a fix to primary data file that is created with a different file extension or accidentally renamed to a different file extension
It's Time to Patch and Upgrade
With bugs in our CPUs, everyone needs to plan on patching or upgrading.
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers