Coding Family

Weekly reading #30

Good morning in November! We were all looking at the Microsoft Ignite in Orlando last week. And it happened! SQL Server 2019 is now generally available – more details...

2019-11-11

27 reads

Weekly reading #29

The Data Breach Game: The 9 Worst IT Security Practices Joey D’Antoni shows bad practices for security in SQL Server. He summarizes all the most important areas you should...

2019-10-21

12 reads

Interview with Bob Ward

This is the eight interview we have done. This time our guest is the one and the only Bob Ward! Bob Ward is a Principal Architect for the Microsoft...

2019-10-30 (first published: )

351 reads

Weekly reading #28

September is over. This was not a good month for us. We had to cancel the conferences planned for September and were not able to write as much as...

2019-10-10

20 reads

Interview with Joe Sack

This is the seventh interview we have done. This time our guest is Joe Sack! Joe is Principal Program Manager for Azure SQL Database with a focus on query...

2019-10-11 (first published: )

297 reads

Weekly reading #27

September is over. This was not a good month for us. We had to cancel the conferences planned for September and were not able to write as much as...

2019-10-01

13 reads

Interview with Greg Low

This is the sixth interview we have done. This time our guest is Greg Low!  I bet you know Greg as he is one of the most recognizable person...

2019-09-27 (first published: )

229 reads

Weekly reading #26

Good morning! It was a tough weekend as we supposed to be in Goteborg on #SQLSatGothenburg but unfortunatelly the flu hit us hard. The talk was handed over by...

2019-09-17

11 reads

Weekly reading #25

It has been a long time since the last weekly reading post. We have been in Shanghai and Bangalore during the time. We attended in #DPS10 in Bangalore –...

2019-09-11

5 reads

#DPS10 – preconfs

I have delivered a preconf on the biggest conference in Asia. The preconf was about Supervised and Unsupervised Machine Learning with bonus track about Semi-supervised solutions. This was really...

2019-08-21

1 reads

Blogs

Error: 8623 - The query processor ran out of internal resources and could not produce a query plan

By

 Unfortunately a common error in many of our client environments is this: -- Error: 8623, Severity:...

Goal Progress– October 2020

By

This is my report, which continues on from the Aug report. After that report,...

Daily Coping 30 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

sys.dm_db_index_physical_stats returning wrong object_ID in MSDB database

By jackaroe

I'm running an index maintenance script on the MSDB database that loops through a...

Do I need a trigger?

By CanuckBuck

I want to test a condition during an insert or an update and only...

SQLServer Always-On and Bitlocker

By Lioh

Hi all, we have installed MSSQL 2017 with HA and Always on AGs on...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Best Query

See possible answers