My #GitHub repos have come a long way since this one for #AzureSynapse.

I now have some for #sqlserver and #MicrosoftFabric as well, which have been spotted out in the wild.

Plus, a lot of them have populated wikis.

If you do use any of them feel free to give them a star in #GitHub #AzureDevOps #GitHubActions

https://github.com/kevchant

What are all the methods you can use to install #sqlserver?
1. Basic click-thru
2. Setup.exe w/Configuration File
3. Dbatools: Install-DbaInstance
4. Chocolatey: choco install sql-server-2022
5. SqlServerDSC
6. Ansible ( via SqlServerDSC/Dbatools )
7. Docker container
...

SentryOne is a monitoring suite for #SQLServer and other databases.

Its UI was designed by a Cenobite.

#sqlserver #azuredevops Is anyone using #azuredevops to deploy database changes? What has been your experience? What successful strategies did you use to deploy db changes.

@pmpjr
The #sqlserver and #sqlfamily crowd is quite active over there. I just got on there last week and don't have any invites yet, but once I do, I will share here. Right now it is okay. Not seeing a lot of political posts, which is good, but it is young, and it all depends on who you follow.

Spent quite a chunk of time in the #SaltMine too. Not really used to that. Kinda like my time off! I'm pretty comfortable with the tech stack ( #Blazor, #CSharp, #SQL, #SQLServer), so I spent some time getting the work project set up and running. Spent way too long setting up a Linked Server to a local Access database. Googling for answers brought in too many crazy "answers". So annoying. The actual solution was pretty easy.

The latest release of PSBlitz:
- has been updated with the latest sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, sp_BlitzLock, and sp_BlitzWho, from Brent Ozar's August release of the First Responder Kit
- outputs execution plans for queries involved in deadlocks if they are still in the cache.
- adds a new report page containing deadlock-related execution plan info

https://github.com/VladDBA/PSBlitz

#sqlserver #sqldba #powershell #microsoftsqlserver #mssqlserver #mssql #mssqldba #PSBlitz

It's a busy week. Today we're announcing the general availability of the end-to-end Azure portal experience to deploy a multi-subnet Availability Group for SQL Server on Azure VMs. #AzureSQL #SQLServer https://techcommunity.microsoft.com/t5/sql-server-blog/announcing-general-availability-of-azure-portal-experience-to/ba-p/3912707

I’m Michael and this is my #introduction post.

I am an aspiring #iOSDev who loves working with #Swift and #SwiftUI. I am developing an app called QuizFolks.

#Running is my favourite exercise, but I also love #walking, #core, #strength, #hiit - I very much like using Apple’s #FitnessPlus service.

I’m married to the most excellent woman, who makes me a better person. She is also a bit geeky like me 😀

Professionally, I’m a Microsoft #SQLServer chap, working in the data warehouse domain.

Announcing a new public preview of enhanced patching for SQL Server on Azure VMs using Azure Update Manager. SQL Server CUs can be patched automatically with this service. #SQLServer #AzureSQL https://techcommunity.microsoft.com/t5/sql-server-blog/announcing-public-preview-of-enhanced-patching-for-sql-server-on/ba-p/3911776

Sync.com comes close to solving this problem for us, but it is not really designed for that. Looking for something that all members of the DevOps team could access (we are a remote team), but that the server could access as well. So, #SqlServer and #RavenDB would back up to it directly, but we could pull down the backup files locally if necessary. (2/x)

Hi all, updated the below #MicrosoftFabric posts to include the fact that paginated reports are now supported by Microsoft Fabric Git integration #PowerBI #SQLServer

https://www.kevinrchant.com/2023/05/24/spreading-your-sql-server-wings-with-microsoft-fabric/

https://www.kevinrchant.com/2023/05/31/spreading-your-power-bi-wings-with-microsoft-fabric/

This is just a brief post containing a script to get table sizes in SQL Server, along with some other information like table type, number of records, partition count, compression type, number of nonclustered indexes and their total size.

https://vladdba.com/2023/08/24/script-to-get-table-sizes-in-sql-server/

#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #dba #tsql

Denny Cherry Blogged: Denny Cherry https://www.dcac.com/blog/denny-cherry-associates-consulting-recognized-on-the-2023-inc-5000-for-a-5th-consecutive-year/ #sqlserver

In this post I’ll cover ways of speeding up SELECT COUNT as well as some myths about best practices when it comes to SELECT COUNT.

https://vladdba.com/2023/08/21/speeding-up-select-count-in-sql-server/

#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba

ICYMI: There will be an awesome talk in a couple of minutes.
@Jpomfret will talk about #dbatools and how to manage #replication with them.
Make your #DBA life easier

https://www.meetup.com/de-DE/data-tgif/events/294744117

#SQLServer #PowerShell

/cc @dbatools

New blog post.

My world the past 6 months and the future of SQL Agent Insight.

https://brentec.ca/blog/2023/08/the-last-six-months-and-the-future-of-sql-agent-insight/

#sqlserver #dba #monitoring

New blog post.

The last 6 months and the future of SQL Agent Insight.

https://brentec.ca/blog/2023/08/the-last-six-months-and-the-future-of-sql-agent-insight/

#sqlserver #dba #monitoring

Meagan Longoria Blogged: Meagan Longoria https://www.dcac.com/dcac/quick-tip-about-fonts-in-deneb-visuals-in-power-bi/ #sqlserver

Am I the only one to really prefer #sqlserver #mssql compared to #postgresql and #mysql ? 😆

I love the features, quality of the tooling and backup management.

Just a shame than this one is not open source, and still waiting for ARM support (until that there is Azure SQL edge that is kind of equivalent).

And you what is your favorite and why ?

#developer #sre #devops #dba #database #dotnet #python