Tag Archives: syndicated

What’s a SQL Compare Snapshot?

I saw a short video from Grant Fritchey on the Redgate channel that shows how to cerate a snapshot in SQL Compare. I think snapshots are great, and there are lots of uses (more on that later), but I do … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Test Database Compatability with dbatools

I really like the dbatools project. This is a set of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Join me at VS Live – Anaheim

We’re just a month away from Visual Studio Live in Anaheim where I’ll be speaking along with many others. Join me today, register with ANSPK14 and save $400. This gives you the 4-day, all access conference package for a reduced … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Experimenting with VSCode instead of the ISE

I’ve been playing with PowerShell here and there, learning a few things. As I use the dbatools project, or I saw a tweet from Rob Sewell on using VS Code for PoSh, which I’ve tried, but it felt cumbersome and … Continue reading

Posted in Blog | Tagged , | Leave a comment

I want a new gadget with less features

Years ago I bought a Pebble smartwatch. I didn’t back the Kickstarter, but a few friends did and I liked the product. I wore mine for almost two years before it started to die. I can be rough on gadgets, … Continue reading

Posted in Blog | Tagged , | 3 Comments

The Code Coverage Report

I had someone that told me recently that they needed to find a way to get code coverage in T-SQL. Not for them, not to improve quality, but because their manager wanted a report. OK, here it is. First, build … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Multi Script Removes 25 Database Limit

I woke up to a Slack message that alerted me to a post in one of our channels. An engineer noted that SQL Multi Script was being upgraded today, releasing to all channels with v 1.3.3. The post alerted me … Continue reading

Posted in Blog | Tagged , | 2 Comments

Data Governance Survey–Still Time

Just a reminder. Redgate is doing research into data governance, and we have a small survey we’d love to get some answers to about how you view the process inside your company. Take the Survey and be entered to win … Continue reading

Posted in Blog | Tagged , | Leave a comment

Remove an Active Lease on a Blob in Azure

I was creating and dropping VMs in Azure, and found myself charged money for disks that I thought I’d deleted. I found later that deleting a VM doesn’t necessarily remove the disk blob. Here was one way that I removed … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Automate Migrations–T-SQL Tuesday #94

It’s T-SQL Tuesday time again, and I’m slightly pressed for time, which is sad. This is a great topic. Rob Sewell hosts this month with his question about what we are going to automate? He’s a PowerShell advocate, so I’m … Continue reading

Posted in Blog | Tagged , , , | Leave a comment