Watch this week’s video on YouTube. Imagine you need to join two tables of data and filter the results. Perhaps you also need to convert some of the values...
2020-08-10 (first published: 2020-07-29)
576 reads
Most of DBA are coming from On-premise Database Servers they know very well How we can manage SQL backup using SQL Server native backup or even using SQL Server...
2020-08-08
37 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One thing that helps ensure your data is...
2020-08-07 (first published: 2020-07-29)
286 reads
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-07
31 reads
I’m thrilled to support and participate in this year’s VMworld 2020 conference, which is going online due to COVID-19. I’m presenting a new session called “Architecting SQL Server Workloads...
2020-08-07
43 reads
This is a non-technical post, and my opinion. If you don’t want to read it, please ignore future posts with “Social:” at the start of the title. My nickname...
2020-08-07
23 reads
(2020-July-29) There is a well known and broadly advertised message from Microsoft that Azure Data Factory (ADF) is a code-free environment to help you to create ...
2020-08-07 (first published: 2020-07-29)
980 reads
I have now printed over 20,000 ear savers. I hit 20k printed yesterday on Aug 5th, exactly 4 months after starting this project. As of 7PM Eastern today, my...
2020-08-06
3 reads
I have now printed over 20,000 ear savers. I hit 20k printed yesterday on Aug 5th, exactly 4 months after starting this project. As of 7PM Eastern today, my...
2020-08-06
6 reads
I have now printed over 20,000 ear savers. I hit 20k printed yesterday on Aug 5th, exactly 4 months after starting this project. As of 7PM Eastern today, my...
2020-08-06
7 reads
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Hello, I think I need a recursive cte query but unsure of the logic....
Comments posted to this topic are about the item The Security of Old Tech
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers