Getting back to blogging
The past two months have been very hectic for me. I had an unexpected job offer towards end of July,...
2017-08-28
469 reads
What I Learned Today - Configuring tempdb in RDS
Today I learned that you can configure tempdb in RDS!
One of the things we DBA’s do is configure tempdb to...
2017-08-28
1,089 reads
Columnstore Indexes – part 110 (“The best column for sorting Columnstore Index on”)
Continuation from the previous 109 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In this blog post I wanted to...
2017-08-27
517 reads
Azure support MySQL & PostgreSQL
After SQL Server support on Linux Microsoft is not have another great enhancement where now Azure supports MySQL and PostgreSQL...
2017-08-27
497 reads
SQL Server 2005 – Failed Maintenance Job
I Know SQL Server 2005 is no longer in support by Microsoft, but Want to provide a solution for those...
2017-08-27
306 reads
SQL Server Replication snapshot initialization taking long time to be applied
Hello all,In today's post I want to share a tip that helped me troubleshoot an issue I was facing and couldn't find much documentation about it. To my friends...
2017-08-25
10 reads
Responsible Log Growth with dbatools
I love dbatools, and I’ve been trying to explore the various cmdlets over time, both to practice my PoSh and...
2017-09-08 (first published: 2017-08-25)
1,771 reads
SQL Server Replication snapshot initialization taking long time to be applied
Hello all,
In today's post I want to share a tip that helped me troubleshoot an issue I was facing and...
2017-08-25
4,280 reads
Friday Reading 2017-08-25
Great week this week as I’ve been selected to speak at 4 of the SQL Relay events in October! Really...
2017-08-25
332 reads
Microsoft Azure – How to check details about Azure VM sizes using PowerShell
In this blog we will discuss about how to check the details about Azure VM tiers and sizes. Microsoft Azure...
2017-08-25
527 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers