Whether you are working in a procedural language like PowerShell or in T-SQL, there is something slightly bothersome about having to deal with parameters that are lists, or worse with ranges amongst the values. In fact, once you have a way of dealing with them, they can be convenient, especially when bridging the gulf between application and the database. Phil Factor shows how to deal with them.
An introduction to the basics of current SQL Server vs v.Next Performance Testing.
Today we have a guest editorial that asks what you might do if you knew a hacker was coming after your organization.
Erin Stellato takes a look at the new COMPRESS and DECOMPRESS functions, comparing their impact on space and performance to traditional data compression.
Quality is a driver for productivity. Or so say I. What do you think.
Steve Jones explains how SQL Clone can be used to create multiple copies of a database for different testing scenarios, while using just a fraction of the disk space. For example for developers to experiment in sandbox environments, with full copies of large databases, without the hassle and delays of restoring backups or copying database files.
A data model is far more powerful than simply a set of build instructions for DBAs. It can be used to shape business thought and actions for the benefit of all.
In this edition of Office Hours, Brent, Erik, and Richie discuss AlwaysOn Availability Groups, execution plans, speeding up log shipping, applying wrong service packs, their favourite high availability solutions, and more.
In this article, we will use SSIS to import a CSV file to Azure SQL Data Warehouse.
The GitLab crisis has Steve Jones thinking about two things: competence and care.
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
The DBA life is fraught with pain. Those battles that we endure are mostly...
hi, im not a dba. For a couple of years our dev sql server...
Hello, I would like to ask whether it is technically possible to redirect a...
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Can I set Accelerated Database Recovery on tempdb?
See possible answers