Reblog: December 19 to December 25
Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...
2014-12-26
598 reads
Blog Posts
XQuery – Accessing the Attributes Axis
Working with a sequence of attributes in XQuery is fairly straight forward with the “attribute” axis even if you don’t...
2014-12-26 (first published: 2014-12-19)
1,557 reads
‘Twas 4:45 Friday
‘Twas 4:45 Friday, and all through the office
not a creature was stirring, not even the bosses.
The code was checked in,...
2014-12-25 (first published: 2014-12-16)
5,355 reads
Monitoring Geo-Replication in SQL Azure using DMV's
Monitoring Geo-Replication in SQL Azure using DMV'sDECEMBER 26, 2014Azure SQL Database comes with a host of disaster recovery options. The...
2014-12-25
5,937 reads
Monitoring Geo-Replication in SQL Azure using DMV's
Monitoring Geo-Replication in SQL Azure using DMV's
DECEMBER 26, 2014
Azure SQL Database comes with a host of disaster recovery options. The most robust of these options involves replicating the database...
2014-12-25
287 reads
Transaction Isolation Level Blues
Have you ever had a mental block in one particular area when learning something? It might be the simplest thing,...
2014-12-25 (first published: 2014-12-15)
5,491 reads
Dev Tools: XYplorer (review #1) - Catalog.1
currently on version 14.60
I'm a big fan of finding tools that help automate and streamline things that should are routine...
2014-12-24
1,497 reads
PowerPivot Saga 2: DAX OR function (OR there is something better)
I didn't realize that the DAX OR function only accepts 2 arguments compared with the similar function in Excel where a limit of...
2014-12-24
12,950 reads
SQLSaturday#380 NYC Event Update - Precons, Speakers....
Just wanted to blog a quick update on SQLSaturday#380 in NYC, happening on May 30, 2015. As you are hanging...
2014-12-24
1,292 reads
Tracing call stacks in SQL Server – Introduction
At this fall’s SQLIntersection conference in Las Vegas I attended, Paul Randal’s (t|b)“Performance Troubleshooting Using Latches and Waits” precon. Where at he asked for some assistance compiling data for a...
2014-12-24
8 reads
Blogs
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
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...
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