(Chris Webb) If you’ve ever built a BI solution it’s likely you will have had to integrate third party data, and if that’s the case you will know how painful it often is to get your hands on that data.
Tag: sql server
Is it just me or does msdb feel a lot like a user database?
(Kenneth Fisher) When you think of system databases, tables, etc there are a number of things you might think of.
Pass SSIS Variable from Parent to Child Package in SQL Server Integration Services
(Bhavesh Patel) When working with SQL Server Integration Services (SSIS), we might need a package that calls another package by executing a package task.
SQL SERVER – What is Wait Type Parallel Backup Queue?
(Pinal Dave) Recently one of my blog readers contacted me and ask if I knew about wait type parallel_backup_queue. I have often got the same question during the Comprehensive Database Performance Health Check.
SQL Server Data Masking with DbDefence
(Jeremy Kadlec) Data breaches are becoming too common place with some accounts reporting more than 1000 breaches per year with close to 50 million records exposed yearly in the financial, business, education, government and healthcare industries.
Top SQL Server migration questions
(James Serra) Below are the top 12 questions I am seeing from customers looking to migrate on-prem SQL Server to Azure, and the blogs that I have wrote that try to answer each question (I have updated most of these blogs):
SQL Server database design best practices and tips for DBAs
(Lindsay Moore) Knowing what you want from SQL Server is probably the biggest step toward running it successfully in business applications, according to consultant Koen Verbeeck.
SQL SERVER – Huge Space Used by Table sysxmitqueue in MSDB. How to Clear it Quickly?
(Pinal Dave) Recently I was helping a customer who hired me for my services. He had an issue where they noticed that the size of the MSDB database has grown huge.
Azure SQL Database SLA Updates
(blobeater) I am sure many missed the updates to Azure SQL Database SLA (Service Level Agreement). It used to be 99.99% across all tiers but split between two different high-availability architectural models.
Event Files on Linux
(Jason Brimhall) The second Tuesday of the month is upon us once again. That means it is time for another group blog party called TSQLTuesday.