One of the most useful tools to the DBA when we need to test new features, recreate a fault that we've seen in production or just want to see 'what if...?' is a test lab. Other Posts In The Series Part Two, Creating a Domain Account and Joining a SQL Server to the Domain Part... Continue Reading →
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 🙂
08 Jan 2018 - V1.1 released - Details here Most of the time the goto is to use the GUI which is a nice graphical way of doing it which can make configuring the settings somewhat easier , but this comes with a cost - the cost being time! I have lost count of the... Continue Reading →
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 →
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 →
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 →
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 →
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 →
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 →
SQL Server tracks untrusted Foreign keys in sys.Foreign keys with a column called is_not_trusted, there may be a number of reasons why a Foreign key may have become untrusted below are a couple of examples: Foreign key was disabled using the 'NOCHECK' option then re-enabled using 'CHECK' (not to be confused with 'WITH CHECK') Foreign key was... Continue Reading →
SQL Undercover 