Considerations for dealing with big databases
Stress everywhere, user wants everything "Para ayer"Photo by Bernard Goldbach
If you are like me, and have SQL Server instances with...
2018-02-01
579 reads
Eduardo Pivaral
- Website: http://www.sqlguatemala.com
Meltdown and Spectre exploits, they can affect your SQL Server instances
A bug was recently discovered on almost every processor made on the last 10 years, and it seems that almost...
2018-01-05
52 reads
Happy new year 2018 to all!
From SQL Guatemala, we wish you a happy new year 2018.
We hope this new year brings you joy and zero:...
2017-12-30
318 reads
SQL Vulnerability Assessment
A very interesting feature was recently added to SQL Server Management Studio 17.4 (SSMS): The new SQL Vulnerability Assessment.
What is...
2017-12-12
135 reads
How to check advanced options in SQL Server?
To check the available advanced options configured at instance level in SQL Server, you need to use the sp_configure system...
2017-11-24
44,561 reads
Finally I am MCSA
I have recently obtained the certification Microsoft Certified Solutions Associate: SQL Server 2012/2014.
I began with this path almost 2 years...
2017-11-20
78 reads
Query to determine mirrored database status
I am sharing today a SQL Script to quickly check on an instance which databases are in mirrored and their...
2017-11-10
6,058 reads
SSIS Basics: Integration Services Catalogs
In the new Project deployment model for SQL Server Integration Services, a new SQL Server database is used to provide...
2017-11-06
229 reads
T-SQL Basics: MERGE Statement
One useful sentence when you need to add data to an existing table from an external source or database, and...
2017-10-06
382 reads
Blogs
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Adding a Local Model to Ollama through the GUI
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Connect resiliently to SQL Server
Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...
Forums
Some query values change when query is run but not others. Why?
Hi everyone I have a 1000 line SQL query that is too long to...
using different credentials when debugging ssis
hi, now and then i want one connection in my ssis pkgs to use...
AlwaysON health check alerts
Comments posted to this topic are about the item AlwaysON health check alerts