T-SQL Tuesday #119–Changing My Mind
After missing the last T-SQL Tuesday, I’m back for the latest invitation from Alex Yates. In this one, Alex asks us to write about something in IT where you...
2019-10-08
19 reads
Blog Posts
A #DevOps Discussion on Thursday with Abel Wang
I’m hosting a webinar later this week with Abel Wang, one of the talented members of the League of Extraordinary Cloud DevOps Advocates at Microsoft. This Thursday, October 10,...
2019-10-07
48 reads
Debugging techniques (focusing on T-SQL)
tl;dr; Add PRINT and/or SELECT statements. Comment/uncomment out pieces of code to isolate problems. Change INSERT/UPDATE/DELETE statements to SELECTs. Disclaimer: ... Continue reading
2019-10-07 (first published: 2019-09-23)
839 reads
Download Power BI Audit Logs with the New Get-PowerBIActivityEvents cmdlet
Earlier this week a new version of the MicrosoftPowerBIMgmt module was made available on the PowerShell Gallery. Two new cmdlets were included in the module Remove-PowerBIReport and Get-PowerBIActivityEvents. The...
2019-10-07 (first published: 2019-09-30)
635 reads
Preparing for PASS Summit 2019 - Logistics & Survival
It’s time once again to prepare ourselves for the endurance test that is PASS Summit, November 5-8. I’ve participated in the Summit Buddies program the past two years, but...
2019-10-07
6 reads
SQL Injection Mitigation in SQL Server 2019
I’ve been teaching a lot more about SQL Injection lately (including blog posts). I’ve been doing this because, despite this being a 21 year-old problem with well defined solutions,...
2019-10-07
186 reads
Updated: Getting Started with Installing Kubernetes
Let’s get you started on your Kubernetes journey with installing Kubernetes and creating a cluster in virtual machines. Kubernetes is a distributed system, you will be creating a cluster...
2019-10-07
6 reads
Updated: Getting Started with Installing Kubernetes
Let’s get you started on your Kubernetes journey with installing Kubernetes and creating a cluster in virtual machines.
Kubernetes is a distributed system, you will be creating a cluster which...
2019-10-07
1 reads
Last Week Reading (2019-10-06)
Hello Azure/Power/BI/Data fella! Another two weeks passed very quickly and the new edition of Community conference in the UK is about to begin. Check whether you can attend one...
2019-10-06
11 reads
How I applied 13 cumulative updates in 12 minutes
Twitter is a strange place. I mean, aside from all the outrage practice and animal videos. Last week I sent out a tweet about how I used dbatools to...
2019-10-04
8 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