I thought my database was collation agnostic
My struggles with a customer's database that used a different collation sequence. The easy way is never the right way, or is it?
How to Create Deadlocks and Troubleshoot Them
Watch in awe and wonder as Brent Ozar creates a deadlock, then uses sp_BlitzLock after the fact to show you which queries and tables were involved.
Docker SQL Server 2017 Linux Containers with database cloning
Learn how containers can help with database development.
Script triggers from any database in SQL Server
In this tip Aaron Bertrand looks at how to generate scripts for triggers using simple T-SQL statements. This tip shows how to easily build scripts for disabling, enabling, dropping and creating.
Power BI – Part 1: Introduction
Power BI has been available for a number of years, but new functionality is added regularly. In this new series from Robert Sheldon, you will learn about the latest developments or get started with Power BI if you are new to it. Robert provides an overview of Power BI, the services and tools available in this article.
Introduction to Azure Cosmos DB Security
When analyzing security-related challenges, it is important to note that they encompass several distinct but interrelated technologies. In addition, when dealing with data services, it is also necessary to distinguish between the data plane, facilitating access to the underlying content and the management plane, which allows for delegation of administrative tasks. In this article, Marcin Policht explores how these concepts apply to the Azure Cosmos DB offering.
One law for me, another for EU
Phil Factor notes that the EU's approach to the GDPR seems to be "do as I say, not as I do".
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Alamat BCA KCP Tendean Telp:0821-8200-203
Telp/Wa 62 8218200203 Jl. Wolter Monginsidi No.129, RT.2/RW.2, Rw. Bar., Kec. Kby. Baru, Kota...
Alamat Kantor BCA KCP Tendean Telp:0817.82.5533
Telp/Wa 62 817825533 Jl. Wolter Monginsidi No.129, RT.2/RW.2, Rw. Bar., Kec. Kby. Baru, Kota...
Alamat BCA KCP Gandaria City Telp:0821-8200-233
Telp/Wa 62 8218200233 Gedung Mal Gandaria City Mainstreet-Upper Ground M-U25, Jl. Sultan Iskandar Muda,...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers