What’s the Mashup Engine?
I was testing something the other day and ran sp_who2 on a test instance. I saw this in the program listing: I had never seen the Mashup Engine listed...
2019-04-24
25,842 reads
Blog Posts
Yes, pulling just the data you need is really important.
I was asked the other day why a customer was having performance issues on a table. A simple SELECT that ... Continue reading
2019-04-24
321 reads
CISA Accredited Trainer!
My certification came in! I’m now accredited to provide training for the Certified Information Systems Auditor (CISA) certification. It’s not the Microsoft Certified Trainer (MCT) accreditation I once had...
2019-04-23
36 reads
Cool Stuff in Snowflake – Part 8: Time Travel
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to...
2019-04-23 (first published: 2019-04-15)
852 reads
Correlated Subqueries vs Derived Tables
Watch this week's video on YouTube
Correlated subqueries provide an intuitive syntax for writing queries that return related data. However, they often perform poorly due to needing to execute once for...
2019-04-23
10 reads
Correlated Subqueries vs Derived Tables
Watch this week's video on YouTube
Correlated subqueries provide an intuitive syntax for writing queries that return related data. However, they often perform poorly due to needing to execute once for...
2019-04-23
19 reads
Should release cadence be slowed if you don’t have database load testing?
I got a question recently about a panel discussion on Database Development Disasters at SQL in the City Streamed. I had framed a question as, “how fast should development...
2019-04-23
12 reads
Storytelling Without Data?
There are many great resources out there for data visualization. Some of my favorite data viz people are Storytelling With Data (b|t), Alberto Cairo (b|t), and Andy Kirk (b|t)....
2019-04-23 (first published: 2019-04-11)
504 reads
Video – Creating Azure SQL Database
A quick 2 minute upload (with sound, my voice) showing you how easy it is to create an Azure SQL Database using the Azure portal and then using SSMS...
2019-04-23
41 reads
Data Type Precedence and Implicit Conversions
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data. When the data types do not match, SQL Server has to...
2019-04-22 (first published: 2019-04-09)
698 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
Alamat Kantor Bank BCA KCP Lomanis Telp:08218154393
WA:08218154393 Jl. Gatot Subroto No.080A, RT.001, Cigobang, Gunungsimping, Kec. Cilacap Tengah, Kabupaten Cilacap, Jawa...
Alamat Kantor Bank BCA KCU CILACAP Telp:08218154393
WA:08218154393 Jl. Jend. Ahmad Yani No.118, Sidakaya Dua, Sidakaya, Kec. Cilacap Sel., Kabupaten Cilacap,...
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
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