(Marcin Policht) In recent years, Microsoft has fully embraced the open source paradigm.
Tag: sql server
How Monitoring Can Help Keep Your SQL Server Estate Secure?
(Pinal Dave) While monitoring might be common practice for keeping databases running smoothly, this is often directed at maintenance tasks such as query performance or future planning.
How do I force a SQL Login to change it’s password on next login
(Kenneth Fisher) Forcing someone to change their password on a periodic basis is a pretty common thing, and any time I’ve gotten a new active directory login I’ve been given an obviously bad password and forced to change my password on the next login. It’s a good idea right?
Deploy SQL Database from Azure DevOps with an ARM Template and DACPAC File
(Ron L’Esteve) Infrastructure differences and inconsistencies between a Dev/Test environment that an application was developed and tested in versus the production environment are common scenarios that IT professionals and Software Developers might encounter.
Create a Custom Container
(Grant Fritchey) Creating a custom container is where things get truly exciting. There’s actually a ton of work and knowledge around this.
The Microsoft Power Platform
(James Serra) The Microsoft Power Platform consists of three products: Power BI, PowerApps, and Microsoft Flow.
T-SQL bugs, pitfalls, and best practices – joins
(Itzik Ben-Gan) This article is the third installment in a series about T-SQL bugs, pitfalls and best practices.
SQL SERVER – The Future of DevOps for DBA
(Pinal Dave) Unless you are living under rocks, you would have heard the word DevOps. I am sure you many of you are working on the DevOps as well and have a clear idea about what is DevOps.
Containers: Working With Volumes
(Grant Fritchey) In the previous two posts on containers I showed how use Docker commands to get an image and create a container.
Local vs Global SQL Server Temporary Tables
(Rick Dobson) Temp tables are temporary in the sense that they exist for as long as the database connection which created and populated them exists. After the connection is closed, the temp table drops from SQL Server.