The Bit Bucket

SDU Tools: Show Current Blocking in SQL Server

Blocking is a popular topic in SQL Server. Users are often trying to work out what’s blocking what. In our free SDU Tools for developers and DBAs, we have a tool to make that very easy to see. It’s called ShowCurrentBlocking.

ShowCurrentBlocking takes one following parameter:

@DatabaseName (sysname) is the database to report on

It returns two sets of data.

The first rowset is a list of all objects that are currently blocked, and the last query that was run on the connection for each of those objects.

2019-03-28

FIX: Headset volume too low on Windows 10 (LX-3000)

After some recent upgrade to Windows 10, I’ve found that the headphone volume is way too low for me. I’m using Microsoft LX-3000 headsets, and have always really liked them.

So I was really puzzled what makes the volume so low.

The thing that’s made the biggest difference for me is to enable loudness equalization in the properties of the device. For those that aren’t sure how to do that, here’s a quick set of screen shots:

2019-03-27

Opinion: Another plea to developers - please avoid fixed size windows

Just thought I’d send another plea out to my developer friends:

Please stop making windows fixed size when they don’t need to be.

Take a look at the main image above. The issue isn’t just this one application, it’s a plague. The window:

  • Is fairly small
  • Is way smaller than the desktop space
  • Has no resizing handles
  • Is not able to be maximized
  • Has content that doesn’t fit in the current window size

Why?

2019-03-27

T-SQL 101: 10 What are Schemas in SQL Server?

In the last post, when talking about querying a table, I mentioned that you should always include the name of the schema when you refer to a table. This is called using two-part names. But what are schemas in the first place?

In different database engines (e.g. Oracle, PostgreSQL, etc.), schemas are implemented and work differently i.e. there isn’t a consistent story across the industry. In SQL Server though, the closest analogy that most people would be familiar with, is a folder where you group things that are related in some way.

2019-03-25

Book Review: Alibaba - The House that Jack Ma Built

You probably already know that I’ve been learning Mandarin for about 8 years now, and have a fascination with Chinese business and technology. Learning the language has made this more approachable for me.  The story of Jack Ma and Alibaba is one of the really interesting aspects of Chinese business today, so I was intrigued to read this book:

Alibaba: The House that Jack Ma Built by Duncan Hall

I ended up listening to the book via Audible rather than reading it.

2019-03-22

SQL: Why is SQL Server Configuration Manager missing?

Ever since it appeared back in earlier versions of SQL Server, I’ve normally launched SQL Server Configuration Manager from the Start menu in Windows. But every now and then, with some versions, it seemed to disappear. Now with the latest version of SQL Server installed on the latest version of Windows, it’s not there at all.

While it is possible to put it back in the menu, I think it’s time for us to get used to starting it in a different way.

2019-03-21

SDU Tools: Finding out how large SQL Server tables are with ListUserTableSizes

In our free SDU Tools for developers and DBAs, we have a number of functions and procedures that help you work with tables and indexes. One question that often arises is about how big tables are. Our tool ListUserTableSizes helps with that.

SQL Server Management Studio (SSMS) has a report that shows you user table sizes, but people often want a list of sizes that they can get programmatically, perhaps for a monitoring tool, or some sort of automation.

2019-03-20

T-SQL 101: 9 Finding out what's in a SQL Server table

In the last post, I described what tables were, and then showed how to view their contents using an option in Object Explorer in SQL Server Management Studio (SSMS).

If you’ve ever seen a SQL query of any type, you will have seen one like this:

It says to return all columns from the table, and to return all rows.

Fair enough.

But there are a few things to understand about this simple statement:

2019-03-19

SQLBits - A World of Free SQL Server and Data Information Online

There are many SQL Server events around the world each year, and many are just awesome events. One that has grown non-stop and is currently my pick of these events is SQLBits.

Our UK buddies behind this (currently Simon Sabin, Darren Green, Annette Allen, Jonathan Allen, and Alex Whittles) have created an event that all others should be looking to.

I love the way they combine technical content with fun.

2019-03-18

Our new online on-demand SQL Server Reporting Services class is now live!

Need to learn SQL Server Reporting Services or know someone else that needs to?

We’ve been working hard to move all our popular in-person training courses online and on-demand, so anyone in the world can take them.

Our SQL Server Reporting Services for Developers and DBAs course is now out the door.

This is the same course that we run as the first day of our 5 day BI Core Skills course. And it’s not just videos, there are:

2019-03-16