Two key combinations used by SQL Server T-SQL developers every day are Ctrl-C and Ctrl-V for copy and paste.
But many users of SQL Server Management Studio (SSMS) don’t realize that it has a clipboard ring and can deal with several objects in the clipboard at the same time.
Let’s see an example.
In this screen shot, I’ve opened a query window with the source code of the AnalyzeTableColumns procedure from SDU Tools.
2025-07-14
Sometimes I’m sent books to review and I just don’t get around to it fast enough. This book was one of those. Why we argue and how to stop: A Therapist’s Guide to Navigating Disagreements, Managing Emotions, and Creating Healthier Relationships by Jerry Manney .
I found this book quite interesting.
Early on, Jerry notes that journaling is important because memory is unreliable. Jerry said I learned a long time ago that one of the key characteristics of a knowledgeable and successful person is not how much they can remember, but whether they have a method or system for accessing important and relevant information when they need it. I’m certainly learning that more as I get older.
2025-07-13
I often see people doing very repetitive editing tasks that could easily be carried out by using selecting and changing rectangular regions of code.
The simplest example of doing this is to insert some text on a number of rows. Take the following code as an example:
I’ve got the skeleton of a list of columns in a CREATE TABLE statement but let’s assume that I’m a comma in front person and want to put a few spaces and a comma, etc. in front of each column after the second.
2025-07-12
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around SQL Server and Azure SQL Database.
Section: Development Level: Intro
Question:
You have a table of transactions. You need to select all the transactions for a particular date, based on the TransactionDateTime column. It holds datetime data type value. The date is stored in the @RequiredDate variable.
2025-07-11
A request that I hear all the time, is “I don’t like tabs but insert name of annoying colleague here decided he likes to use them. How do I remove them?” Similar thing happens when installing SSMS and leaving the default options.
Whether to use tabs or spaces leads to near religious level arguments amongst SQL developers. I see strong arguments on both sides. In the past, I’ve always ended up using spaces because I’ve run into issues with tabs in some of the tooling that I needed to use.
2025-07-10
One of the things many people don’t know about me, is that I spent many years both playing and umpiring baseball. Clearly that’s not so common for Australians.
In many ways, the umpiring was probably the most interesting. I’ve umpired up to state level games, including the Pan Pacific games. It certainly teaches you how to deal with strong views effectively.
Most people have seen the classic images of managers/coaches racing out to have a very heated discussion with an umpire. I’ve had so many people asking me how I dealt with that when I was umpiring.
2025-07-09
Want to work with Power BI and have no idea where to start? Let us show you in this straightforward and low cost course with easy to follow practical exercises !
We’re pleased to announce that this course is now available. This is another course that we’ve had so many requests for. You can find details of it here:
Do you need to get started with Power BI?
2025-07-09
Intellisense is one of the best things that’s ever been added to Visual Studio or to SQL Server Management Studio (SSMS). It’s hard to remember back to before it was added, or how we worked then.
I had a young friend from the United Kingdom who had just completed a Computer Science degree and one of the things that he was most proud of, is that he knew so many HTML tags and which attributes went with which tags. When I showed him HTML Intellisense in Visual Studio, I think he was about to cry.
2025-07-08
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around SQL Server and Azure SQL Database.
Section: Administration Level: Medium
Question:
You are reviewing database settings for a server.
You notice that one database has AUTO_CLOSE configured. Your model database does not have it enabled.
What is the most likely cause for that setting to be enabled, and what effect does enabling it have?
2025-07-07
Unlock your potential with Analysis Services !
We’re pleased to announce that this course is now available. We had so many requests for this course. You can find details of it here:
Analysis Services for Data Professionals
Are you ready to elevate your skills in working with Analysis Services?
Our comprehensive course is your gateway to becoming proficient at working with both SQL Server Analysis Services, and with Azure Analysis Services.
Ask Yourself:
2025-07-06
