It's common knowledge among programmers that most of the ills of the software industry, and most particularly the companies where we work, could be solved by simply letting the technical people make the technical decisions. Obviously, since this is so incredibly logical and sensible, it's a given that most companies leave management decisions to managers, and technical decisions to the computer guys.
This article discusses an often-overlooked feature of SQL Server called user-defined data types.
A look at a fantastic new backup product from DBAssociates. This is the only 3rd party backup product that I would use or recommend.
Everyone does demos. You need them to sell your software, but the demo server presents some challenges. Continuing this series, this article looks at moving data between servers.
Andy discusses reasons why he thinks setting the default database to anything other than master is a mistake. We think he does a good job of covering the pros and cons, read the article and join the discussion!
How safe are your SQL passwords? Use these free tools to find out how secure your passwords are and generate more secure passwords.
In this example, we will attempt to get some statistical information on file-group utilization to assist us with IO monitoring.
Andy attended the recent PASS Community Summit and had a great time. Read some of the highlights from his perspective and maybe decide that you'll want to attend next year!
Like many other areas of business, the tech industry has weathered the occasional slump over the past few decades. It's only natural that the fate of techies is closely linked to the tides of the business. However, in any economy, weak or strong, some people prosper and advance while others suffer the consequences.
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