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
535 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
535 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
313 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
121 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
37,654 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
67 reads
I am sharing today a SQL Script to quickly check on an instance which databases are in mirrored and their...
2017-11-10
2,933 reads
In the new Project deployment model for SQL Server Integration Services, a new SQL Server database is used to provide...
2017-11-06
212 reads
One useful sentence when you need to add data to an existing table from an external source or database, and...
2017-10-06
315 reads
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
By Steve Jones
ioia – n.the wish that you could see statistics overlaid on every person you...
First off, my apologies for what could potentially be a bad title! I am...
I've inherited a couple of rather large databases from my ex-colleague when I join...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers