Free Webcast: Avoiding Deadlocks by Tuning Queries
You’ve been getting more and more deadlock errors, and users are starting to complain. You’re wondering if your queries are the root cause, and if so, what you should do to fix ’em. In a fast-paced session, I’ll explain the 3 ca …
Microsoft Fabric: Loading On-Premises and External Data
Loading On-Premises and external data is a fundamental need for a Data Platform such as Microsoft Fabric. However, during this preview stage, Microsoft Fabric brings many surprises (and, should I say, deceptions?) in this area. This blog may explain a …
How to export data to SQL Server using Bard (Google chatbot)
The article will explain how to export data to SQL Server with Bard can be challenging. Previously, we talk about Bard. Bard is a chatbot like ChatGPT created by Google. In this article, we will learn how to export data from different sources like JSON …
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 …