To meet our database configuration standards we want to make sure that we have only one database transaction log file and more than one data file. In this tip we look at how this can be done using a policy.
Learn how to simplify deployment and maintenance of SQL CLR assemblies by using T-SQL instead of Visual Studio.
With all the talk about Big Data recently, Steve Jones looks at some of the issues with Big Data and how small data might be more important to you.
The easiest ways to maintain and manage slowly changing dimensions is using Slowly Changing Dimension Transformation in the data flow task of SSIS packages.
Research in industry can help a company leap ahead of it's peers. Steve Jones thinks this is a good idea for many companies to engage in and highlights some of the great work being done at Microsoft Research.
The state of cloud computing is confusing and unstable. Steve Jones has a few thoughts about the good and bad things in this industry.
SQL Server filtered indexes can save space and improve performance if they are used properly. Under what circumstances can they be used? When are they most effective, and what sort of performance gain or space-saving is likely? How does a filtered index affect the choice of execution plan? Seth Delconte explores these questions with practical experiments.
Learn how to dynamically load data from ETL load files using SSIS as a shell. The code downloads files from FTP, parses them and loads them into the database.
There is a lot of data out there that is specific to an individual, none more important perhaps than biometric data. Steve Jones writes a bit about the security implications involved in working with this data. (This editorial was originally published on Nov 10, 2008. It is being re-run as Steve is at SQL Bits.)
This tip will demonstrate how to monitor SQL Failover Cluster Instances if they become unbalanced using Windows PowerShell.
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Comments posted to this topic are about the item TempDB Facts I
Comments posted to this topic are about the item Have you done a Mid...
Can I set Accelerated Database Recovery on tempdb?
See possible answers