Decision tree on the pattern of choosing how to pass data to a procedure
We are often required to pass the data between different database procedures and functions. In this post I will review...
2018-09-06
323 reads
Blog Posts
Format Query as JSON
JSON (JavaScript Object Notation) is a file format used to transmit data from various applications, very similar to XML, it...
2018-09-06 (first published: 2018-08-22)
3,722 reads
How to Get Developers Using Azure
You know the talk out there, everyone is moving to the cloud and people are looking at Azure to get...
2018-09-06
282 reads
Join Me At PASS Summit 2018
The PASS Summit 2018 schedule has been published, and I’m on it twice! On Monday, November 5, I am giving...
2018-09-06
268 reads
Moving On To New Adventures
I am pleased to announce that as of September 10, 2018, I will be part of the SQL Data Partners...
2018-09-06
237 reads
MySQL 8.0 and NDB 7.6
Oracle announced MySQL ndb Cluster 7.6 : in June 2018. Oracle Announces General Availability of MySQL Cluster 7.6 – June 2018 Oracle...
2018-09-06
264 reads
T-SQL: How many bananas tall are you?
So today, this happened: Now I suddenly want to know how many bananas tall I am… https://t.co/7geupBzXDj — MidnightDBA (@MidnightDBA) September...
2018-09-06
315 reads
Apache Hadoop Release 3.1.1 available
Last month Apache Hadoop also release its latest Stable release version Apache Hadoop 3.1.1 which has major improvement in Hadoop system....
2018-09-05
403 reads
Azure SQL Database Read Scale-Out
Read Scale-Out is a little-known feature that allows you to load balance Azure SQL Database read-only workloads using the capacity of read-only replicas, for free. As mentioned in my blog Azure...
2018-09-05
84 reads
Dates and Times in SQL Server: AT TIME ZONE
Continuing the series on dates and times in SQL Server and Azure SQL Database, this week we look at the...
2018-09-05
259 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