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
Blog Posts
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
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
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
Azure Cloud “Fear” Busting #4 – Losing Control?
So the decision to move to the cloud has been made but there is a fear from people that once...
2017-08-25 (first published: 2017-08-14)
932 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
I will be speaking at PowerShell Conference Asia 2017
Which better way could I have to launch my blog if not with great news ?!
I am so happy and excited to announce that I will be speaking at PowerShell...
2017-08-25
10 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
MSBuild and Azure SQL Database
I saw a report of a problem building a database with ReadyRoll in Azure SQL Database. This person wanted to...
2017-08-25 (first published: 2017-08-02)
1,609 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
Blogs
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...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
Execute as failure
Security has long been a problem for me. Every time I think I understand...
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers