Power BI Visual Usability Checklist
At PASS Summit, I presented a session called “Do Your Data Visualizations Need a Makeover?”. In my session I explained...
2018-11-27 (first published: 2018-11-15)
2,734 reads
Blog Posts
Should I load structured data into my data lake?
With data lakes becoming very popular, a common question I have been hearing often from customers is, “Should I load structured/relational data into my data lake?”. I talked about...
2018-11-27
162 reads
Should I load structured data into my data lake?
With data lakes becoming very popular, a common question I have been hearing often from customers is, “Should I load...
2018-11-27
479 reads
Thinking about Pre-Cons In Orlando in 2019
In the spirit of “do more” we’re hoping to host at least 4 pre-cons in Orlando in 2019. Right now...
2018-11-27
262 reads
Why You Should Take the ‘State of Database DevOps Survey’ Today (even if you don’t do DevOps)
Update: The survey is now closed, thanks folks! When I began working with databases, nobody talked about DevOps. It was a few years before I heard the words ‘Agile’...
2018-11-27
8 reads
Create dynamic agenda slides with PowerPoint Zoom
There was a time when I saw PowerPoint as a necessary evil – a way of conveying ideas that I wasn’t crazy about, but which worked. These days, my...
2018-11-26
19 reads
Determine database version from a bak file
Have you ever imagine you can determine the version of SQL Server from a bak or a MDF file? I...
2018-11-26 (first published: 2018-11-15)
18,093 reads
FCB::Open failed: Could not open file number 2. OS error: 3(The system cannot find the path specified.).
AdvertisementsTroubleshooting steps to do when we cannot start SQL service and receive this alert.
Run –> eventvwr –> windows log –> system and filter...
2018-11-26
1,160 reads
Ghosts in your Database
Yes Virginia, there are ghosts in your database. More specifically, there are ghosts in your SQL Server database. They are not there to haunt you. They are not there...
2018-11-26
11 reads
Monitor Database Offline Events
The other day, I shared an article showing how to audit database offline events via the default trace. Today, I...
2018-11-26 (first published: 2018-11-15)
1,922 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers