The Curious Case of…. alcoholism
Hello, my name is Paul, and I’m a high-functioning alcoholic. For the last ten years or so, I’ve been an alcoholic. A maintenance drinker – with no nasty behavior, abuse, day-drinking, DUIs, or things like that – just drinking too much in the evening a …
Using Virtual Network Data Gateways to Secure Access to Azure SQL in Power BI
Power BI and Azure are two related services, but with a considerable independence between them. Power BI share the Azure Tenant for security management, but in relation to networking, they are in completely different environments. Frequently Power BI n …
This is the Last Week of Free PowerShell Training.
You’ve been working hard all month to get through our newest class, Fundamentals of PowerShell for DBAs. This week, it all starts to come together as you put together PowerShell plus SQL Server to automate tasks on a regular basis: March 27, Mon: …
How to use the SQL WHERE Clause with Examples
The post How to use the SQL WHERE Clause with Examples appeared first on SQLServerCentral.
Passing parameters to query without TVFs
Problem Statement You have a need to extract data from a table or view with 1 or more parameters. The challenge is that the parameter changes based on various factors. The solution often is to write this, not as a view, but as a Stored Procedure or a …
Database Monitoring: The ROI of Build vs. Buy
The post Database Monitoring: The ROI of Build vs. Buy appeared first on SQLServerCentral.
How to Connect SQL Server and Create C# Objects for Data Management
If you’re a developer or a database administrator, you undoubtedly know that SQL Server and other relational database management systems are among the most popular tools for data management. Isn’t it time to enhance your knowledge of the subject? The B …
Thought Leadership resource page
The post Thought Leadership resource page appeared first on SQLServerCentral.
SQL Server, Oracle and PostgreSQL Database Security Roles, Schemas, Grants, Privileges and Owners – Part II
The post SQL Server, Oracle and PostgreSQL Database Security Roles, Schemas, Grants, Privileges and Owners – Part II appeared first on SQLServerCentral.
Office Hours: Questions That Didn’t Make the Cut
Sometimes, y’all post questions at https://pollgab.com/room/brento and they don’t get a lot of upvotes, and reading through ’em, I bet it’s because other people don’t quite understand what you’re asking. I think ther …
[Video] Office Hours in Cartagena, Colombia
Before heading out to Old Town for sightseeing, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:44 Haydar: Is there a good way to suppress part of TSQL batch from showing the qu …
The future of AI in solving database challenges
The post The future of AI in solving database challenges appeared first on SQLServerCentral.
Paging Data in T-SQL
Sometimes when working with very large sets of data, you may not want to return all of the data at once. I discussed using TOP in my previous article, which allowed you to only get a number of rows from the start of the results from a query. However, i …
It’s Monday. Do You Know Where Your PowerShell Training Is?
You’re over the hump! Just two weeks left to go. All month long, I’m giving away our newest class, Fundamentals of PowerShell for DBAs. Here’s what you’ll be learning this week: March 20, Mon: Parameters and Error Handling and D …
ChatGPT and PowerShell – Some practical examples
Introduction to ChatGPT and PowerShell In this article, we will show how to work with ChatGPT and PowerShell. In previous articles, we chat with ChatGPT, which is an extremely powerful language model with advanced AI, able to do a lot of tasks and code …