Extended Events Packages
The first core building block to the data that builds Extended Events is the concept around packages.
Related Posts:
Correlate Trace and XE Events December 28, 2017
SQL Servers Black Box...
2015-09-07
25 reads
Extended Events Packages
Today, I continue on with exploring some of the metadata concerning Extended Events. To date, I have explored various aspects...
2015-09-07
576 reads
Populating My DBA Database for Power Bi with PowerShell – SQL Info
Following my post about using Power Bi with my DBA Database I have been asked if I would share the...
2015-09-07
929 reads
VARCHAR = @NVARCHAR and SARGability
In my previous post, I mentioned the use of functions, specifically ISNULL and the effects on SARGability of the query....
2015-09-07
1,378 reads
Columnstore Indexes – part 65 (“Clustered Columnstore Improvements in SQL Server 2016”)
Continuation from the previous 64 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This article is dedicated to the improvements...
2015-09-06
606 reads
Use Twitter to get #PowerShell help
A quick post today just to add some weight to something that Mike Fal b | t has kicked off. The #SQLHelp...
2015-09-06
509 reads
How to deploy SSIS Package ? Step by Step SSIS TIP #114
Dear Friends,
In last post we have successfully created our fist basic package. So, Now the next thing is how...
2015-09-05
24,025 reads
018 – Learn Like A Pro! - Syndication – WaterOx Consulting
Learn Like A Pro In WOxPod!, episode # 018 – “Learn Like...
The post 018 – Learn Like A Pro! appeared first on WaterOx...
2015-09-04
510 reads
Buffer Pool Extension in SQL Server 2014 part 4: benchmark testing for update operations
One of my previous articles was devoted to carrying out a range of tests to compare speed of data read...
2015-09-10 (first published: 2015-09-04)
1,849 reads
Speaker of the Month: September 2015
Feast or famine.
The last several months I just haven’t seen that many speakers, let alone that many community speakers. Then,...
2015-09-04
457 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers