Performance Tuning Using Extended Events: Part 1
In this article, learn how to identify performance tuning opportunities using Extended Events.
2019-12-06 (first published: 2017-04-20)
5,150 reads
Articles
From Source Control to Database using SQL Compare Command Line
Giorgi Abashidze explains how his team use SQL Compare Command line to automate database deployments for their customers, without having access to the real staging or production databases, merely by using our development database contained under TFS Source Control.
2019-12-06
Understanding Azure Storage Options
The choices found when provisioning storage in Azure can be overwhelming. In this article, Monica Rathbun explains the options to help your organization research which storage might be right for your solution.
2019-12-06
Migrating Column Level Encryption from 2008R2 to Azure SQL Database
A migration to Azure is stuck because of an encryption change in SQL Server. Learn how to get around this by using a certificate for encryption.
2019-12-05
408 reads
Take the 2020 State of Database DevOps Survey – win a new iPad
Redgate’s 2020 State of Database DevOps Survey is open now. Share your views on Database DevOps today for a chance to win a new 65GB iPad Air. Plus, for every entry, Redgate will donate $1 to UNICEF. Take the survey now.
2019-12-05 (first published: 2019-11-12)
UNION vs. UNION ALL in SQL Server
Sometimes there is a need to combine data from multiple tables or views into one comprehensive dataset. This may be for like tables within the same database or maybe there is a need to combine like data across databases or even across servers. I have read about the UNION and UNION ALL commands, but how do these work and how do they differ?
2019-12-05
Free eBook: Performance Tuning with SQL Server Dynamic Management Views
Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.
2019-12-04 (first published: 2013-08-21)
108,349 reads
It's More Than What You Know
I'm a firm believer in keeping your tech skills up to date, as well as your social skills, What better way than attending or presenting at a conference or group meeting. The reason to attend an event I'm very fortunate that my company allows me training days and time for personal development, covering all expenses […]
2019-12-03
1,656 reads
2019-12-03
Query Performance Diagnostics with sp_PerfSQ
This article discusses sp_PerfSQ a diagnostic tool designed to quantify performance features of database queries with active requests. It includes a behavioural parser and can assist in troubleshooting complex performance issues.
2019-12-02
5,265 reads
Blogs
Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 4
By Gerard
This is the fourth and final post in a series about modern Data Lake...
Error message: http://System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value ‘NULL’ to data type int.
I love this error. Primarily because it demonstrates two very important things. Errors matter....
Forums
services not list in sql config mgr
Hi All, On one of the sql server machine, when I open the sql...
Query Slow Result
hi , i getting result of query 65954 rows its take 20 seconds how...
Convert nchar to time and addition functionality
I have a scenario: I have a nchar field which is tagged as start...
Ask SSC