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…

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…
Machine Learning for Operational Efficiency

Machine Learning for Operational Efficiency

Every year, hundreds of billions of packages are shipped around the world. And in 2023 alone, that number broke the record at 356 billion shipped worldwide.   That’s a 100% increase since 2016. The industry will only get bigger…

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…
Quick Wins for SQL Server Performance Tuning Bottlenecks

SQL Server Performance Tuning: No Consultant Required

Are you tired of people complaining about your database's slow performance? Maybe you are tired of looking at the black box and hoping to find what is slowing your applications down. Hopefully, you are not just turning your server off and back…

Why Adopting a Modern Data Warehouse Makes Business Sense

Why Adopting a Modern Data Warehouse Makes Business Sense Most traditional data warehouses are ready for retirement. When they were built a decade or more ago, they were helpful as a mechanism to consolidate data, analyze it, and make business…

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 replication. Habits…

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…
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 services. We’ll…
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 and…

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 in high…

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 page here. What…

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…

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…
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 and…

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 Free SQL Education!

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,…
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 much…
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 is packed…

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 way every new…
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 haven’t given much thought to database integrity, now is the time to sit up and pay attention.  Corruption can occur at any time. …

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 purpose…
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 much…
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…

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…

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 this…

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 get…
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 way every new…

Does Your Database Have any Integrity?

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

Ignore_Dup_Key – the good the bad and the ugly

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…

Tuning Update Statement with SQL Server

,

You are out doing your scheduled sweeps of the environment and you notice a huge I/O consumer is one of your update procedures. Your initial thought may be to panic because how can you test data that is changing? You have several methods to tuning queries that adjust data that allow data to revert between […]

The post Tuning Basics – Updating an Update 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…
Heap not sorted like clustered Index

Clustered Index vs Heap

, ,
What is a heap? Heap was actually named pretty accurately. It is a “pile” of unsorted/unorganized data. A heap will exist on any table that lacks a clustered index. Heaps can exist even if you have a non clustered indexes. The main advantage to a heap is the speed at which you can insert data […]
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…
Heap not sorted like clustered Index

Clustered Index vs Heap

, ,
What is a heap? Heap was actually named pretty accurately. It is a “pile” of unsorted/unorganized data. A heap will exist on any table that lacks a clustered index. Heaps can exist even if you have a non clustered indexes. The main advantage to a heap is the speed at which you can insert data […]

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.

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…

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…
Machine Learning for Operational Efficiency

Machine Learning for Operational Efficiency

Every year, hundreds of billions of packages are shipped around the world. And in 2023 alone, that number broke the record at 356 billion shipped worldwide.   That’s a 100% increase since 2016. The industry will only get bigger…

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…
Quick Wins for SQL Server Performance Tuning Bottlenecks

SQL Server Performance Tuning: No Consultant Required

Are you tired of people complaining about your database's slow performance? Maybe you are tired of looking at the black box and hoping to find what is slowing your applications down. Hopefully, you are not just turning your server off and back…

Why Adopting a Modern Data Warehouse Makes Business Sense

Why Adopting a Modern Data Warehouse Makes Business Sense Most traditional data warehouses are ready for retirement. When they were built a decade or more ago, they were helpful as a mechanism to consolidate data, analyze it, and make business…

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 Summit…

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…
Heap not sorted like clustered Index

Clustered Index vs Heap

, ,
What is a heap? Heap was actually named pretty accurately. It is a “pile” of unsorted/unorganized data. A heap will exist on any table that lacks a clustered index. Heaps can exist even if you have a non clustered indexes. The main advantage to a heap is the speed at which you can insert data […]
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 and…

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 much…
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 is packed…

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!…

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…

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…
Machine Learning for Operational Efficiency

Machine Learning for Operational Efficiency

Every year, hundreds of billions of packages are shipped around the world. And in 2023 alone, that number broke the record at 356 billion shipped worldwide.   That’s a 100% increase since 2016. The industry will only get bigger…

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…
Quick Wins for SQL Server Performance Tuning Bottlenecks

SQL Server Performance Tuning: No Consultant Required

Are you tired of people complaining about your database's slow performance? Maybe you are tired of looking at the black box and hoping to find what is slowing your applications down. Hopefully, you are not just turning your server off and back…

Why Adopting a Modern Data Warehouse Makes Business Sense

Why Adopting a Modern Data Warehouse Makes Business Sense Most traditional data warehouses are ready for retirement. When they were built a decade or more ago, they were helpful as a mechanism to consolidate data, analyze it, and make business…

QUOTED IDENTIFIER Set Incorrectly?!

So What Is Going On? I recently ran into an issue when I set up a job to collect information from an extended event. I wanted to write that to a table in my scratch DBA database. This allowed the customer and I to slice and dice data with ease. This seemed easy enough. I […]

The post QUOTED_IDENTIFIER Set Incorrectly?! appeared first on dbWonderKid.

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 the…
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 purpose…

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 #sqlnewspeakers #TSQL2SDAY Angela Tidwell 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 SQL Server MVP New Hire 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 SSMS System Databases Transaction Log Backup Tuning Wait Stats

Archives