SQL Server Wait Stats Monitoring with PowerShell
In this article we add another module to the PowerShell monitoring process to capture wait stats for all monitored SQL Server instances.
2020-09-15
Articles
SQL Server 2017 Installation Error with KB2919355
Recently I was installing SQL Server 2017 and I could not believe a simple installation took up my whole day. I was installing an instance on one newly built Windows 2012 R2 server. After clicking next a few times, I got an error: a rule failure, for KB2919355. I downloaded the KB2919355 as mentioned in […]
2020-09-14
8,456 reads
Fully Left-Shifted Deployments with Version Control and Automatic Cloning
Discover the future of DevOps! Join Microsoft MVP Kendra Little to see Redgate's recent innovations in action and give you a picture of where Database DevOps is going, and why.
2020-09-14
Storage 101: The Future of Storage
Robert Sheldon wraps up his series on storage by discussing the latest storage innovation and ideas.
2020-09-14
Delete Duplicate Rows with No Primary Key on a SQL Server Table
Every once in awhile a table gets created without a primary key and duplicate records get entered. The problem gets even worse when you have two identical rows in the table and there is no way to distinguish between the two rows. So how do you delete the duplicate record?
2020-09-11
When SQL Server Performance Goes Bad: Implicit Conversions
When you're developing a database, the pressure is on to get something that works, using an efficient algorithm. When you are getting close to a release candidate, however, there are some programming habits that must be removed from the code, because they can cause unexpected performance problems. In this article, you'll learn how to detect and remove one such problem: reliance on implicit datatype conversions in your queries. We'll use a combination of plan cache queries, extended events, and SQL Monitor.
2020-09-11
SCOM Alert: MSSQL 2014: SQL Server cannot authenticate using Kerberos
Learn how to correct an error that is overloading SCOM by fixing an SPN.
2020-09-10
8,264 reads
The Two Ways Containers Will Revolutionize Database DevOps
Containers have already transformed the way application development works, but adoption has been slower for databases. Finally, the revolution is beginning. In this post, Kendra Little shares the two ways in which containers will dramatically change the way teams develop and deploy database changes.
2020-09-10
Half Of You Don’t Understand Variables and Transactions.
Do table variables and variables respect transactions? If we set the value of a variable during a transaction, and we roll it back, what happens?
2020-09-09
Configure SQL Server on Ubuntu 16.04 to use Active Directory Authentication
Learn how to get Windows Authentication working on an Ubuntu SQL Server on Linux instance.
2020-09-08
4,011 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
ALAMAT BCA KCU JAMBI 082225313145 WA CS
WhatsApp 082225313145 Jl. Dokter Sutomo No.50-50A, Ps. Jambi, Kec. Ps. Jambi, Kota Jambi, Jambi...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers