EzAdo - Part 2
EzAdo is a very simple api built to exploit some new features of SQL 2016. It combines software, convention, and creativity to get more done in less time.
Generating Our Own Bad Data
We depend on data quality to run our businesses efficiently. However, it's a problem when we mess that data up on purpose.
List and Execute SQL Server Stored Procedures with PowerShell
Stored procedures allow the DBA to automate a certain task by bundling up a query and executing as a single set of logic. This is considerable progress in including more automation, but why not automate the automation? Adam Bertram explains how.
Deploy Security Changes with Copy-SqlLogin
Moving security changes between server instances can be a cumbersome process, but it doesn't need to be with the PowerShell cmdlet, Copy-SqlLogin.
Azure SQL Data Warehouse: Explaining the Architecture Through System Views
The architecture of Azure SQL Data Warehouse isn't easy to explain briefly, but if you have some useful queries that access the management and catalog views, and diagrams that show how they relate together, you can very quickly get a feel for what is going on under the hood. By using and extending these queries that use these views, you can check on a variety waits, blocking, status, table distribution and data movement in ASDW.
Analysis Services Lives On
The release of Analysis Services in Azure means the platform has a future.
Reading Backup History Information for a Database
There are times when you might want to read backup/restore history information to identify a backup’s start and finish date/time, the location where the backup was written, the size of the database backup, etc. Greg Larsen shows you how to do this in SQL Server.
Emotions and Decision Making
Today we have a guest editorial from Grant Fritchey that looks at emotions and how they can affect our decision making.
Learning SQL Server 2016
Here is a reference that lets you take a quick look at the new features in SQL Server 2016 and dig into the various items with a collection of links we'll maintain.
Blogs
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen and the Revolt BI join forces
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
BIT_COUNT I
Comments posted to this topic are about the item BIT_COUNT I
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers