Format Query as JSON
JSON (JavaScript Object Notation) is a file format used to transmit data from various applications, very similar to XML, it...
2018-09-06 (first published: 2018-08-22)
3,357 reads
SQL Guatemala
Performance Basics: Indexed views
Views help our query writing by simplifying writing the same sentences and/or aggregations over and over again, but it has...
2018-08-17
320 reads
Announcing new Guatemala SQL Server user group
I am very happy to announce that after a long time struggling and filling all the requirements, we were able...
2018-08-16
714 reads
Determine SQL Server Network Protocol Information using T-SQL and DMVs
I have recently started as an author for MSSQLTips.com website, this is an excellent site where you can start writing...
2018-08-09
121 reads
Extended events (XE): Create a simple XE
When someone says still uses SQL Profiler.
Image is taken from hereAn ancient, dark place, a source of many legends and...
2018-07-23
1,503 reads
PowerBI: Implement a What If parameter
Our Guinea Pig DashboardPowerBI is focused on creating interactive, analytical reports, from a lot of different data sources and with...
2018-07-17
122 reads
Display SELECT query or table as HTML
This post is part of #tsql2sday event :)For my current job I support a lot of SQL Servers, they come...
2018-07-10
103 reads
Saving disk space by choosing the correct data type
"Database is almost 4 TB in size, user is complaining on long times for DEV data refresh and high storage...
2018-07-03
1,458 reads
Check instant file initialization and lock pages in memory options
Study your server reports do the work for you!
Instant file initialization and lock pages in memory are 2 windows operating...
2018-06-28
2,368 reads
What it is Page Life Expectancy (PLE)
Which cup will you prefer to go the less
number of times to the coffee maker?image was taken from hereLet us...
2018-06-21
181 reads
Blogs
Daily Coping 1 Feb 2023
By Steve Jones
Today’s coping tip is to decide to lift people up rather than put them...
Tempdb Performance Improvements in SQL Server 2022 are Dramatic
Tempdb is always a topic for me whether it’s in my sessions or blogs...
Recovering a TDE Database Without the Certificate
If you don’t have the backups of the certificate and private key from the...
Forums
Memory Issue With A SQL Server Express 2019 Server Database Application
Hi, I have just moved a DB from an old HP laptop, to a...
Use Zonal RIs for less than 100% utilization?
We’ve been running 400-instance clusters of t3.medium on an on-demand basis during the work...
query multiple sql tables and alert last record written datetime
I'm trying to develop a script that connects to SQL pulls in a list...
Ask SSC