Azure Advisor
Azure Advisor is a really cool personalized recommendation engine that provides you with proactive best practices guidance on High Availability,...
2016-12-01
314 reads
Blog Posts
Azure pricing
Not a technical post today (not that I am technical) but still an important one. I have been using Azure...
2016-12-01
632 reads
CPU Spikes Caused by Periodic Scheduled Jobs
In this article I’ll show you how to eliminate periodic spikes in the CPU that are caused by the jobs that execute periodically. Figure 1 shows such a situation....
2016-12-01
5 reads
CPU Spikes Caused by Periodic Scheduled Jobs
In this article I’ll show you how to eliminate periodic spikes in the CPU that are caused by the jobs...
2016-12-01
820 reads
CPU Spikes Caused by Periodic Scheduled Jobs
In this article I’ll show you how to eliminate periodic spikes in the CPU that are caused by the jobs that execute periodically. Figure 1 shows such a situation....
2016-12-01
7 reads
CPU Spikes Caused by Periodic Scheduled Jobs
In this article I’ll show you how to eliminate periodic spikes in the CPU that are caused by the jobs...
2016-12-01
260 reads
Documenting databases
Open any book or article about database development and administration, and I can all but guarantee that you will find...
2016-12-01
358 reads
Hey Posh, Are My Services Running?–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-12-01
749 reads
Problem where you can only browse Google websites
Note: not a SQL/BI related post like usual, but since it’s a common issue I want to share my solution...
2016-12-01
533 reads
Retrieving Query Store query performance data through sp_WhatsupQueryStore
This afternoon I tweeted that a new Query Store related stored procedure I created is available: sp_WhatsupQueryStore.This blog post goes...
2016-12-01 (first published: 2016-11-24)
2,535 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers