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,075 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,684 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,794 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
837 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,065 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,690 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,134 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
842 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
634 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,090 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers