Creating a configurable SSMS script
Several times over the last few weeks I’ve gotten a request to create a new work database. The individuals from ... Continue reading
2021-05-28 (first published: 2021-05-18)
781 reads
SQLStudies
#PowershellBasics: Comments and comment based help
I’ve talked about SQL Server comments before and how important they are. In PowerShell comments are important for all the same reasons and then some. So first of all...
2021-05-13
84 reads
What do you do when technology changes? : T-SQL Tuesday #138
Our host for this month’s TSQL Tuesday is Andy Leonard (blog|twitter). He’d like us to discuss how we handle changes ... Continue reading
2021-05-11
18 reads
All jobs that ran during a given time frame.
Short post today. Simple query that will tell you every job that ran between two datetime stamps. Note: this of ... Continue reading
2021-05-17 (first published: 2021-05-06)
675 reads
SQL Homework – May 2021 – Extended Events.
You’ve probably heard about extended events right? I honestly don’t care if you are #teamProfiler or #teamXE you need to ... Continue reading
2021-05-04
129 reads
WITDC Mental Health and Wellness Day- May 7th
Next Friday WITDC is having a Mental Health and Wellness Day virtual event and I’ll be speaking! I can’t tell ... Continue reading
2021-04-29
27 reads
#PowershellBasics: Setting a variable vs a comparison.
In SQL Server both the set and equality functions are handled by the equals sign (=). For example: Set Equality ... Continue reading
2021-05-10 (first published: 2021-04-27)
408 reads
Right sizing int : T-SQL Tuesday #136
Brent Ozar (blog|twitter) is our host this month, which will make this the most popular #tsql2sday to date I’m sure. ... Continue reading
2021-03-15 (first published: 2021-03-09)
320 reads
What is the CONTROL permission?
One of the most powerful permissions available in SQL Server is control. But what exactly is it? Per BOL: CONTROL: ... Continue reading
2021-01-27 (first published: 2021-01-19)
547 reads
“They need help, we must help.” #forGarethSwan
We just finished a memorial for Gareth Swanepoel. He was an amazing person and someone I wish I’d gotten to ... Continue reading
2021-01-22 (first published: 2021-01-14)
329 reads
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