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
574 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
926 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,358 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
602 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
506 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,023 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
509 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,845 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
455 reads
XEvent Session Supporting Cast
Beyond the metadata in the the catalog views and DMVs, there are a few more objects that come in handy when dealing with Extended Events. I call these the...
2015-09-04
18 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers