How easy or difficult to write dynamic SQL ? TIP#110
This is one of the challenge for most of the developer to write dynamic SQL. Generally we follow the approach...
2015-08-12
1,284 reads
Columnstore Indexes – part 62 (“Row Groups Trimming”)
Continuation from the previous 61 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have spoken a lot of times...
2015-08-12
572 reads
oPASS & MagicPASS Meeting Tonight
David Pless is presenting:
Query Store is a new feature in SQL Server 2016, and is also available in Azure SQL...
2015-08-12
565 reads
Here’s the New #Excel 2016 Chart Types!
The Office 2016 Public Preview is now available for download! Included in the preview of Excel 2016 are a handful...
2015-08-12
1,163 reads
Hadoop and Microsoft
In my Introduction to Hadoop I talked about the basics of Hadoop. In this post, I wanted to cover some of...
2015-08-12
3,194 reads
Please Welcome Our New Certified SQL Server DBA’s!
Today we celebrated the last session of one of our Become a SQL Server DBA classes. This course takes people...
2015-08-12
627 reads
Open SQL Server Virtualization Q&A Webinar – 8/19
Next Wednesday, August 19th, at noon Eastern the PASSVirtualization Virtual Chapter will be holding an open questions and answers session...
2015-08-12
528 reads
Why I still like Excel PowerPivot models in SharePoint however Tabular solutions in SSAS are better
[2015-Aug-12] It’s quite obvious that in present time there is a growing audience for all the latest changes and updates...
2015-08-12
1,301 reads
Farewell Scott McKenzie
Scott McKenzie was the DJ of Mix 105 here in Orlando for an astounding 24 years and that’s been the...
2015-08-12
637 reads
Red Gate SQL Source Control v4 offers schema locks
Red Gate Documentation Update
Looks like the rapid release channel now has a great feature for locking database objects that you...
2015-08-12
284 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
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
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers