The release of Analysis Services in Azure means the platform has a future.
There are times when you might want to read backup/restore history information to identify a backup’s start and finish date/time, the location where the backup was written, the size of the database backup, etc. Greg Larsen shows you how to do this in SQL Server.
Today we have a guest editorial from Grant Fritchey that looks at emotions and how they can affect our decision making.
Here is a reference that lets you take a quick look at the new features in SQL Server 2016 and dig into the various items with a collection of links we'll maintain.
Generate an HTML page with the timeline of your SQL jobs using Google graph and sp_send_dbmail
Ahmad Yaseen explains how you can control the number of processors assigned to the SQL Server DBCC CHECKDB command in order to free-up the server's resources.
Preparing for SQL Server presentations is always a challenge. This article provides a few guidelines for the same
Things at work that waste your time are impediments to actually getting work done. Management ought to be in the business of removing as many of these things as possible.
Active Geo-location is powerful magic for ensuring the high availability of a Azure SQL database, and for disaster-recovery. In choosing the best options, you need to accurately understand the value that the business places on the service you're running, long it will take for a secondary replica to be in synch with the primary replica, the importance of spreading the location of replicas widely, and the maximum tolerable unscheduled downtime. Just clicking all the options could prove to be expensive.
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Comments posted to this topic are about the item Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers