Creating Custom Databases with SQL Prompt
SQL Prompt has lots of great features that can help you write SQL quicker. However, you’ve got to train yourself...
2016-11-11 (first published: 2016-11-01)
1,681 reads
Stored Procedures Are Not Faster Than Views
A performance tuning tip I saw recently said, “Views don’t perform as well as stored procedures.”
<sigh>
Let’s break this down, just...
2016-11-09 (first published: 2016-11-01)
3,733 reads
SQL Server Infrastructure and Virtualization Boot Camp
I am proud to announce the availability of our new training offerings! We are launching a live web-based version of our...
2016-11-01
473 reads
Power BI Custom Visuals Class (Module 23 – Sparkline)
In this module you will learn how to use the Sparkline Power BI Custom Visual. The Sparkline allows you to...
2016-11-01
676 reads
Autumn Update - Trick or Treat
Its been a busy few weeks for me, most of that outside of gethynellis.com I’m in the process of moving...
2016-11-01
484 reads
CISL 1.4.0 is released
Another happy release of the CISL (Columnstore Indexes Script Library) is live – this time it is 1.4.0!
This release is focusing...
2016-11-07 (first published: 2016-11-01)
1,017 reads
SQL Server DMA – Data Migration Assistant V2.0
One of the benefits of twitter is that you get to hear about new tools quickly, one of the tools...
2016-11-01
681 reads
PASS Summit 2016 Wrapup
Last week I had one of the best experiences of my career – attending this year’s PASS Summit in Seattle. I...
2016-11-01
584 reads
Get Backup History for All Databases in Server
Here's a quick snippet to get a listing of the database backups that last occurred on a server. Most solutions...
2016-10-31
485 reads
Why Halloween slowed your queries
Let me start by saying that this isn’t your typical post about the Halloween problem. This is intended to describe...
2016-10-31
996 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers