Tag Archives: syndicated

Interviewed on Channel 9

Had a quick interview at Microsoft on Channel 9 last month, and it’s now live. Enjoy. https://channel9.msdn.com/Blogs/vsppstories/Including-the-database-in-your-DevOps-pipeline/player

Posted in Blog | Tagged , , | Leave a comment

Easily Move Databases with Copy-SqlDatabase

One of the things that people have asked to be implemented for many years is an easy way to copy databases. SSIS has the Copy Database Task, but that has been problematic over time. As a result, while easy, it’s … Continue reading

Posted in Blog | Tagged , , | Leave a comment

What Port Should I Use?–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is a quick post on checking the port for your SQL Server instance. It’s in line with Tim … Continue reading

Posted in Blog | Tagged , , | 2 Comments

SQL in the City is coming next week

Next week is the 2016 version of SQL in the City and you can register now to attend. It’s free and doesn’t require any travel. You can watch the event live from the comfort of your office chair. In the … Continue reading

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

A Python SQL Server App

I got a link recently from Microsoft on building apps easily for SQL Server. At the top of the page, they ask you to pick a language and OS. Since I’ve done a little Python and I used Windows, I … Continue reading

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

Find my git remote

I work on a few projects and have a bunch of demos setup, but I don’t work on them all every week. Being only semi-creative like many of you, I end up with some similar projects with similar names. When … Continue reading

Posted in Blog | Tagged , | Leave a comment

Moving Tasks with Copy-SqlJob

More dbatools experimentation for me. This is a great set of Powershell cmdlets that solve simple, handy problems. In this post, I want to look at Copy-SqlJob, which will allow me to easily move jobs from one instance to another. … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Hey Posh, Are My Services Running?–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In a previous post, I looked at escaping strings. The reason I needed to do this was that I … Continue reading

Posted in Blog | Tagged , , | Leave a comment

What’s the little popup window in #SQLPrompt?

Awhile back I was working in SSMS and saw this window. It threw me off since I was trying to write some code and hadn’t expected it. I clicked Escape, Enter, a few things and was getting frustrated when it … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Rate a Session for GroupBy

One of the things that I struggle with is understanding whether a session at a conference like a SQL Saturday is worth watching. I also struggle writing abstracts and attracting people to my own sessions, so I think the idea … Continue reading

Posted in Blog | Tagged , , | 2 Comments