Columnstore Indexes – part 76 (“Compression Delay”)
Continuation from the previous 75 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
While playing with SQL Server 2016 CTP...
2016-02-04
794 reads
Blog Posts
Loading a Text File with a Line Feed
Loading text files is a skill that probably every DBA needs. I know that the import wizard is available, but...
2016-02-04
1,226 reads
Minnesota BI User Group – Powering Up HDInsight with Power BI (December 2015)
On Wednesday, December 16, I presented on this topic at the Minnesota BI User Group. This session is based on...
2016-02-04
561 reads
Positivity
I’m sitting in the classroom of SQL Cruise listening to Tim Ford (b|t) explain mechanisms for monitoring indexes. It’s a...
2016-02-04
555 reads
PowerShell Pester – "The script failed due to call depth overflow."
This error caught me out. I am putting this post here firstly to remind me if I do it again...
2016-02-04 (first published: 2016-01-31)
1,711 reads
Recertifying SQL Server 2012 MCSE with Microsoft Virtual Academy
Do people still get certified? I don’t hear much about it in the SQL community these days so I asked...
2016-02-04
497 reads
SQL Server 2016: configure TempDB during installation
Proper configuration of the TempDB system database is crucial for optimal performance of a SQL Server instances during heavy loads. The recommended...
2016-02-04 (first published: 2016-01-31)
8,340 reads
Blogger questions: What if someone else wrote about the same subject?
I have a moderately popular blog. In part because I syndicate but largely (in my opinion) because I write a...
2016-02-03
567 reads
Limitation of In-Memory OLTP in SQL Server 2016 – TRUNCATE table not supported
Hi friends, another limitation that we will discussed is TRUNCATE table command is not supported with memory optimized tables. Let’s...
2016-02-03
1,393 reads
Scaling Azure SQL Database
One of the advantages Azure SQL Database has over on-prem SQL Server is the ease in which it can scale. I’ll...
2016-02-03
798 reads
Blogs
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers