I'm sure that most of us know that SQL Server stores all it's data in 8Kb pages. But what do these pages actually look like and how can we go about looking at them and picking them apart. For this we're going to need a couple of undocumented DBCC commands, DBCC page and DBCC ind.... Continue Reading →
In the second part of our series on creating a SQL Server test lab on your workstation, I'm going to look at creating a domain user, joining a SQL Server to our domain and connecting to that server using our domain account. Other Posts in the Series Part One, Installing The Domain Controller Part Three,... Continue Reading →
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 🙂
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 Undercover 