Setting up powershell remote sessions
Hey guys, differing from usual this is a quick post on setting up powershell remote sessions. I know you can...
2016-05-02 (first published: 2016-04-22)
1,906 reads
How Two PASS Chapters Join Forces to Run One SQLSaturday In Orlando
We’re lucky enough to have two PASS chapters here in Orlando, oPASS and MagicPASS. Both in Orlando, but about 40...
2016-04-21
557 reads
Columnstore Indexes: Finally Awesome in SQL 2016
Columnstore indexes are amazing for optimizing the performance of large rowcount queries that would otherwise look like a SCAN operation in...
2016-04-21
662 reads
Broken Left Join
Here is a simple example of a LEFT JOIN that returns the sales stats for all employees under 21.
SELECT e.Name,...
2016-04-21
577 reads
Promotions and Conflicts of Interest
I noticed my co-worker, friend, and PASS board member, Grant Fritchey, posted a note on members of the PASS Board...
2016-04-21
558 reads
Microsoft’s Commitment to Azure
For several years, many of us who were involved with working in Azure from the early days, were concerned that...
2016-04-21
534 reads
Loading Data into Clustered Columnstore Index with SSIS
I’m using a clustered columnstore index (CCI) on one of my fact tables at a client. The row size is...
2016-04-21
1,845 reads
Speaking at 24 Hours of PASS – The Evolution of Data Platform
As announced a couple of hours ago, a new edition of the famous online webinars 24 Hours of PASS will...
2016-04-21
357 reads
JSON in SQL Server 2016 – The Good, The Bad, and The Ugly
Microsoft introduced support for JSON data in SQL Server 2016 and in Azure SQL Database. I was excited to see...
2016-04-20
723 reads
A Speaking Sabbatical
Lately I’ve been thinking about taking a break from doing presentations. Not sure what triggered it – maybe just a sense...
2016-04-20
625 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
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
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....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers