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
568 reads
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
568 reads
A bug was recently discovered on almost every processor made on the last 10 years, and it seems that almost...
2018-01-05
48 reads
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
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
129 reads
To check the available advanced options configured at instance level in SQL Server, you need to use the sp_configure system...
2017-11-24
42,616 reads
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
70 reads
I am sharing today a SQL Script to quickly check on an instance which databases are in mirrored and their...
2017-11-10
5,061 reads
In the new Project deployment model for SQL Server Integration Services, a new SQL Server database is used to provide...
2017-11-06
225 reads
One useful sentence when you need to add data to an existing table from an external source or database, and...
2017-10-06
363 reads
If you're a data analyst drowning in Excel, you know the pain. Endless filtering,...
Here’s a way to centralize management, rotate secrets conveniently without downtime, automate synchronization and...
This may or may not be helpful in the long term, but since I’m...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Comments posted to this topic are about the item Pitfalls to avoid while feeding...
Comments posted to this topic are about the item Column Adds and Drops
I run this batch on SQL Server 2022. What happens?
ALTER TABLE dbo.Accounts ADD AccountAccessType INT GO ALTER TABLE dbo.Accounts DROP AccountAccessType GOSee possible answers