SQL Server Row Level Security Deep Dive. Part 2 – Setup and Examples
The previous section in this series was an introduction to Row Level Security (RLS) and some use cases. This section focuses on basic setup of RLS, methods for implementing RLS and performance considerations with those implementations. The RLS access p …
Setting up Drill Through in the New Power BI Report User Interface
The post Setting up Drill Through in the New Power BI Report User Interface appeared first on SQLServerCentral.
Export and Import SSISDB in just a few clicks
From SQL Server 2012 onwards, Microsoft introduced a new deployment model in SSIS called the project deployment model. This new model has many benefits in managing SSIS project deployments, executions, and configurations. Every new version of SQL Serve …
[Video] Office Hours: Overly Caffeinated Edition
After consuming waaaay too much coffee, I went through your top-voted questions from https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 03:53 It’s ‘a me: Is there a feature in SQL that Microsoft abandoned that you wi …
[Video] Office Hours: All About Miles Edition
Today’s webcast featured an awful lot of questions from one particular person who was super-active at https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 00:03 Miles: Hi Brent, I am aware of “sp_statement” compl …
Let’s talk about Artificial Intelligence, ChatGPT and Gobbledegook
The post Let’s talk about Artificial Intelligence, ChatGPT and Gobbledegook appeared first on SQLServerCentral.
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 …