Microsoft, Think DevOps First
Steve has a few issues with the design of the Power BI Service and their format for storing reports.
2019-06-22
386 reads
Steve has a few issues with the design of the Power BI Service and their format for storing reports.
2019-06-22
386 reads
A database script caused a large outage for Salesforce. Steve wonders if you have ideas on how to prevent this type of issue in your environment.
2019-06-21
429 reads
2019-06-11
5,970 reads
A good day for a database administrator (DBA) is a lot like a good airline flight. A lot of excitement in either situation is bad. In a perfect world, a DBA will be productive and not spending most of their time “putting out fires.” (And fires are never a good idea on a flight!)
2019-06-10
As database changes are added to the DevOps pipeline, unit testing of those changes becomes crucial. In this article, Adam Hafner describes unit testing and how it applies to databases.
2019-06-06
The number of times that you have a failure when deploying changes is a good metric to watch.
2019-06-03
1,178 reads
Establishing coding standards can help remove blockers to understanding code, improving quality and reducing maintenance. Faris Hilmi explains how having consistently formatted code plays a larger role in database development and how Redgate tools can best equip you for the task.
2019-05-30
These are tough times for businesses in the EU. Is the UK going to be in or out? Quite simply, businesses are finding it difficult to plan anything when everything is up in the air, and no one can confirm what will happen next. All of which is making many businesses wary of making a decision to invest in their IT infrastructure. Enter DevOps.
2019-05-21
For application developers it is unthinkable to work without version control. Yet, only 55% of database developers are version controlling their database changes? Mary Robbins provides six reasons why you should version control your database.
2019-05-13
I spend a lot of time showing how to use tools to automate database deployments in support of DevOps. However, the one message that I always try to deliver...
2019-05-13
By Steve Jones
I published an article today on the Data API Builder, which is a way...
By Steve Jones
dolonia – n. a state of unease prompted by people who seem to like...
By James Serra
Microsoft Fabric is rapidly gaining popularity as a unified data platform, leveraging OneLake as...
Comments posted to this topic are about the item Do As I Say, Not...
Hi Gents, Silly question, but it's been a long time since I've done this....
Hi everyone I have a query that is taking a real long time. It...
I have a detached database from SQL Server 2019, called TDE_Primer. This database had a 100MB data file and a 73MB log file. The log file was lost, so I need to run this code:
USE [master] GO CREATE DATABASE [TDE_Primer] ON ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\TDE_Primer.mdf' ) FOR ATTACH_REBUILD_LOG GOHow big is the new log file? See possible answers