Daily Coping 20 Aug 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-08-20
9 reads
Blog Posts
Extended Events Gets a New Home
One of the most versatile and awesome power tools given to SQL Server now has a new home! This new home will serve as a fabulous repository of extensive...
2020-08-20 (first published: 2020-05-18)
422 reads
Find All Heaps In Your Database
This is just going to be a quick post but I was asked the question the other day, how can I find all the tables in the database that...
2020-08-20
672 reads
SQL on-demand in Azure Synapse Analytics
The new SQL on-demand (to be renamed SQL serverless) offering within Azure Synapse Analytics opens up a whole new world of getting insights into data immediately, at low-cost, using...
2020-08-20 (first published: 2020-08-10)
937 reads
Azure SQL – Advanced Data Security [video]
A quick 2 minute overview video (from me) about ADS – Advanced Data Security. The unified package from Microsoft providing the ability to discover / classifying sensitive data, mitigate...
2020-08-19
14 reads
Daily Coping 19 Aug 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-08-19
7 reads
Decoding Helm Secrets
Helm is a great tool for deploying applications to Kubernetes. We can bundle up all our yaml files for deployments, services etc. and deploy them to a cluster with...
2020-08-19 (first published: 2020-08-10)
469 reads
Finally, PASS is a proper association now
For the longest time PASS was known as the Professional Association for SQL Server, and made all of its money from a single event each year, the PASS Summit. If...
2020-08-19
35 reads
My First Hand-built AWS CodePipeline
I’ve just completed my first, successful, AWS CodePipeline. I’m sorry to say it took me weeks to figure out just how simple this was. Frankly, it’s embarrassing. I already...
2020-08-19 (first published: 2020-08-10)
321 reads
Take off with the new Flight Simulator
On August 18th 2020, Microsoft launched the newest version of the most successful flight simulator ever developed. The program was first released in 1982 and is the longest-running, best-known,...
2020-08-19
117 reads
Blogs
Advice I Like: Failure
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Logged in as a member of an Azure AD Group Error while Deploying DACPAC
Quite a long title for a short blog post ??While deploying a DACPAC (from...
Data Conferences – Worth Every Dollar
By Kevin3NF
Some of the best career enhancers you can buy. Why I Go to...
Forums
A Place where AI Technology Shines
Comments posted to this topic are about the item A Place where AI Technology...
Question of the Day
Getting the Object Code
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers