Data Breach Danger
Is a data breach a danger to those identified in the data. A court says no, but Steve Jones wonders if this is a bad decision.
Unused Indexes - Are they really unused or have they just not been used YET?
Tara explains when index DMVs gets reset by telling a story from her dark past.
The Cost of Switching
With so many companies looking at other platforms, when should an organization consider changing their database? Steve Jones has a few thoughts.
Azure EA Financial Reporting and Granular Access to Data Through the Enterprise
With the billing data from your Azure Enterprise Agreement collected into one database, it is still necessary to break down the costs and provide access to the correct departments and individuals. This is important for chargeback and further analysis. In this article, Feodor Georgiev demonstrates how to provide granular access to the billing data.
Simple way to Import XML Data into SQL Server with T-SQL
In this tip we look at a simple way to import a simple XML document into a SQL Server table.
Caution about Restoring via SSMS v17
A default value has changed in the SSMS v7 restore wizard, and the consequences can be severe.
How Big is Your Transaction Log?
If you are not managing the transaction log space used by a database, the transaction log might grow uncontrollably. With SQL Server 2017 there is a new dynamic management function (DMF) that exposes statistical information about a database transaction log. One of the things you can do with the information returned from this DMF is to determine how full a database transaction log file is.
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers