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
327 reads
SQL Guatemala
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
150 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
45,380 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
91 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,640 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
253 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
408 reads
Blogs
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
SQL Server Security Hardening Guide Using the DoD STIG Checklist
Security on your SQL Server is important. That doesn’t need any explaining. But where...
EightKB 2026: Registration is Open!
It’s that time of year again! EightKB is back on August 20th at 13:00...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers