Data Mining Introduction
Many people that work for years with SQL Server never use the Data Mining. This article has the objective to introduce them to this magic and exciting new world.
Legacy Limits
Sometimes the hardware or software we use prevents upgrades, which isn't necessarily good for any of us.
Development Delusions: That it is Enough to Build a Better Mousetrap
You've written a superb, clever, application that you are trying to encourage your colleagues to use. They're not interested. Why? You've neglected the documentation. Surely, the saying goes 'Build a better mousetrap and the world will beat a path to your door'? Nope, not without comprehensive and complete documentation and marketing, it won't. Documentation is the secret of ensuring that good software will succeed.
Keeping Fact Tables Online while Loading via Partition Switching
Provides overview of steps that can be used to keep fact tables online during loading process.
What's New in Reporting Services 2016 Service Pack 1
SQL Server 2016 was been released the first of June 2016, but at the recent Connect event Microsoft announced the first service pack. Aside from numerous fixes, this service pack also comes packed with some notable enhancements for Reporting Services. Koen Verbeeck gives you an overview of these enhancements.
Five Useful SQL Server Management Practices
This article outlines five SQL Server capabilities you can use to enhance your efficiency as a DBA.
Put your Database under Source Control
This article will walk you through a demostration on linking your DB to SubVersion with RedGate SQL Source Control.
SQL Server v.Next : STRING_AGG() performance
Aaron Bertrand takes an initial look at the performance of a new function, STRING_AGG, in SQL Server v.Next CTP 1.1.
Delaying Patches is Problematic
Many of our security issues come down to not patching software when there are updates available.
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
TempDB Facts I
Comments posted to this topic are about the item TempDB Facts I
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers