Why Can't I Shrink TempDB?
I know, I know....#OMGShrinkingIsBadDontEverDoThatOrElseEtcEtcEtc
We all know that there are simply times you have to shrink some files. There are risks...
2019-01-14 (first published: 2019-01-01)
580 reads
Finding Application Session Settings
One of the underused troubleshooting and performance tuning techniques is to validate the application session settings. Things can work fabulous inside of SSMS, but run miserably inside the application.
Related...
2019-01-01
40 reads
Finding Application Session Settings
One of the underused troubleshooting and performance tuning techniques is to validate the application session settings. Things can work fabulous...
2019-01-01
451 reads
Happy 2019!
As I’m writing this it’s actually still 2018, so this is both my last blog post of the year and the first blog post of the new year ??...
2019-01-01
15 reads
The most-read posts in 2018
Good morning #sqlfamily folks! The very first post in the new year 2019. Tell me: when this time passed??? The...
2019-01-01
206 reads
An error occurred while writing an audit trace. SQL Server is shutting down
There was this incident at one of the clients in recent past. It was a nice morning. I was enjoying the tea of the day. I just started my...
2019-01-01
56 reads
Using Microsoft Learn
I’ve just signed up on Microsoft’s new learning opportunity Microsoft Learn. The main categories are Azure, Business Apps, and Windows...
2018-12-31
445 reads
Happy New Year, Here are our Most Popular Posts of 2018
Firstly, all of us at SQL Undercover would like to wish you a very Happy New Year and all the...
2018-12-31
248 reads
Finding Installed Event Sessions
Get off that arctic island and warm up with a little XE fun. This script is quite simple but will show you what you may have out there on...
2018-12-31
12 reads
Finding Installed Event Sessions
As a DBA, it is not uncommon to feel like you are marooned off on some tiny little island trying...
2018-12-31
216 reads
Blogs
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCU JOMBANG Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
Layanan BCA KCP Pemalang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Jend. Sudirman No.6, Mulyoharjo, Kec. Pemalang, Kabupaten Pemalang, Jawa Tengah 52313
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers