Extended Events: Avoid the XML
One story I hear over and over goes like this: I tried setting up Extended Events, but then I saw the output was XML so I stopped. Look, I...
2021-04-08 (first published: 2021-03-29)
373 reads
Daily Coping 29 Mar 2021
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...
2021-03-29
17 reads
What is Transparent Data Encryption?
In this post we look at Transparent Data Encryption (TDE) in SQL Server. What it is - and how it works.
2021-04-07 (first published: 2021-03-29)
421 reads
Goal Progress–Mar 2021
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2021. As I look at goal progress for 2021, I’m going...
2021-03-26
21 reads
Issues When Using Temporary Tables in Nested Stored Procedures
SQL Server offers a lot of flexibility when working with objects like stored procedures and temporary tables. One of the capabilities is to allow for stored procedures to call...
2021-03-26
18 reads
Issues When Using Temporary Tables in Nested Stored Procedures
SQL Server offers a lot of flexibility when working with objects like stored procedures and temporary tables. One of the capabilities is to allow for stored procedures to call...
2021-04-06 (first published: 2021-03-26)
958 reads
Daily Coping 26 Mar 2021
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...
2021-03-26
22 reads
Moving Into Consulting 101 - Part 5 - The Tensions of a Consultancy
This is part five in a five part series this week, Moving into Consulting 101.
In the business consulting system, the clients are served by two separate yet equally important groups....
2021-04-07 (first published: 2021-03-26)
245 reads
Server Review Essentials for Accidental and Junior DBAs—Client Onboarding (Part 4)
Let’s take a look at the final few steps of your initial server intake process and get your workflow up and running as you push toward performing regular server...
2021-04-05 (first published: 2021-03-25)
319 reads
Daily Coping 25 Mar 2021
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...
2021-03-25
22 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
Alamat Kantor BCA KCU Galaxy Tlp:(08218154374)
WA CS 628218154374 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya,...
Alamat Kantor BCA KCU Malang Tlp:(08217555651)
WA CS 628217555651 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa...
Alamat Kantor BCA KCU Rungkut Tlp:(0817825533)
WA CS 628217825533 Jl. Raya Kendangsari Industri No.2, Kendangsari, Kec. Tenggilis Mejoyo, Surabaya, Jawa...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers