The slides and demo scripts from today's GroupBy session are now available on our GitHub repository https://github.com/SQLUndercover/UndercoverToolbox/tree/master/GroupBy Many thanks again for watching, I really hope that you found it useful 🙂
Using PowerShell To Deploy Scripts From GitHub to Multiple SQL Servers
Now I'm all for making my life easier and one thing that makes life easier for me is having a single process that I can run to install\update all my favourite utility stored procedures quickly and on all my SQL Servers. I've done this a few different ways in the past but this time I... Continue Reading →
SQL Smackdown!!! Cursors VS Loops
Ladies and Gentlemen, welcome to the main event of the evening. The SQL Undercover Smackdown Heavy Weight Championship of the World! In the red corner, we hate him, we loath him, I've even heard people say he should be deprecated, it's the Cursor!!! Facing him in the blue corner, loved on the forums, praised by... Continue Reading →
T-SQL Tuesday #96 – Folks Who Have Made a Difference in my career #TSQL2sday
This months TSQL Tuesday subject is a shout out and high-five to those people who have inspired or made a contribution to my DBA life. So here goes: Before I started my career as a Database Administrator I worked in the motor trade for approx 12 years , I worked with some great people and gathered... Continue Reading →
T-SQL Tuesday #96 How did I get started?
Hi Folks, I’m the new guy that my two colleagues are still trying to convince to write my first blog post and as they like to put it I’m still scared or have stage fright. My name’s Chris and I’m the latest DBA to go undercover and investigate all things SQL.... Continue Reading →
T-SQL Tuesday – Folks Who Have Made a Difference #TSQL2sday
So this month's T-SQL Tuesday subject is a shout out and high-five to those people who have inspired or made a contribution to my DBA life. Well where do I start? Thinking back on my career there are just so many people that have given me a push here and a nudge there without which I... Continue Reading →
UNDERCOVER TOOLBOX: Using Python To Copy A SQL Login From One Server To Another
Recently I've been thinking about Python and whether it can be useful to the DBA as well as the data scientist. One good use that I have found for it is to copy logins from one server to another. There are plenty of times when you might want to copy your SQL logins (including the... Continue Reading →
Connecting to a Remote Instance of SQL Server Using Python
SQL Server's integration of Python has been heavily marketed towards the machine learning and BI guys, but does it offer anything for the DBA? All the attention has been on machine learning, so much so that for a while I didn't pay it any attention at all, but then I got thinking to myself. DBAs... Continue Reading →
How Far Has My Update Got? Finding Out How Many Rows Your Long Running Insert, Update or Delete Has Actually Modified So Far
I'm pretty sure that we've all found ourselves in the situation where we've run an INSERT, UPDATE or DELETE script and it seems to be taking an age to run. We've done all the usual checks, there's no blocking going on, things are happening but it just seems to be taking an age to finish. ... Continue Reading →
Failed to perform AlwaysOn Manual Failover using the wizard – Availability-group DDL Operations are permitted only when you are using the master database .
Routine maintenance rolls around and it's time to failover your AG's to new Primary's to allow for patching and restarts... the weapon of choice will be the SSMS Failover wizard - and why not its does the job nicely and give us some nice visuals as it progresses through each failover. On this... Continue Reading →
SQL Undercover 