Why QUOTENAME is important
Why good use of QUOTENAME can easily prevent injection and unexpected behaviour in Dynamic SQL.
Why good use of QUOTENAME can easily prevent injection and unexpected behaviour in Dynamic SQL.
The State of SQL Server Monitoring was launched in 2018. This year we are interested in gathering insight across database platforms, not just SQL Server. Have your say and take the survey to be first to receive the report and enter your chance to win a $500 Amazon voucher.
Take the survey.
Do you remember the very first time you had to do a database restore to fix something you messed up?
The purpose of this article is to detail steps that would help implement an enhancement to reporting application that uses SQL Server Database (or any other database) in backend without causing downtime to reporting application.
Sometimes it is hard to admit that you are not the best person for the job that is presented to you.
This presentation is to get you thinking about the disaster recovery options for SQL Server, things like backups, log shipping, Availability Groups, clustering and more while putting them in the context of the enterprise.
You have more time to earn that MCSA, MCSE, or MCSD, thanks to Microsoft and the pandemic.
Delve behind the scenes and learn about the catalog used to manage Azure Data Lakes.
Delve behind the scenes and learn about the catalog used to manage Azure Data Lakes.
In SQL cursors serve as a pointer that enables application programming language to deal with query results one row at a time. This article quickly explores the concept behind and show how to declare cursors, open, retrieve data from them, and then close them
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Assignments aren’t just tasks to submit—they’re opportunities to build understanding, discipline, and problem-solving skills....
Comments posted to this topic are about the item What's new in R 4.6
Comments posted to this topic are about the item Interesting Changes in R, which...
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers