SSRS – Using a List Item to Display Details
How many times have you been asked to develop a report that displays the details for a specified group? For...
2013-03-11
3,082 reads
Implementing a ‘Time Calculations’ Dimension in Tabular via DAX
A common request from business users is ‘Time Intelligence’ functionality in an SSAS cube. For example, users may wish to...
2013-03-11
5,691 reads
DMV-2 : Explore the secrets of session…… sys.dm_exec_sessions
sys.dm_exec_sessions DMV (Dynamic Management View), delineated by BOL as follows: http://msdn.microsoft.com/en-us/library/ms176013.aspx
Returns one row per authenticated session on SQL Server. sys.dm_exec_sessions is a server-scope view...
2013-03-11
3,801 reads
SQL Server – Generating PERMUTATIONS using T-Sql
Were you ever asked to generate string Permutations using TSql? I was recently asked to do so, and the logic...
2013-03-11
841 reads
PowerShell Usage in DBA Work — Case Study 2 / 7
As a DBA in a complex environment, we frequently need to backup various environment information. One of the backups is...
2013-03-10
1,069 reads
What is Page Life Expectancy (PLE) in SQL Server
Being a production DBA means having to quickly look at a SQL Server and diagnose issue with it. We know...
2013-03-08
4,814 reads
Windows 8 and Google Calendar
I use the Google calendar service extensively. I host my domain there and I’ve gotten used to the calendar. When...
2013-03-08
1,141 reads
Top BI Enhancements for SQL Server 2012 Presentation
Next Tuesday, March 12th at 1:15pm CST, I will be presenting the session “Top BI Enhancements for SQL Server 2012” at...
2013-03-08
844 reads
Reblog: March 1 to March 7
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-08
635 reads
Visual Studio 2012/SSDT Addition for BI Project Version Compatibility & Themes
We can now use Visual Studio 2012 to create and edit SQL Server BI projects! Woo Hoo. In the past,...
2013-03-08
1,093 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers