Don't underestimate the ERRORLOG. There is some great information in it for you to use not just when you're troubleshooting performance or investigating errors, but also when you're proactively monitoring an instance. Erin Stellato explains.
2015-08-12
3,517 reads
With the recent acquisition of Datazen by Microsoft, if you have SQL Server 2008 or later Enterprise Edition with Software Assurance, you can leverage (download and use) Datazen to create visually appealing dashboards for mobile devices across all the major platforms at no additional costs. In this article series Arshad Ali will demonstrate how you can use Datazen for creating dashboards and KPIs (Key Performance Indicators) for mobile devices easily and quickly.
2015-08-11
5,810 reads
It is sometimes hard to keep up with Microsoft's direction in Business Intelligence. Robert Sheldon takes stock with the Simple BI Timeline which explains how BI has evolved over the years.
2015-08-10
4,879 reads
Temporal tables - also known as system-versioned tables, but not to be mistaken with temporary tables - are a new feature of SQL Server 2016 that allow SQL Server to automatically keep a history of the data in the table. This tip from Koen Verbeeck introduces the new feature by explaining how to create a system-versioned table.
2015-08-07
5,485 reads
The Data-Tier Application Package (DacPac), together with the Data-Tier Application Framework (DacFx), provides an alternative way to automate the process of scripting out, or deploying a SQL Server database, reporting on changes, or checking version-drift. As such, it seems to provide an obvious cost-free start for tackling automated Database Delivery as part of Database Lifecycle Management (DLM). We asked Phil Factor if it is ready for Prime-time.
2015-08-05
5,584 reads
There are unique considerations that apply to virtual machines that run SQL Server workloads in such environments. This document provides insight into considerations and best practices for running SQL Server in Hyper-V Dynamic Memory configurations on Windows Server.
2015-08-04
3,841 reads
SQL Server Database Mirroring offers two methods for exchanging data: synchronously and asynchronously. Sometimes there may be a need to switch between modes for an existing mirror and in this tip we will look at how this can be done.
2015-08-03
3,376 reads
Building (or rebuilding) a Columnstore index can be a resource intensive operation. In this article, Denzil Ribeiro describes the index rebuild process and index maintenance for clustered Columnstore indexes in SQL 2014.
2015-07-31
2,990 reads
Tim Smith looks at what to take into consideration before building a design to archive old data in SQL Server databases.
2015-07-30
2,895 reads
One of the more confusing statistics in Oracle is one called the clustering factor. Associated with an index, it's actually dependent on the table data, more specifically the distance between 'jumps' for a given index key. Commonly, a 'jump' is the number of blocks between rows containing the given index key starting with the first block found containing that key. If that sounds confusing don't despair, David Fitzjarrell explains in detail.
2015-07-29
3,764 reads
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item SQL Server Still Wins
Comments posted to this topic are about the item DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers