Finding the Worst Performing TSQL Statement
Greg Larsen explains how you can use Dynamic Management Objects and stored procedures to return your worst performing T-SQL statements.
A Welcome Delay
An open letter to Microsoft from the CEO of Mandriva Linux might not have been the best idea.
Null Defaults
Today Steve Jones asks what default values you might choose for new columns in a table.
Usage of CTE - Trick with Dates
This article exlores the usage of CTEs as a replacement to cursors in order to generate additional data by applying logic to existing data.
Clone a SQL Server login and password to a new server
Bhavesh Patel shows how to clone a SQL Server login onto another server while keeping the password the same.
Configure SSRS with an SSL Certificate
A short demonstration on how to configure Reporting Services (SSRS) with an SSL certificate.
Why I am Excited about SQL Server on Linux
Read why Solomon Rutzky is excited about SQL Server running on Linux.
How to Programmatically Determine Which Edition of SQL Server is Installed
Greg Larsen shows you how to determine if you are running the standard, enterprise, or developer edition of SQL Server.
Stairway to U-SQL Level 13: SQL.MAP
We met SQL.ARRAY in the last step. Now say hello to SQL.MAP, which can store pairs of values.
DevOps and “Shift Left” for Databases
The easiest way of explaining how a DevOps approach to database deployment can dramatically speed up the process is to use the term ‘shift-left’. By performing, or at least...
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
BCA KCU GAJAH MADA No.Telpon 087781685647
Whatsapp 087781685647 Jl. Gajah Mada No.112 B-C-D, RT.1/RW.1, Krukut, Kec. Taman Sari, Kota Jakarta...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers