Use PowerShell to automate your Azure DB creation
Why create your databases manually if you don’t have to? If there is one thing that I hate to do...
2016-07-20
849 reads
Multi-tenant databases in the cloud
For companies that sell an on-prem software solution and are looking to move that solution to the cloud, a challenge...
2016-07-20
1,183 reads
The new SQL Server Management Studio
Ok, so this is old news I know, but I’ve had a busy couple of months and am only getting...
2016-07-20
1,382 reads
Want to be able to read your database between restores?
When restoring a database there are times when it would nice to restore a bit, check what’s been restored so...
2016-07-20
778 reads
Day 1: Agile Fundamentals: Scrum, Kanban, Lean and XP
It's week 3 of my jammed packed training schedule this July. This week I'm producing course 918 Agile Fundamentals: Scrum,...
2016-07-20
673 reads
SSRS 2016 Book Nearly Done… My Brain is now Jell-O
(first excerpt from the upcoming book) “Professional SQL Server 2016 Reporting Services and Mobile Reports” from Wrox Press is content...
2016-07-20
518 reads
Extended Event Help Queries
When working with Extended Events, there are times when a little more information is, well, helpful. You know you want to use extended events to try and monitor...
2016-07-19
11 reads
Extended Event Help Queries
Enjoy this article re-publication from my original work at SQL Solutions Group.
When working with Extended Events, there are times when...
2016-07-19
669 reads
SQL – MultiServer SQL Inventory – PowerShell
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2016-07-19
761 reads
Adding the ReadyRoll Extension in VSTS
As I’m doing a little development with ReadyRoll, I’m documenting some of the things I learn about the product.
A few...
2016-07-19
702 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers