I am excited to share an important milestone in my life. My third book, “Administering Relational Databases on Microsoft SQL“, is released. Co-authored with Ahmad Yaseen and Rajendra Gupta,...
2021-04-19 (first published: 2021-03-09)
595 reads
A detail paradigm to support SQL on Azure cloud, DP 300 study guide, and explore the hidden side of cloud databases. Administering Relational Databases on Microsoft Azure takes readers...
2021-03-21
56 reads
?????????????????????? ???? ??????’?? ?????? ???? ?????????? ?????????????????? I have a very important announcement to make to all of you. Today on my birthday(16th March), I feel delighted and proud...
2021-03-16
27 reads
Introduction Ad hoc distributed queries use the OPENROWSET and OPENDATASOURCE functions to connect to remote data sources that use OLE DB. As the name suggests, ad-hoc distributed queries should...
2021-01-04
265 reads
Introduction The real-time data representation often requires quality content. In most cases, users flooded with multiple options or methodologies that may overwhelm the user to opt for the right...
2020-10-30
14 reads
Introduction The real-time data representation often requires quality content. In most cases, users flooded with multiple options or methodologies that may overwhelm the user to opt for the right...
2020-10-30
7 reads
It is not unknown to the SQL users that some of the SQL Server versions have become outdated. This is the main reason why most of the SQL Server...
2019-06-11
223 reads
It is not unknown to the SQL users that some of the SQL Server versions have become outdated. This is the main reason why most of the SQL Server...
2019-06-11
9 reads
Maintaining the SQL server database is always the first priority of the SQL administrators. But sometimes SQL database users have to face Microsoft SQL server error 5243 and error...
2019-05-21
213 reads
Maintaining the SQL server database is always the first priority of the SQL administrators. But sometimes SQL database users have to face Microsoft SQL server error 5243 and error...
2019-05-21
15 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers