QRCoder is an open source implementation of standards specification ISO/IEC 18004, which defines the requirements for two-dimensional QR Code symbols. It is a more complete implementation of the standard than the open source QRCode4CS library that was used in a previous article.
2018-10-22
45,650 reads
SQL Server DBAs are typically quite familiar with security and best practices in Windows but may not understand how security works in Linux. In this article, Kellyn Pot'Vin-Gorman demonstrates how to manage user accounts in Linux and why working while logged in as root is a bad idea.
2018-10-22
2,405 reads
Sharing our experience using Data Compression as a space savings option in MS SQL Server 2008
2018-10-19 (first published: 2016-01-18)
4,482 reads
In which you ask your assistant to fetch your coffee, and time them.
2018-10-19
3,120 reads
Auditing the password changes using LOGIN_CHANGE_PASSWORD_GROUP Server Level Audit Group.
2018-10-18
5,003 reads
As DBA's we are often looking for issues and hole is things, but it is also important to see positives and seek a better solution.
2018-10-18
99 reads
Azure contains a vast array of services that can be used for machine learning, text analysis, and more. In this article, Supriya Pande provides a brief explanation of machine learning and then walks you through creating a sentiment analysis application.
2018-10-18
3,009 reads
In this tip we look at how to use Azure quick start templates as well as how you can customize the templates to meet your needs.
2018-10-17
2,544 reads
I needed to speed up some regression testing. Redgate Sql Data compare API helped me do it.
2018-10-16
1,425 reads
Although concerns about ownership and security persist, many companies have embraced cloud services and are reaping substantial financial rewards as a result. Rob Gravelle describes the different cloud database categories, and shows us how to configure an Amazon RDS MySQL database.
2018-10-16
2,171 reads
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Comments posted to this topic are about the item Let's Talk Certifications
Comments posted to this topic are about the item The Hidden Security Risks of...
Comments posted to this topic are about the item The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers