10 reasons to choose Flyway
The post 10 reasons to choose Flyway appeared first on SQLServerCentral.
A Beginners Guide to MySQL Replication Part 5: Group Replication
This article is part of Aisha Bukar’s 6 part series on MySQL Replication. The entries include: Part 1: Introduction to MySQL Replication Part 2: Configuring Source and Replicas Part 3: Multi-Source Replication Part 4: Using GTID Based Replication …
Different Ways to Format Currency Output in SQL
The post Different Ways to Format Currency Output in SQL appeared first on SQLServerCentral.
Yet Another Reason to Not Use sp_ in your SQL Server Object Names
In 2012, Aaron Bertrand said most everything I knew (and a bit more) about the issues with using the sp_ prefix. Procedures prefixed with sp_ have special powers when placed in the the master database in that it can be executed anywhere on the server a …
Screen Scraping with Python and BeautifulSoup Code Examples
The post Screen Scraping with Python and BeautifulSoup Code Examples appeared first on SQLServerCentral.
The PostgreSQL Role Part 1
Article Overview In this article, we will cover the PostgreSQL database role object that groups together one or more privileges and can be assigned to users. A role is a collection of permission or privileges that can be granted to one or more users or …
[Video] Office Hours: I Need Your Help with These
Today, I need your help with some of the top-voted questions from https://pollgab.com/room/brento. Chime in in the comments: 00:00 Start 00:52 Accidental DBA: Hello Brent. Thank you for keeping your Q& A sessions entertains and informative. My ques …
Spot the Five Differences and Win a Summit Ticket
Spot all five differences in the two images and enter our prize draw competition to be in with a chance of winning a 3-day pass to PASS Data Community Summit 2023. Click here to enter the contest and we hope to see you in Seattle this November. …
[Video] Office Hours: Really Long (and Really Short) Answers
Today’s batch of questions from https://pollgab.com/room/brento requires some really long answers, and some are right to the point. 00:00 Start 02:13 Eh? Aye…: As DBAs, how can we best prepare for the AI world in terms of data? Should we st …
Sessions for Summit 2023 are now LIVE!
The post Sessions for Summit 2023 are now LIVE! appeared first on SQLServerCentral.
How to secure legacy ASP.NET MVC against Cross-Site (CSRF) Attacks
The post How to secure legacy ASP.NET MVC against Cross-Site (CSRF) Attacks appeared first on SQLServerCentral.
Updated First Responder Kit and Consultant Toolkit for August 2023
Turns out y’all actually work over the summer – there are actually cool new features this month! I think I’m actually going to have to record updated sp_BlitzIndex, sp_BlitzLock, and sp_BlitzQueryStore modules for my “How I Use …
Fabric Lakehouse: Convert to Table feature and Workspace Level Spark Configuration
I have been working as a no-code data engineer: Focused on Data Factory ETL and visual tools. In fact, I prefer to use visual resources when possible. On my first contact with Fabric Lakehouse I discovered to convert Files into Tables I need to use a n …
Learning PostgreSQL With Grant: Introducing VACUUM
While there are many features within PostgreSQL that are really similar to those within SQL Server, there are some that are unique. One of these unique features is called VACUUM. In my head, I compare this with the tempdb in SQL Server. Not because the …
Database Monitoring for Developers
The post Database Monitoring for Developers appeared first on SQLServerCentral.