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.
2017-02-16
4,920 reads
An introduction to the basics of current SQL Server vs v.Next Performance Testing.
2017-02-15
3,615 reads
Erin Stellato takes a look at the new COMPRESS and DECOMPRESS functions, comparing their impact on space and performance to traditional data compression.
2017-02-15
6,456 reads
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.
2017-02-14
924 reads
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.
2017-02-14
2,023 reads
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.
2017-02-14
3,764 reads
In this article, we will use SSIS to import a CSV file to Azure SQL Data Warehouse.
2017-02-13
1,455 reads
If you are a DBA who hasn't so far dived in head-first into using Azure, it is worth setting up an Azure 'Virtual Lab' environment the easy way, using a template. This will then allow you to experiment, try things out with SQL Azure, and get familiar with Resource Groups. Joshua shows how to build a virtual lab, from the ground up in the first of a series that aims to give you a grounding in Azure.
2017-02-13
5,534 reads
Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.
2017-02-10 (first published: 2015-06-08)
16,753 reads
Using wildcard to find patterns in strings going from the basics to some more complicated conditions.
2017-02-10 (first published: 2015-09-29)
19,256 reads
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers