This blog series on Audit/Compliance/Security, this is first blog where we would discuss about GRC and different audits and other important information, later we will discuss each audit frameworks...
2026-07-21
83 reads
As Open Source – PostgreSQL and AI is a growing and powerful DB system, AWS and Google already have AWS Aurora and Google AlloyDB, which are Cloud Native PostgreSQL...
2026-07-15 (first published: 2026-07-14)
105 reads
When you have a project or system, it has to be optimized, tuned, and we must ensure it is consistently performing better. For this, we should use the Lean...
2026-07-14
34 reads
The soul of project management is Process Group(PG) and Knowledge Area(KA). they are related and grouped as follows: Process Group[49] Knowledge Area with Process I will write detail blog...
2026-07-13
40 reads
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer a search engine. it is a Major IT company in the industry. having strong base...
2026-05-28
46 reads
In previous posts, we looked at the SQL Server engine. for us DBAs, the SSMS plays an important role for handling/Managing SQL Server. we have been using these tools...
2026-05-14 (first published: 2026-05-13)
52 reads
These days everything is changing to AI World, IT roles are getting changed and it is going towards AI ways, everyone in IT should be aware of AI –...
2026-05-07
49 reads
This week has training on AI – Cyber security experts – Omar Santos and Aamir Lakhani- with great knowledge . during the session learned about OpenClaw and more. I...
2026-04-29 (first published: 2026-04-17)
375 reads
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE which is introduced on SQL Server 2008, TDE is at rest has limitation as data...
2026-04-13 (first published: 2026-04-04)
286 reads
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this feature encrypts a physical layer of Database files Data/log files protection at Disk / storage...
2026-04-04 (first published: 2026-04-03)
52 reads
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Comments posted to this topic are about the item Server-Level Table sizes
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers