Connect to Salesforce Data as a Linked Server
Use the TDS Remoting feature of the ODBC Driver to set up a linked server for Salesforce data.
What's a Toaster?
There are always generic items that we encounter in life, things where it doesn't seem to matter to each of us what brand/price/model we pick. This Friday Steve Jones asks what you might consider to be generic in your job.
Building SQL ConstantCare®: Analyzing Query Plans
Starting to translate sp_BlitzCache into the cloud.
Display Median Values
DO you know how to display median values from a Dataset? In this short article you will use windowing functions to do this
Managerial Moneyball
Steve Jones notes that the Moneyball phenomenon has come to managers and perhaps a little training and data can help find us better managers.
Be Careful with Key Order in SQL Server Missing Index Recommendations
In this tip we look at the missing index recommendations that SQL Server automatically provides and why you should pay close attention to what is recommended and how you actually implement the new index.
Introduction to Azure Cosmos DB Emulator for Creating Applications
Azure Cosmos DB is Microsoft’s NoSQL database platform running in the cloud. In this article, Suhas Pande explains many of the core concepts in Cosmos DB. Additionally, he goes over how to set up a local Cosmos DB emulator to create collections and documents. Using a local emulator is free and allows development with Cosmos DB without being connected to Azure.
Stairway to SSAS Tabular Level 2: Installing the Components
In this level of the Stairway to SSAS Tabular you will learn how to install the platform and tools.
How to migrate a SQL Server database to a lower version
A tip looking at a one time procedure which we can follow to downgrade the database from a higher version (SQL Server 2012) of SQL Server to a lower version (SQL Server 2008 R2) of SQL Server.
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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...
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