SQL Server 2014 Management tools
Management tools play a vital role in enterprise database management. This is because the well-integrated tools extend the administrator’s capabilities,...
2014-05-30
2,807 reads
Blog Posts
SQL Server: Database Design Basics
In this article, you will learn about database design concepts. The database design concepts discussed in this article focus almost...
2014-05-30
1,710 reads
The Week in Awesome – Plugins, Cars, Food, and France
This week in awesome: Denny Cherry – our own @mrdenny – has created a Password Vault WordPress plugin. That looks seriously cool....
2014-05-30
1,094 reads
Types of Join in SQL Server
You use a join to combine data from different tables into a single result set. Joins most commonly use foreign...
2014-05-30
1,625 reads
Can you partition a temporary table?
Reading that title, you might sit and wonder why you would ever want to partition a temporary table. I too...
2014-05-29 (first published: 2014-05-23)
3,861 reads
Introducing What_To_Compress V2
Hello Dear Reader! I'm about 32,000 feet in the air leaving St. Louis after a great Performance Tuning Workshop for...
2014-05-29 (first published: 2014-05-22)
2,416 reads
Notes From The May 2014 MagicPASS Meeting
Quick notes:
About a dozen people attended, attributed to the combination of having the meeting on a different than usual night...
2014-05-29
1,173 reads
Quick Tips–SSMS Select a vertical block
I saw this years ago in a presentation from Aaron Bertrand. At the time I thought it was super cool...
2014-05-29
1,665 reads
The database principal owns a schema in the database, and cannot be dropped
Problem
You are trying to drop a database user, but are getting the following error message:
The database principal owns a schema...
2014-05-29
2,561 reads
The End of the Mentoring Experiment
Back in April 2011 Steve Jones and I launched The Mentoring Experiment. We had some ideas and some goals, but...
2014-05-29
1,286 reads
Blogs
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
Forums
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers