sql-posh

Comparing databases using SSDT

Another Twitter-born blog post! I love getting new ideas from the community. Real world ideas for solving real world problems! The original question was “Does SQL Compare or others prods allow me to compare 1 “gold” db to the 57 “identical” databases in prod at

cablemodem

My Cable Modem Keeps Rebooting!

There are obviously quite a few things that could cause internet issues that are totally out of our control, but there are some things that we may be able to try to help ourselves. Face it, dealing with cable service calls is right up there

sql-linux

Announcing SQL Server on Linux

Yes, you read that right. SQL Server will be ported to Linux. Here’s the Blog post from Scott Guthrie. http://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux/ Today I’m excited to announce our plans to bring SQL Server to Linux as well. This will enable SQL Server to deliver a consistent data

sql-logo-no-version

Slow Running Query? Where do I Begin?

Maybe you’re new to SQL Server or maybe you’re just expanding into performance tuning a little more. Query tuning can be a very daunting task and sometimes it’s hard to decide where to look first. In this post I am going to show you a

TSQLTuesday

T-SQL Tuesday #73 – Naughty or Nice?

Thank you to SQLBalls ( b | t ) for hosting this month’s #tsql2sday. As you work with SQL Server look around you. Is your environment Naughty or Nice? If it is Naughty what’s wrong with it? What would you do to fix it? Do