Cross Tab Report in SSRS
This tip provides a step by step process to create a cross tabulation report in SQL Server Reporting Services.
Hidden treasures of SQL Prompt
You are invited to discover features of SQL Prompt that you may not even know exist. We will will walk you through the treasure map of SQL Prompt and show you where all the great features are buried.
Questions about Comparing Databases with SQL Compare that you were Too Shy to Ask
Phil Factor offers straightforward answers to tricky SQL Compare questions.
Keeping Your Staff
Retaining staff is always a challenge for many organizations. Today Steve talks about the difficulties of doing so and in choosing who to retain.
When one of your DBA colleagues leaves the company, what is your checklist?
A colleague left the company, a couple of days after SQL Server processes start failing...what do you do?
How SQL Prompt Improves SQL Server Database Development
While everyone knows SQL Prompt for its code completion and IntelliSense features, a lot of its extra value comes from features that allow the development team to standardize coding practices and drive up code quality.
Running Container Workloads in Microsoft Azure
Containers are being used by more and more organizations to automate build pipelines in their CICD processes. In this article, Mahendran Purushothaman shows how to automate the creation of Docker containers and a Kubernetes cluster in Azure.
A Getting Started PostgreSQL Tutorial
Introduction to PostgreSQL PostgreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language. Though originally designed to run on UNIX platforms, PostgreSQL is eligible to run on various platforms such as Linux, macOS, Solaris, and Windows. PostgreSQL databases provide enterprise-class database solutions and are used by […]
Do You Know What the Settings Should Be?
Estate management keeps getting more complex, especially with the move to the cloud, or to multiple clouds. Today Steve talks about the need to ensure you know what the settings are in your environments.
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
BIT_COUNT() IV
Comments posted to this topic are about the item BIT_COUNT() IV
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers