Beware of Mixing Collations - Part 1
A few months ago Greg Larsen ran across a big problem with SQL Server collation when querying. He shares his bruises in this quick article.
Pro Developer : Throwing Money Out the Window
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.
User-defined Data Type Basics
This article discusses an often-overlooked feature of SQL Server called user-defined data types.
SQL LiteSpeed - Lightning Fast Backups
A look at a fantastic new backup product from DBAssociates. This is the only 3rd party backup product that I would use or recommend.
Building a Demo Server - Part 2
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.
Setting a Default Database for your Logins
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 Passwords?
How safe are your SQL passwords? Use these free tools to find out how secure your passwords are and generate more secure passwords.
Utilizing fn_virtualfilestats
In this example, we will attempt to get some statistical information on file-group utilization to assist us with IO monitoring.
Comments on PASS Community Summit 2002
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!
Pro Developer: Improving Your Career In Any Economy
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.
Blogs
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Experience Next-Level Cooling Comfort with RCM AC Systems
ashes over you, making you forget the relentless sun outside. Instantly, your energy lifts,...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers