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,742 reads
Eduardo Pivaral
- Website: http://www.sqlguatemala.com
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,638 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
223 reads
Collation considerations to create robust queries
Is your code "This" robust?What is Collation? In short words: are the sorting rules, case, and accent sensitivity properties for...
2018-06-11
196 reads
Add a custom report to SSMS
Maybe some of you don't know this, but to view Report Definition Language reports (RDL) , you aren't forced to use...
2018-05-25
613 reads
Query to determine last statistics update for a database
Statistics are a vital part of SQL Server database engine, these are used for the query optimizer to create query...
2018-05-16
111 reads
Quick charts in SQL Server Operations Studio
Sample chart for quick insightsSQL Server Operations Studio will be a new tool for managing SQL Server, Azure SQL Database,...
2018-05-14
116 reads
Quick tip: Refresh IntelliSense cache in SSMS
If you work with multiple windows or make a change using SSMS to an object, sometimes IntelliSense does not reflect...
2018-05-08
276 reads
Security: Create and view Audit Logs
It is important to have a secure environment, enforcing the least privilege principle in your servers and databases, but this...
2018-04-30
5,411 reads
Quick tip: format source code in html
I run a technical blog, so it is necessary to put code in almost every post. Most of the GUIs...
2018-04-25
96 reads
Blogs
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Forums
BCA KCP Ancol | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Blok A VI No, Jl. Parang Tritis Raya 3B-3C, RT.8/RW.11, Ancol, Kec. Pademangan,...
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers