It greatly pleases me to announce, HAL0003!
I while back as part of a T-SQL Tuesday post I created HAL0001, then later HAL0002 with a long-term goal...
2016-11-23
465 reads
Blog Posts
PowerShell to Test a Query
So you want to do some tuning, but you’re not sure how to test a query on it’s performance. Not...
2016-11-23
1,356 reads
Query tuning 101: How to measure Query Plan I/O cost
If you’re a DBA or a developer chances are you’ve looked at a query plan or two. While looking at...
2016-11-23 (first published: 2016-11-18)
3,322 reads
Restoring a SQL Server backup on Linux
Last Wednesday I got very excited by Microsoft’s announcements about the addition of features to standard edition and the public preview...
2016-11-23
916 reads
SQL Server & Containers – Part Two
This post follows on from SQL Server & Containers – Part 1 and will go through how to build custom container images.
Since...
2016-11-23
674 reads
Comparing and synchronizing Oracle databases
Applies to: xSQL Oracle Data Compare v1.0 - 2.0
As you may have noticed, most of the articles in this blog focus around scenarios and solutions for databases in Microsoft's...
2016-11-22
3 reads
Comparing and synchronizing Oracle databases
Applies to: xSQL Oracle Data Compare v1.0 - 2.0
As you may have noticed, most of the articles in this blog focus...
2016-11-22
557 reads
Getting Team City working with BitBucket
As a part of building a CI/CD home lab, I set up TeamCity in the past. I plan on using...
2016-11-22
1,048 reads
PASS Summit Announcements: PolyBase enhancements
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. I’m writing a set...
2016-11-22
271 reads
Power BI Custom Visuals Class (Module 25 – Scroller)
In this module you will learn how to use the Scroller Power BI Custom Visual. The Scroller has the appearance...
2016-11-22 (first published: 2016-11-14)
1,831 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