Azure SQL Database high availability
In this blog I want to talk about how Azure SQL Database achieves high availability. One of the major benefits from moving from on-prem SQL Server to Azure SQL...
2018-08-22
138 reads
Blog Posts
Azure SQL Database high availability
In this blog I want to talk about how Azure SQL Database achieves high availability. One of the major benefits...
2018-08-22
799 reads
Format Query as JSON
JSON (JavaScript Object Notation) is a file format used to transmit data from various applications, very similar to XML, it also used to stored NoSQL unstructured data, and because...
2018-08-22
5 reads
How to cause a simple spill to tempdb
Sometimes it’s useful to know how to cause a problem. Maybe you’ve never encountered the problem, and want to get hands-on experience. Maybe you’re testing a monitoring tool, and...
2018-08-22
15 reads
Is a SELECT statement always executed?
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-08-22
186 reads
Snapshot Agent Acquires schema modification (SCH-M) lock on all the articles of a publication
As the business requirement, It is very common to see a request for adding a new article or subscription to...
2018-08-22 (first published: 2018-08-06)
2,021 reads
SQL in the City, Fall 2018 – Join Us!
SQL in the City is coming up, and it's a huge opportunity to learn. Register now to attend the free online streamed event, and join the Redgate team in...
2018-08-22
8 reads
Distributed cache service stuck in started & Provisioning on CA page
Hello Readers,
As per Previous article, i tried to explain configuration of Distributed Cache in SharePoint 2013 environment. Same follows for...
2018-08-21
990 reads
FizzBuzz and Multiple Recursive Member CTEs
Watch this week's video on YouTube
Last week I needed to write a recursive common table expression. I've written them before, but it's been a while and needed to visit...
2018-08-21
10 reads
FizzBuzz and Multiple Recursive Member CTEs
Watch this week's video on YouTube
Last week I needed to write a recursive common table expression. I've written them before, but it's been a while and needed to visit...
2018-08-21
9 reads
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
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...
How Accounting Assignment Help Improved My Academic Performance
I recently used accounting assignment help, and it made a huge difference in my...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers