XEvent Session Supporting Cast
So far, in this series, I have discussed the means to view the metadata associated with Extended Events. I also demonstrated...
2015-09-10 (first published: 2015-09-04)
986 reads
Blog Posts
Automated Metadata Report for SSAS Tabular
There’s been an excellent free solution for documenting SSAS metadata in multi-dimensional models for quite some time: http://www.purplefrogsystems.com/blog/2010/09/olap-cube-documentation-in-ssrs-part-1/.
I had the...
2015-09-09
1,279 reads
Executing DBCC for SQL Server Analysis Services 2016
In the upcoming release of SQL Server Analysis Services 2016, one of the new features you’ll see is the ability...
2015-09-09 (first published: 2015-09-03)
2,121 reads
Extended Events Categories
Packages have a couple of descriptors (or classifiers) that can be useful to help figure out what events contained within that package might be related to other events.
Related Posts:
How...
2015-09-09
6 reads
Extended Events Categories
I recently delved into a brief explanation of Packages as they correlate to Extended Events. In that article, I left...
2015-09-09
986 reads
Multi-Cursor Editing SQL feels like the movie Inception just became real
- Yes… multicursor editing is epic
- No… SSMS doesn’t support multi-cursor editing the way it should.
- Yes… you can do some...
2015-09-09
164 reads
One Easy Strategy for the Database Enterprise
Welcome to the second Tuesday of the month. And in the database world of SQL Server and the SQL Server...
2015-09-09
701 reads
One Easy Strategy for the Database Enterprise
Working with the default XEvent session and trying to make it more suitable to Enterprise worthy.
Related Posts:
SQL Servers Black Box Recorder - system_health December 29, 2018
Finding Installed Event...
2015-09-09
5 reads
Populating My DBA Database for Power Bi with PowerShell – Server Info
Following my last post about using Power Bi with my DBA Database I have been asked if I would share...
2015-09-09 (first published: 2015-08-31)
2,497 reads
The Poor Man’s SQL Backup Encryption - Syndication – WaterOx Consulting
Well, that was interesting While playing around with demos to use in my newer session, Hacking Exposé Too (See it...
2015-09-09
449 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Are luxury packages in Andaman suitable for a honeymoon?
Yes, luxury packages in Andaman are highly popular among honeymooners due to their romantic...
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers