How to Start Speaking
At the last few events I attended, I’ve gotten into conversations on how to begin as a speaker. So I...
2018-10-17
332 reads
Blog Posts
Pagination pattern or how to fetch a large dataset for a web report.
In this post we will discuss how to fetch data from a large dataset for web applications using pagination technique....
2018-10-17
414 reads
SQL Server Data Collection and Management Data Warehouse
We all have the need to collect system and performance information regarding our SQL Servers. Some of us use third-party...
2018-10-17 (first published: 2018-10-03)
3,304 reads
2018-10-17
206 reads
What is the Object Explorer Details tab good for?
For a long time there I would see the Object Explorer Details tab show up when I opened SSMS (SQL...
2018-10-17
285 reads
Azure SQL Database Hyperscale
At Microsoft Ignite, one of the announcements was for Azure SQL Database Hyperscale, which was made available in public preview October 1st, 2018 in 12 different Azure regions. SQL Database Hyperscale is...
2018-10-16
80 reads
Conditionally Returning Rows Based On Query Results
Watch this week's video on YouTube
While I normally prefer formatting my query results in a downstream app/reporting layer, sometimes I can't get around adding some business formatting logic to...
2018-10-16
52 reads
Conditionally Returning Rows Based On Query Results
Watch this week's video on YouTube
While I normally prefer formatting my query results in a downstream app/reporting layer, sometimes I can't get around adding some business formatting logic to...
2018-10-16
4 reads
Data Factory V2 Activity Dependencies are a Logical AND
Azure Data Factory V2 allows developers to branch and chain activities together in a pipeline. We define dependencies between activities as...
2018-10-16 (first published: 2018-10-03)
1,852 reads
Database Transaction log file full in the full recovery model
AdvertisementsI am seeing in more environment the database recovery model is set FULL and there is no transaction log backup...
2018-10-16
293 reads
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