Giorgi Abashidze explains how his team use SQL Compare Command line to automate database deployments for their customers, without having access to the real staging or production databases, merely by using our development database contained under TFS Source Control.
2019-12-06
The choices found when provisioning storage in Azure can be overwhelming. In this article, Monica Rathbun explains the options to help your organization research which storage might be right for your solution.
2019-12-06
Sometimes there is a need to combine data from multiple tables or views into one comprehensive dataset. This may be for like tables within the same database or maybe there is a need to combine like data across databases or even across servers. I have read about the UNION and UNION ALL commands, but how do these work and how do they differ?
2019-12-05
I'm a firm believer in keeping your tech skills up to date, as well as your social skills, What better way than attending or presenting at a conference or group meeting. The reason to attend an event I'm very fortunate that my company allows me training days and time for personal development, covering all expenses […]
2019-12-03
1,956 reads
2019-12-03
There is a lot of information held in SQL Server metadata about your SQL Server procedures, triggers, views and functions. Some of it is valuable, other nuggets are useful and a few are rather dull but worthy. It really all needs to be tied together to tell the full story, especially if you are not able to, or do not want to, query the metadata directly.
2019-12-02
Describes how to view R plots in SSMS and gives a brief introduction to R plotting
2019-11-29 (first published: 2017-05-08)
6,204 reads
Data Filtering | Configurations - In this tip we look at a new feature in Power BI that allows users to filter data in Power BI reports using the new Filter Pane.
2019-11-29
One firm's journey on the road to mastering (or at least attempting) continuous database integration.
2019-11-28 (first published: 2017-05-17)
3,923 reads
Learn how to turn on and use newer SQL Server database recovery option called “Accelerated Database Recover”. Read on....
2019-11-28
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Is there a good syllabus for reading these two together? (Yes, it's called the...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers