Meagan Longoria

Semantic Link Labs: A Key-player in Power BI Automation

, , , ,

Setting page visibility and the active page are often overlooked last steps when publishing a Power BI report. It’s easy to forget the active page since it’s just set to whatever page was open when you last saved the report. But we don’t have to settle for manually checking these things before we deploy to […]

The post Modify Power BI page visibility and active status with Semantic Link Labs first appeared on Data Savvy.

TSQLTuesday #188 – The Recap of Growing the Younger Data Community and Speakers

  Earlier this month, we hosted T-SQL Tuesday and chose the topic of Growing the Younger Data Community and Speakers.  Today, I bring you a summary recap of everyone who shared their thoughts on this subject with links to their…

TSQLTuesday #188 – Growing the Younger Data Community and Speakers

This month, I am hosting T-SQL Tuesday for the very first time. T-SQL Tuesday is a monthly blog party created by Adam Machanic in 2009. I want to give Steve Jones a shout-out for allowing me to host this month's edition. Each month, a…
Microsoft Fabric Mirroring changes the game with Data Ingestion giving you near real-time data with a no-code framework

Fabric Mirroring is Changing the Game for Data Ingestion

,
Microsoft’s Fabric Mirroring will change how you perform data ingestion. If you are using products to automate batch processes for data dumping, did you know that Fabric Mirroring might remove the need for these tools and provide you with…

Standard Developer Edition is added to SQL Server 2025

With the release candidate of SQL Server 2025, which came out last week, I want to discuss a valuable feature you won’t see in the Microsoft press release: SQL Server 2025 Developer Standard Edition. Microsoft is finally addressing a long-standing … Continue reading →

The post SQL Server 2025 Standard Developer Edition appeared first on SQL Server Consulting & Remote DBA Service.

Austin, Texas Best SQL Server Training in 2025

,

If you’re looking to master SQL Server, Power BI, or Microsoft Fabric, attending the SQL Saturday event in Austin, Texas, is one of the smartest moves you can make for your career. Note: Austin, Texas, is hosting their event on … Continue reading →

The post Austin, Texas Best Microsoft Technical Training Oppertunity appeared first on SQL Server Consulting & Remote DBA Service.

PreviousNext

Procure SQL’s Weekly Digest – February 28, 2024!

Here are some news, videos, tips, and links the Procure SQL team would like to share! Scan vs. Seek The most straightforward example explains the difference between a scan and a seek in execution plans. Data Engineering with…

Procure SQL’s Weekly Digest – February 21, 2024!

Here are some news, videos, tips, and links the Procure SQL team would like to share!   Near Zero Downtime Migrations Near zero downtime migrations are why Azure SQL Databases can be a subscriber for transactional…

Procure SQL’s Weekly Digest – February 14, 2024!

Here is some news, videos, tips, and links the Procure SQL team would like to share! Procure SQL made it out to their first trade show of 2024! Justin, Kon and John were at SQL Saturday Atlanta BI on February 10th. Justin Cunningham…

Procure SQL’s Weekly Digest – February 7, 2024!

Here are some videos, tips, and exciting links the Procure SQL team would like to share! MLB's Databases Have you ever wondered about what MLB teams name their databases? We like "the fish bag," "ground control," and "MITT." What…

Procure SQL’s Weekly Digest – January 31, 2024!

Here are some videos, tips, and exciting links the Procure SQL team would like to share! Xbox and SQL Server Learn how Xbox reduced patching downtime significantly in their SQL Server environment. Fabric Common Tasks with Python Are…

Procure SQL’s Weekly Digest – January 24, 2024!

Here are some videos, tips, and interesting links we have viewed at Procure SQL. Comparing NULLS Struggling to compare many columns that contain null values? Here is a great way to do so before SQL 2022; here is a newer way with SQL…

Procure SQL’s Weekly Digest – January 17, 2024!

Hopefully, everyone is back into the swing of things as we are in the middle of week three of 2024! Here are some videos, tips, and interesting links we have viewed at Procure SQL. The Feature That Should Have Been Scrapped If you…

Procure SQL’s Weekly Digest – January 10, 2024!

Hopefully, everyone is back into the swing of things as we are in the middle of week two of 2024! Here are some videos, tips, and interesting links we have viewed at Procure SQL. Free Government Data Russ Loski helps us understand…

Procure SQL’s Weekly Digest – January 3rd, 2024!

Happy New Year! We hope everyone had a happy holiday season. Here are some videos, tips and links we found interesting at Procure SQL. Developer's Still Love Free Stuff! Stack overflow's 2023 survey shows that developers like free…
PreviousNext

TSQLTuesday #188 – The Recap of Growing the Younger Data Community and Speakers

  Earlier this month, we hosted T-SQL Tuesday and chose the topic of Growing the Younger Data Community and Speakers.  Today, I bring you a summary recap of everyone who shared their thoughts on this subject with links to their…

TSQLTuesday #188 – Growing the Younger Data Community and Speakers

This month, I am hosting T-SQL Tuesday for the very first time. T-SQL Tuesday is a monthly blog party created by Adam Machanic in 2009. I want to give Steve Jones a shout-out for allowing me to host this month's edition. Each month, a…
Austin Texas SQL Saturday

Austin Texas SQL Saturday was a Success!

Austin Texas SQL Saturday was a Success! Austin Texas SQL Saturday was a success! Procure SQL would not exist if it wasn't for #SQLFamily and the SQL Community. Therefore, we always want to help connect, share and learn with our local data…
Make Your Queries Go Faster

SQL Saturday Jacksonville Sponsors

Procure SQL is proud to be speaking and sponsoring SQL Saturday Jacksonville this weekend. Join us and several other amazing community speakers as we all share our knowledge with the community. The event will be on Saturday, May 14th, 2022,…
Make Your Queries Go Faster

Getting Started with SQL Server Performance Tuning

Watch! Getting Started with Performance Tuning Have slow queries and want to get down to the basics of learning some fundamentals for performance tuning? If so, John Sterrett is giving an talk at the Nashville User Group (Online) tomorrow.…
Procure SQL September 2018 Training Opportunities

September 2018 Training Opportunities

, ,
The Procure SQL team is out and about in September, sharing their knowledge for free at SQL Saturdays as well as online webinars!  We are very proud of our team and their efforts to share knowledge and experiences.  Be sure to say hello…

SQL Saturday Houston 2018

, , ,
We are back this year!  Not only are we sponsoring SQL Saturday Houston, we are also speaking!  All three of us are presenting!  Go here to see the full schedule. What is SQL Saturday? SQL Saturday is a free training event for Microsoft…

Four Tips for Entry-Level and Experienced IT Professionals

John Sterrett shares his thoughts on successfully transitioning to an entry-level IT job. Recently, I worked with  AITP to share some tips that helped me successfully transition from a Computer Engineering student at the University of Oklahoma…

My SQL Saturday Firsts

In October 2011, after working with SQL Server since 1998, I discovered something called SQL Saturday and PASS. For those unaware, these are local events, setup and run by volunteers. Speakers come in from all parts of the country to share,…
PreviousNext
Microsoft Fabric Mirroring changes the game with Data Ingestion giving you near real-time data with a no-code framework

Fabric Mirroring is Changing the Game for Data Ingestion

,
Microsoft’s Fabric Mirroring will change how you perform data ingestion. If you are using products to automate batch processes for data dumping, did you know that Fabric Mirroring might remove the need for these tools and provide you with…
John Sterrett from ProcureSQL attend the 2025 Microsoft Fabric Conference

Microsoft Power BI to Microsoft Fabric: Are You Ready for the Transition?

,
In 2023, Microsoft announced its new platform, Microsoft Fabric, an innovative product that combined Microsoft Power BI, Azure Synapse Analytics, Azure Data Factory, Fabric SQL Databases, and Real-Time Intelligence into one platform. Over…

Standard Developer Edition is added to SQL Server 2025

With the release candidate of SQL Server 2025, which came out last week, I want to discuss a valuable feature you won’t see in the Microsoft press release: SQL Server 2025 Developer Standard Edition. Microsoft is finally addressing a long-standing … Continue reading →

The post SQL Server 2025 Standard Developer Edition appeared first on SQL Server Consulting & Remote DBA Service.

John Sterrett from ProcureSQL attend the 2025 Microsoft Fabric Conference

The CIO’s Guide to Leveraging Microsoft Fabric for Competitive Advantage

,
I attended the Microsoft Fabric conference for the first time last week. I wanted to provide a guide that CIOs and CEO's could leverage to understand how they could utilize these new announcements at the 2025 Fabric Conference to obtain a competitive…

Pain free way to identify if SQL Server is the root cause or symptom

In this six-minute video, Allen Kinsel shares multiple ways to quickly determine whether SQL Server is the root cause or a symptom of your performance problem.   Demo Code /* See all requests */ select * from sys.dm_exec_requests…

Streamlining Data Analytics with Data Pipelines and a Data Lake

AI analytics today allow us to break down and analyze all parts of a business. Today, we will quickly talk about using a data lake and data pipelines to help streamline data analytics. Every internal and external interaction can be scrutinized…

Ignite 2024 Cliff Notes

AI in the Boardroom: Turning Data into Strategic Insights

For every company in America, there are thousands of different variables that can positively or negatively affect its finances. Today we will focus on leveraging Decomposition Trees, Anomaly Detection, Key Influencers Charts to turn your data…
Microsoft Entra Authentication is A Superior Alternative to SQL Server Authentication

Microsoft Entra Authentication: A Superior Alternative to SQL Server Authentication

Securing data access is paramount for organizations of any size. Nobody wants to be the following data security leak that goes viral. Adopting robust authentication methods that enhance security, streamline user experience, and simplify…
PreviousNext
SQL Saturday Austin Feb 24 and 25 2023

SQL Saturday Austin, Texas – Free SQL Training

,
SQL Saturday Austin is coming to Austin Texas. That's right, you heard it here first! Free SQL Server training in Austin, TX! SQL Saturday Austin Free Training on Feb 24th and Feb 25th SQL Saturday Austin is Feb 24th and 25 We hope…
SQL Server 2022

SQL Server 2022 What is New?

,
SQL Server 2022 was announced yesterday at Microsoft's Ignite Conference. Here are some of the items that caught our attention. This includes SQL Server 2022 Announcements and other announcements around the Microsoft Data Platform. https://www.youtube.com/watch?v=ncF-zFzBDAY Bob…
Procure Microsoft Gold Partner

It’s official

Procure SQL has achieved Gold Partner Status with Microsoft for its Cloud and Database Platform capabilities. As a member of Microsoft’s Gold-Certified Partnership, we’ll have access to Microsoft’s newest products and…
Procure SQL September 2018 Training Opportunities

September 2018 Training Opportunities

, ,
The Procure SQL team is out and about in September, sharing their knowledge for free at SQL Saturdays as well as online webinars!  We are very proud of our team and their efforts to share knowledge and experiences.  Be sure to say hello…

SQL Saturday Houston 2018

, , ,
We are back this year!  Not only are we sponsoring SQL Saturday Houston, we are also speaking!  All three of us are presenting!  Go here to see the full schedule. What is SQL Saturday? SQL Saturday is a free training event for Microsoft…
Procure SQL Procure SQL welcomes Jay Falck!

Procure SQL welcomes Jay Falck!

 Procure SQL is proud to announce that Jay Falck has joined our team!  Jay brings a wealth of knowledge, wisdom, experience, and levity to our group. How it all started. Jay’s love of all things computer started his sophomore year…

Come See Us at Houston TechFest 2017!

,
ProcureSQL is proud to be a first-time sponsor for Houston Techfest 2017.  We would love to see you at this years Houston Techfest!  The admission is FREE!  You can register here.  The complete agenda is posted on their facebook…

Speaking at Microsoft Ignite 2017

,
We are proud to announce that John Sterrett will be speaking at Microsoft Ignite. This will be John's first time speaking at the Microsoft Ignite conference. John will be talking about migrating existing databases over to Azure.  If you are…

Angela Tidwell is our Marketing Database Administrator

Procure SQL LLC is pleased to announce its recent hire of Angela Tidwell, who will join the Procure SQL team as a Marketing Database Administrator working remotely from Austin, TX. Within these roles, Angela will focus on marketing, social…
PreviousNext

Fabric Lakehouse Schemas: Your Data’s New Best Friend

,
In this post, we will cover a new feature in preview for Microsoft Fabric: Lakehouse Schemas. If your Lakehouse is drowning in a sea of unorganized data, this might just be the lifeline you've been looking for. The Data Chaos Conundrum We've…

Azure VMs – How To Go Green

This article will help guide you to go green with your Azure VMs and save some green! ???? When building a cloud solution, many different items need to be considered. One of these items, which will help guide you in the right direction,…
SQL Server 2022

Replay in the Cloud

, ,
Replay like a Rockstar! Want to save money, validate performance, and make sure you don't have errors while migrating to Azure SQL Database, Azure SQL Managed Instance, SQL Server RDS in Amazon AWS? In this video, you will learn how…

Import Databases to Azure SQL Database

, ,
I recently spoke at a conference and was asked what is the easiest way to import databases to Azure SQL Database. Therefore, I wanted to share how I do this with DBATools.io. You can use the same code to just export if you need a local copy…

Does Automation Kill the DBA “Store”?

,
In my opinion, automation will enhance DBAs.  It will allow DBAs to provide more value to the business.Good DBAs will be fine. If you are a DBA with ten years of DBA experience who just repeats year one ten times, this might be a different…
PreviousNext

TSQLTuesday #188 – The Recap of Growing the Younger Data Community and Speakers

  Earlier this month, we hosted T-SQL Tuesday and chose the topic of Growing the Younger Data Community and Speakers.  Today, I bring you a summary recap of everyone who shared their thoughts on this subject with links to their…

TSQLTuesday #188 – Growing the Younger Data Community and Speakers

This month, I am hosting T-SQL Tuesday for the very first time. T-SQL Tuesday is a monthly blog party created by Adam Machanic in 2009. I want to give Steve Jones a shout-out for allowing me to host this month's edition. Each month, a…
Austin Texas SQL Saturday

Austin Texas SQL Saturday was a Success!

Austin Texas SQL Saturday was a Success! Austin Texas SQL Saturday was a success! Procure SQL would not exist if it wasn't for #SQLFamily and the SQL Community. Therefore, we always want to help connect, share and learn with our local data…
Make Your Queries Go Faster

SQL Saturday Jacksonville Sponsors

Procure SQL is proud to be speaking and sponsoring SQL Saturday Jacksonville this weekend. Join us and several other amazing community speakers as we all share our knowledge with the community. The event will be on Saturday, May 14th, 2022,…
Make Your Queries Go Faster

Getting Started with SQL Server Performance Tuning

Watch! Getting Started with Performance Tuning Have slow queries and want to get down to the basics of learning some fundamentals for performance tuning? If so, John Sterrett is giving an talk at the Nashville User Group (Online) tomorrow.…
Procure SQL September 2018 Training Opportunities

September 2018 Training Opportunities

, ,
The Procure SQL team is out and about in September, sharing their knowledge for free at SQL Saturdays as well as online webinars!  We are very proud of our team and their efforts to share knowledge and experiences.  Be sure to say hello…

SQL Saturday Houston 2018

, , ,
We are back this year!  Not only are we sponsoring SQL Saturday Houston, we are also speaking!  All three of us are presenting!  Go here to see the full schedule. What is SQL Saturday? SQL Saturday is a free training event for Microsoft…

Four Tips for Entry-Level and Experienced IT Professionals

John Sterrett shares his thoughts on successfully transitioning to an entry-level IT job. Recently, I worked with  AITP to share some tips that helped me successfully transition from a Computer Engineering student at the University of Oklahoma…

My SQL Saturday Firsts

In October 2011, after working with SQL Server since 1998, I discovered something called SQL Saturday and PASS. For those unaware, these are local events, setup and run by volunteers. Speakers come in from all parts of the country to share,…
PreviousNext

Benchmarking Queries with SentryOne Plan Explorer

,
Today, I want to focus on a free tool that everyone can use when benchmarking queries or performance tuning their queries. This tool is Plan Explorer by SentryOne (I think I will still always know them as SQLSentry). Plan Explorer is another…
Procure SQL Do I need a Backup System Database

Do I Need to Backup System Databases?

, ,
Great question!      Before I answer this right off, ask yourself these questions: “Do I want to lose access to all other databases on the instance?  What would happen if I lose the model my company demands for the specific…
Procure SQL RTO RPO

What is RPO/RTO?

,
Time is money!      Your boss keeps talking about RPO (Recovery Point Objective)  and RTO (Recovery Time Objective).  Do you just nod your head like you know what he/she is talking about?  Maybe that scenario just…

Does Your Database Have any Integrity?

, , ,
Corruption.  We know it is everywhere.  It is surely a hot-button issue in the news.  If you have not given much thought to database integrity, now is the time to sit up and pay attention.  Corruption can occur at any time.  Most of the…

Deep Dive into Bulk Logged Recovery Model

,
    Full disclosure time: Bulk Logged Recovery Model is  quite confusing to me.  And as it seems, to many others.  I wrote a bit about it in SQL Server Recovery Models and decided that it was so complex, I really wanted…
Procure SQL Demystifying System Databases

Demystifying System Databases

, ,
Recently I have heard a lot of people discussing SQL Server System Databases.  The topic of system databases seems to be a deceptively basic one.  But how many people truly take the time to understand what system databases are and what…
Procure SQL - the importance of SQL Saturday

The Importance of SQL Saturdays

, ,
I had the distinct honor of helping John Sterrett (t/b) and Dolph Santorine (t) organize and run SQL Saturday #717 in Wheeling, West Virginia on April 28, 2018.  It was a chance meeting at the event that drove home to me why we invest so…
Procure SQL Validating SQL Server Backups

Validating SQL Server Backups

,
You have your SQL Server Backup Plan and your Database Recovery Model set.  How do you know if your Backups are good? TEST!  Validating SQL Server Backups will ensure that you are in a good place when it is time to bring your database back…

SQL Server Recovery Models

, ,
In my last post (A Beginner's Guide to SQL Server Backups) we discussed the basics of SQL Server Backups. As Backups are the foundation for Recovery, the next logical discussion should be Recovery Models.  For reference, I have included this…
PreviousNext

SQL Saturday Houston 2018

, , ,
We are back this year!  Not only are we sponsoring SQL Saturday Houston, we are also speaking!  All three of us are presenting!  Go here to see the full schedule. What is SQL Saturday? SQL Saturday is a free training event for Microsoft…
Procure SQL SQL Saturday Chicago

SQL Saturday Chicago

,
Last weekend I had a blast speaking at the SQL Saturday in Chicago. It was awesome to share my knowledge and also catch up with some good friends.  My talk was on Automating the Pain Away with Query Store and Automated Tuning.  I hope…

Finding Top Offenders with Extended Events

,
This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing workloads and doing analysis on them. T-SQL or other 3rd party tools like ClearTrace, ReadTrace would be used to aggregate the data to…
Procure SQL Do I need a Backup System Database

Do I Need to Backup System Databases?

, ,
Great question!      Before I answer this right off, ask yourself these questions: “Do I want to lose access to all other databases on the instance?  What would happen if I lose the model my company demands for the specific…

Does Your Database Have any Integrity?

, , ,
Corruption.  We know it is everywhere.  It is surely a hot-button issue in the news.  If you have not given much thought to database integrity, now is the time to sit up and pay attention.  Corruption can occur at any time.  Most of the…
SQL Saturday Austin Free Training

Finding Query Anti-Patterns in Your Developer’s Queries

In the beginning of my IT career, I was a developer. I wrote a lot of bad code that didn't perform well. As more data entered my tables my stored procedures got slower and slower. More data, more problems! I started my career in performance…

Query Store 101

,

Today I heard a great analogy, and it inspired this post. Execution plans are like flight plans, there are multiple flight paths that can be taken to get from where you are to your ultimate destination. Some plans are more efficient than others, and we want to use those whenever possible. How can I make […]

The post Query Store 101 appeared first on dbWonderKid.

SQL Server 2022

SQL Server 2022 What is New?

,
SQL Server 2022 was announced yesterday at Microsoft's Ignite Conference. Here are some of the items that caught our attention. This includes SQL Server 2022 Announcements and other announcements around the Microsoft Data Platform. https://www.youtube.com/watch?v=ncF-zFzBDAY Bob…
SQL Server 2022

Replay in the Cloud

, ,
Replay like a Rockstar! Want to save money, validate performance, and make sure you don't have errors while migrating to Azure SQL Database, Azure SQL Managed Instance, SQL Server RDS in Amazon AWS? In this video, you will learn how…

Benchmarking Queries with SentryOne Plan Explorer

,
Today, I want to focus on a free tool that everyone can use when benchmarking queries or performance tuning their queries. This tool is Plan Explorer by SentryOne (I think I will still always know them as SQLSentry). Plan Explorer is another…

Query Store for Workload Replays

,
Query Store for Workload Replays This month’s T-SQL Tuesday is hosted by Tracy Boggiano. Tracy invites us all to write about adopting Query Store. Today, I wanted to share my favorite but a very unique way I use the Query Store for Workload…

5 Game Changers with SQL Server 2019

,
Microsoft made SQL Server 2019 Generally Available this week we want to share some videos and code examples of our favorite new features. Most of these will make your code go faster without any code changes! We have been testing SQL Server…

SQL Server Implicit Conversions Matter!

While not all implicit conversions are equal implicit conversions matter. For example, just this week I ran into a trivial code change that caused some severe regression in performance. One simple filter change caused a query to consume 227…
PreviousNext

Power BI: Discover What License Is Best for Your Money

Am I choosing the correct license for my budget and needs? In the dynamic realm of Data Analytics, the recent release of Fabric is creating a buzz, leaving professionals eager to explore the features that promise to elevate their data and…

Query Store 101

,

Today I heard a great analogy, and it inspired this post. Execution plans are like flight plans, there are multiple flight paths that can be taken to get from where you are to your ultimate destination. Some plans are more efficient than others, and we want to use those whenever possible. How can I make […]

The post Query Store 101 appeared first on dbWonderKid.

Meagan Longoria

Semantic Link Labs: A Key-player in Power BI Automation

, , , ,

Setting page visibility and the active page are often overlooked last steps when publishing a Power BI report. It’s easy to forget the active page since it’s just set to whatever page was open when you last saved the report. But we don’t have to settle for manually checking these things before we deploy to […]

The post Modify Power BI page visibility and active status with Semantic Link Labs first appeared on Data Savvy.

TSQLTuesday #188 – The Recap of Growing the Younger Data Community and Speakers

  Earlier this month, we hosted T-SQL Tuesday and chose the topic of Growing the Younger Data Community and Speakers.  Today, I bring you a summary recap of everyone who shared their thoughts on this subject with links to their…

TSQLTuesday #188 – Growing the Younger Data Community and Speakers

This month, I am hosting T-SQL Tuesday for the very first time. T-SQL Tuesday is a monthly blog party created by Adam Machanic in 2009. I want to give Steve Jones a shout-out for allowing me to host this month's edition. Each month, a…
Microsoft Fabric Mirroring changes the game with Data Ingestion giving you near real-time data with a no-code framework

Fabric Mirroring is Changing the Game for Data Ingestion

,
Microsoft’s Fabric Mirroring will change how you perform data ingestion. If you are using products to automate batch processes for data dumping, did you know that Fabric Mirroring might remove the need for these tools and provide you with…
John Sterrett from ProcureSQL attend the 2025 Microsoft Fabric Conference

Microsoft Power BI to Microsoft Fabric: Are You Ready for the Transition?

,
In 2023, Microsoft announced its new platform, Microsoft Fabric, an innovative product that combined Microsoft Power BI, Azure Synapse Analytics, Azure Data Factory, Fabric SQL Databases, and Real-Time Intelligence into one platform. Over…

Standard Developer Edition is added to SQL Server 2025

With the release candidate of SQL Server 2025, which came out last week, I want to discuss a valuable feature you won’t see in the Microsoft press release: SQL Server 2025 Developer Standard Edition. Microsoft is finally addressing a long-standing … Continue reading →

The post SQL Server 2025 Standard Developer Edition appeared first on SQL Server Consulting & Remote DBA Service.

Austin, Texas Best SQL Server Training in 2025

,

If you’re looking to master SQL Server, Power BI, or Microsoft Fabric, attending the SQL Saturday event in Austin, Texas, is one of the smartest moves you can make for your career. Note: Austin, Texas, is hosting their event on … Continue reading →

The post Austin, Texas Best Microsoft Technical Training Oppertunity appeared first on SQL Server Consulting & Remote DBA Service.

Legacy Applications: Should They Stay Or Should They Go?

Modernizing Legacy Applications Older legacy systems and legacy applications are crucial to a business's functionality. They're the backbone that holds a business together, whether they are a bank's mainframe holding customer accounts, a factory's…
John Sterrett from ProcureSQL attend the 2025 Microsoft Fabric Conference

The CIO’s Guide to Leveraging Microsoft Fabric for Competitive Advantage

,
I attended the Microsoft Fabric conference for the first time last week. I wanted to provide a guide that CIOs and CEO's could leverage to understand how they could utilize these new announcements at the 2025 Fabric Conference to obtain a competitive…
PreviousNext

Growing New Speakers T-SQL Tuesday #84

What is the best way to start a new career?  Simple, jump in with both feet and start running as soon as you hit the pavement!  Well, that is how I have kicked off my new DBA career!  I was fortunate enough to attend Microsoft PASS…

Enable Multi-Factor Authentication, Please!

This year, several data breaches were caused by multi-factor authentication NOT being enabled. Enable Multi-Factor Authentication, Please! If you ever follow any of our tips, blogs, or videos, please follow this one and enable multi-factor…
Tips for working remotely

Five Tips for Working Remotely

,
The following are five tips for working remotely that I learned over the years from working remotely with large companies like DELL, RDX and now even as a leader of a consulting company that focuses on making our customer's data fast, secure…

John Sterrett: A Microsoft Data Platform MVP

We are proud to announce, as of July 1st, 2016 our very own John Sterrett received the Data Platform MVP award from Microsoft.  The Microsoft Data Platform MVP Award is a great accomplishment for John's involvement in the SQL Server Community…
SQL Saturday Austin Feb 24 and 25 2023

SQL Saturday Austin, Texas – Free SQL Training

,
SQL Saturday Austin is coming to Austin Texas. That's right, you heard it here first! Free SQL Server training in Austin, TX! SQL Saturday Austin Free Training on Feb 24th and Feb 25th SQL Saturday Austin is Feb 24th and 25 We hope…
Tips for working remotely

Five Tips for Working Remotely

,
The following are five tips for working remotely that I learned over the years from working remotely with large companies like DELL, RDX and now even as a leader of a consulting company that focuses on making our customer's data fast, secure…
Procure SQL September 2018 Training Opportunities

September 2018 Training Opportunities

, ,
The Procure SQL team is out and about in September, sharing their knowledge for free at SQL Saturdays as well as online webinars!  We are very proud of our team and their efforts to share knowledge and experiences.  Be sure to say hello…

SQL Saturday Houston 2018

, , ,
We are back this year!  Not only are we sponsoring SQL Saturday Houston, we are also speaking!  All three of us are presenting!  Go here to see the full schedule. What is SQL Saturday? SQL Saturday is a free training event for Microsoft…
Procure SQL - the importance of SQL Saturday

The Importance of SQL Saturdays

, ,
I had the distinct honor of helping John Sterrett (t/b) and Dolph Santorine (t) organize and run SQL Saturday #717 in Wheeling, West Virginia on April 28, 2018.  It was a chance meeting at the event that drove home to me why we invest so…
procure SQL Free SQL Education!

Free SQL Education!

, ,
What is the best way to learn?      The best way to learn is directly from industry professionals!  We are thrilled to be helping the SQLSaturday Wheeling organizers put together a great SQLSaturday, April 28, 2018.  The schedule…

SQL Server Recovery Models

, ,
In my last post (A Beginner's Guide to SQL Server Backups) we discussed the basics of SQL Server Backups. As Backups are the foundation for Recovery, the next logical discussion should be Recovery Models.  For reference, I have included this…

A Beginner’s Guide to SQL Server Backups

, ,
As was discussed in a previous blog, (The Most Important Role of a SQL Server DBA) Backups and Recovery are the cornerstone of all successful SQL Server DBA careers.  Exactly how much attention is paid to backups until something drastic…

Building Your First Always On Availability Group

,
Have you wanted to build an availability group but didn’t know where to start?  If so, we have discounted SQL Server Availability Group training for you! Join us for pre-conference training brought to us by SQL Saturday Nashville!…
PreviousNext
Meagan Longoria

Semantic Link Labs: A Key-player in Power BI Automation

, , , ,

Setting page visibility and the active page are often overlooked last steps when publishing a Power BI report. It’s easy to forget the active page since it’s just set to whatever page was open when you last saved the report. But we don’t have to settle for manually checking these things before we deploy to […]

The post Modify Power BI page visibility and active status with Semantic Link Labs first appeared on Data Savvy.

TSQLTuesday #188 – The Recap of Growing the Younger Data Community and Speakers

  Earlier this month, we hosted T-SQL Tuesday and chose the topic of Growing the Younger Data Community and Speakers.  Today, I bring you a summary recap of everyone who shared their thoughts on this subject with links to their…

TSQLTuesday #188 – Growing the Younger Data Community and Speakers

This month, I am hosting T-SQL Tuesday for the very first time. T-SQL Tuesday is a monthly blog party created by Adam Machanic in 2009. I want to give Steve Jones a shout-out for allowing me to host this month's edition. Each month, a…
Microsoft Fabric Mirroring changes the game with Data Ingestion giving you near real-time data with a no-code framework

Fabric Mirroring is Changing the Game for Data Ingestion

,
Microsoft’s Fabric Mirroring will change how you perform data ingestion. If you are using products to automate batch processes for data dumping, did you know that Fabric Mirroring might remove the need for these tools and provide you with…
John Sterrett from ProcureSQL attend the 2025 Microsoft Fabric Conference

Microsoft Power BI to Microsoft Fabric: Are You Ready for the Transition?

,
In 2023, Microsoft announced its new platform, Microsoft Fabric, an innovative product that combined Microsoft Power BI, Azure Synapse Analytics, Azure Data Factory, Fabric SQL Databases, and Real-Time Intelligence into one platform. Over…

Standard Developer Edition is added to SQL Server 2025

With the release candidate of SQL Server 2025, which came out last week, I want to discuss a valuable feature you won’t see in the Microsoft press release: SQL Server 2025 Developer Standard Edition. Microsoft is finally addressing a long-standing … Continue reading →

The post SQL Server 2025 Standard Developer Edition appeared first on SQL Server Consulting & Remote DBA Service.

Austin, Texas Best SQL Server Training in 2025

,

If you’re looking to master SQL Server, Power BI, or Microsoft Fabric, attending the SQL Saturday event in Austin, Texas, is one of the smartest moves you can make for your career. Note: Austin, Texas, is hosting their event on … Continue reading →

The post Austin, Texas Best Microsoft Technical Training Oppertunity appeared first on SQL Server Consulting & Remote DBA Service.

Legacy Applications: Should They Stay Or Should They Go?

Modernizing Legacy Applications Older legacy systems and legacy applications are crucial to a business's functionality. They're the backbone that holds a business together, whether they are a bank's mainframe holding customer accounts, a factory's…
John Sterrett from ProcureSQL attend the 2025 Microsoft Fabric Conference

The CIO’s Guide to Leveraging Microsoft Fabric for Competitive Advantage

,
I attended the Microsoft Fabric conference for the first time last week. I wanted to provide a guide that CIOs and CEO's could leverage to understand how they could utilize these new announcements at the 2025 Fabric Conference to obtain a competitive…
PreviousNext
Procure SQL string or binary data get truncated

Where did my string or binary data get truncated?

,
[Updated on 10/25/2018] With MSIgnite being this week tons of great new features are being announced.  While many will focus on Spark integration, performance tuning, security, and containers sometimes it's the simple things that give us…
Procure SQL Demystifying System Databases

Demystifying System Databases

, ,
Recently I have heard a lot of people discussing SQL Server System Databases.  The topic of system databases seems to be a deceptively basic one.  But how many people truly take the time to understand what system databases are and what…

Is external governance coming to SQL Server 2022?!?!

Every so often, when a new cumulative update (CU) comes out for SQL Server, I like to see what system objects are new and which ones have changed. With the cumulative SQL Server 2022 update eleven this month, I noticed some exciting views…

Import Databases to Azure SQL Database

, ,
I recently spoke at a conference and was asked what is the easiest way to import databases to Azure SQL Database. Therefore, I wanted to share how I do this with DBATools.io. You can use the same code to just export if you need a local copy…
Join Our Newsletter

Blog Categories

Tags

#SQLFamily Austin automatic tuning availability group azure backup Backups career Data Governance Data Loss Data Platform DBA Denver Differential Backup Disaster Recovery Fabric Full Backup High Availability Houston Marketing Database Administrator Microsoft Microsoft Fabric Microsoft SQL Server mirroring MVP parameter sniffing PASS performance tuning Professional Development query store Recovery Recovery Model Restores SQL Saturday SQL Server SQL Server 2017 sql server 2019 SQL Server 2022 sql server 2025 SSMS System Databases Transaction Log Backup tsqltuesday Tuning Wait Stats

Archives