The Evolution of SQL Server BI
It is sometimes hard to keep up with Microsoft's direction in Business Intelligence. Robert Sheldon takes stock with the Simple BI Timeline which explains how BI has evolved over the years.
Teambuilding
This week Steve Jones wants to know about your efforts to create bonds with co-workers and build a team. Does your company do anything to help facilitate this?
Introduction to SQL Server 2016 Temporal Tables
Temporal tables - also known as system-versioned tables, but not to be mistaken with temporary tables - are a new feature of SQL Server 2016 that allow SQL Server to automatically keep a history of the data in the table. This tip from Koen Verbeeck introduces the new feature by explaining how to create a system-versioned table.
Product Review: GenesisOne T-SQL Source Code Unscrambler
MVP Jody Roberts reviews GenesisOne T-SQL Source Code Unscrambler, a tool that aims to clarify code and server environments with simple diagrams and plain English.
Stairway to Columnstore Indexes Level 4: Catalog Views
In this level, we will first take a look at how to recognize columnstore indexes in some of the generic catalog views. After that we will investigate the new catalog views that have been added just for columnstore indexes.
Microsoft and Database Lifecycle Management (DLM): The DacPac
The Data-Tier Application Package (DacPac), together with the Data-Tier Application Framework (DacFx), provides an alternative way to automate the process of scripting out, or deploying a SQL Server database, reporting on changes, or checking version-drift. As such, it seems to provide an obvious cost-free start for tackling automated Database Delivery as part of Database Lifecycle Management (DLM). We asked Phil Factor if it is ready for Prime-time.
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 KCU KEDIRI Telp:08218154393
WA:08218154393 Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
Alamat Kantor Bank BCA KCU MALANG Telp:08218154393
WA:08218154393 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa Timur 65111
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