Powershell Error – Import-Module AzureRm
I was playing with SQL Azure on my brand new Surface pro device. I open the Windows Powershell ISE as administrator to...
2018-09-19
1,129 reads
Blog Posts
Public Service Announcement: check your backup notifications
The Azure cloud platform lost a data centre for a number of hours recently due to inclement weather. This affected...
2018-09-19
229 reads
Rescheduled Performance Troubleshooting Webinar
With Hurricane Florence no longer a hurricane, we have rescheduled the webinar for next Wednesday, September 26, 2018.
Free sign up...
2018-09-19
216 reads
SQL Server Automatic Tuning in the Real-World
In SQL Server 2016 we saw Query Store. Query Store was a game changer to help database administrators identify troublesome...
2018-09-19 (first published: 2018-09-10)
2,959 reads
Three skills to look for in a technology partner
SQL Treeo’s founder and CEO, Danny Riebeek, reflects on his 20+ years in the IT industry. Q: What prompted you...
2018-09-19
280 reads
What is Projectsv13 in SQL Change Automation?
I got this question recently from someone that was evaluating the SQL Change Automation client in Visual Studio. After setting...
2018-09-19
1,718 reads
Why Customers Are Looking At Azure
As a Principal Consultant with Pragmatic Works, I have many conversations with customers about moving to Azure. As a Consulting...
2018-09-19
314 reads
Announcing the 5th Edition of SQL Server 2017 Query Performance Tuning
I am quite excited to announce that the latest, most up to date, and by far the largest, copy of...
2018-09-18
328 reads
Are scalar functions really a bad thing?
I’ve read a lot of things lately pointing to scalar functions as if they were the devil. In this blog...
2018-09-18 (first published: 2018-09-10)
4,007 reads
Calculating Quartiles with DAX and Power BI
Like many of my blog posts, this post is inspired by some work I was doing with a customer who...
2018-09-18 (first published: 2018-08-31)
4,112 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers